Hide column in multiple files in subfolders from folder

Hi Ralleberg,

I don't have a sharpoint folder source to test on but the below works in a normal environment in regards to the folder and subfolders.

If it finds that the column is already hidden then it will move on, as far as the error handling goes we would need to see the potential errors that could be created to be able to haandle them. The code will generally just stop if there is an error until the error is handled - it is within the handling part where you could set up an error log. Anyway I digress, I will leave the code below:

Please Login or Register  to view this content.

Hope this helps

Thank you both CheeseSandwich and maniacb.

Both approaches did the job. Thank you so much. I've added rep for the answers.

Originally Posted by CheeseSandwich

Hi Ralleberg,

I don't have a sharpoint folder source to test on but the below works in a normal environment in regards to the folder and subfolders.

If it finds that the column is already hidden then it will move on, as far as the error handling goes we would need to see the potential errors that could be created to be able to haandle them. The code will generally just stop if there is an error until the error is handled - it is within the handling part where you could set up an error log. Anyway I digress, I will leave the code below:

Please Login or Register  to view this content.

Hope this helps

Hi again,

I need an addition to the code above that I need assistance with. The code looks correctly in the selected folders, but also takes .pdf and other file types into the loop, and makes quite a few corrupt files.
the code should only take file types like .xlsm, xlsx to be taken into account within the specified folders, but how and where do I add this the code?

Thank you in advance, Rasmus