0
I think I already know the answer to this ("NO!") but I thought I would reach out and hope that someone can prove me wrong.
I have a lot (tens of thousands) of Excel spreadsheets that I will be imaging (printing to TIFF) for a client. They have just added a new wrinkle to request the gridlines and the column headers on the resultant TIFFs.
Is there a way to force this from the registry? Or would it require opening each document and checking the correct boxes?
Sadly, they are not -- these documents are being imaged for legal review, and our current process does not lend itself to moving classes of document types around the file system willy-nilly. – dreynold – 2010-11-11T19:24:58.153
i added a working example of what the macro would look like to my answer, in case it might help you. although you can not consolidate the files for a single run, it may still help if you do have more then one file per folder in places. – Xantec – 2010-11-11T19:47:21.207
Thanks for that! It gave me the crucial bit (foo.PageSetup.PrintGridlines = True) I needed to implement this in python. – dreynold – 2010-11-17T19:45:37.387