MeMikeExcel
New Member
Hello,
I have a modify protected excel file and wanted to access it in the background to extract some data to another workbook without opening it.
Is it even possible to do such task using VBA ? Since the file is modify protected, a message automatically pops up to select Read-Only or enter the password when it is open. The pops up of the message box affects and interrupts the automation process with the VBA code. I would need to manually click on the Read-Only option to open the file before continuing the automation with the VBA Code. So, any suggestion to resolve this issue would be greatly appreciated.
I have a modify protected excel file and wanted to access it in the background to extract some data to another workbook without opening it.
Is it even possible to do such task using VBA ? Since the file is modify protected, a message automatically pops up to select Read-Only or enter the password when it is open. The pops up of the message box affects and interrupts the automation process with the VBA code. I would need to manually click on the Read-Only option to open the file before continuing the automation with the VBA Code. So, any suggestion to resolve this issue would be greatly appreciated.