open a file as hidden

[mikeymay]

is it possible to open a .xls file as 'veryhidden'?

I want to check a variable input by a user to a list within a .xls file that is saved on a hidden folder.

If not possible I would like to open this file but the user not see that it is open or it be visible in any way.


Ta

[Webtest]

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.

[DKenny]

Or you could save the file as an AddIn, (.xla). That way the file is always opened as 'veryhidden'.

[mikeymay]

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?

[mikeymay]

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!!