D
D
Hi,
I've got a password protected Excel file and I use
TransferSpreadsheet to update a data tab from an Access
query.
I was hoping to find a way to do this so my data tab can
be included within the other reporting & calculating tabs
of my file.
The file is password protected so that people cannot
change any of the underlying data or formulas. The data
isn't very sensitive in nature.
I 1st had the file unprotected and the TransferSpreadsheet
command worked fine. I then added the password protection
to the file and I can't get the command to work. I thought
the macro would run fine as long as I had the Excel file
opened (with the password) in the background.
I'm fairly open to any type of solution.
I've got a password protected Excel file and I use
TransferSpreadsheet to update a data tab from an Access
query.
I was hoping to find a way to do this so my data tab can
be included within the other reporting & calculating tabs
of my file.
The file is password protected so that people cannot
change any of the underlying data or formulas. The data
isn't very sensitive in nature.
I 1st had the file unprotected and the TransferSpreadsheet
command worked fine. I then added the password protection
to the file and I can't get the command to work. I thought
the macro would run fine as long as I had the Excel file
opened (with the password) in the background.
I'm fairly open to any type of solution.