Re: open a file as hidden
What application are you using to operate on the data? You can fetch the data directly from the file with ADO (or DAO) without 'opening' the file at all. You just establish a data connection to the file.
Re: open a file as hidden
Or you could save the file as an AddIn, (.xla). That way the file is always opened as 'veryhidden'.
Re: open a file as hidden
I will be using the file in Excel. Specifically a user form will be populated and dependant on the data on the form I want to pull specific data from the hidden file.
This file needs to have a password to view so if I can pull information from it without opening that would be best. How do I do it?
Re: open a file as hidden
Hmmm, just saved a file as .xls and marked as Hidden in explorer.
How do I open to amend? When I open it I can't see it!!!!
Doh!!