Import Excel properties with "hidden" status - possible macro?
I need for certain properties to be checked as "hidden" when I import an Excel file. This does not seem to be possible with the import process and therefore it forces us to manually select all the properties in the imported map and mark them as "hidden". This is a manual/tedious task that could be avoided if we could somehow import the "hidden" flag in the Excel source file. Is this at all possible? If not, as a workaround, is there a way to use a macro or rule to do this after the import?