data from closed workbook password protected

  • Thread starter Thread starter b&s
  • Start date Start date
B

b&s

Hi,
Excel97
Is it possible to get data from closed workbook, password protected, with
VBA?
 
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.
 
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.
 
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.
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Protection 2
Password Protection 7
Must I use IRM to protect an entire workbook? 1
Is it possible to copywrite a workbook? Or other protection option 6
Password protect macros in Excel 5
password protected workbooks with links between them 2
Shared Workbook Protection 1
Password protected and shared workbook 1

Back
Top