C
Col_H
Guest
Hi all - first post 
OK - I have a small module that processes a large number of spreadsheets by importing them using the TransferSpreadsheet command. Unfortunately, when I (regularly) receive these spreadsheet updates, they are all password protected using the Save As -> Options -> Password for Sharing option. At the moment I am overcoming this by opening all the spreadsheets and resaving without the security... and on this system saving a text file takes about 4 minutes...
I am hoping that the 'UseOA' parameter for the action is "Use Object Authentication" or something like that, but I cant seem to find any info on this paramater anywhere at all... except that its of type variant. Can anyone help me please?
Many thanks in advance,
Col
OK - I have a small module that processes a large number of spreadsheets by importing them using the TransferSpreadsheet command. Unfortunately, when I (regularly) receive these spreadsheet updates, they are all password protected using the Save As -> Options -> Password for Sharing option. At the moment I am overcoming this by opening all the spreadsheets and resaving without the security... and on this system saving a text file takes about 4 minutes...
I am hoping that the 'UseOA' parameter for the action is "Use Object Authentication" or something like that, but I cant seem to find any info on this paramater anywhere at all... except that its of type variant. Can anyone help me please?
Many thanks in advance,
Col
