B
b&s
Hi,
Excel97
Is it possible to get data from closed workbook, password protected, with
VBA?
Excel97
Is it possible to get data from closed workbook, password protected, with
VBA?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Dave Peterson
If you know the password, you can open that workbook, extract the values, and
then close the workbook.
With "application.screenupdating = false", it'll be pretty much transparent to
the user.
then close the workbook.
With "application.screenupdating = false", it'll be pretty much transparent to
the user.
B
b&s
Hi Dave, thanks for your reply.
Yes, I now the password; but I was just curious is there any possibility to
extract the values without opening the file.
Yes, I now the password; but I was just curious is there any possibility to
extract the values without opening the file.
D
Dave Peterson
Not that I know.
b&s said:Hi Dave, thanks for your reply.
Yes, I now the password; but I was just curious is there any possibility to
extract the values without opening the file.
B
b&s
Thank you for responding ...