Identify Excel worksheet names from Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello all,

is there a way to identify the worksheet names of an Excel file, without
opening the file, from VBA ? I've found a solution in the newsgroups, but it
opens the file. I wish to avoid the opening.

Thanks in advance for any help.
 
aaah, that's too bad !

Thank you for your answer.






- Show quoted text -
Click to expand...

Nicodemus,

Try using the code to open the Excel file but experiment with keeping
that instance of Excel not visible. You can open it that way. The read
the info you need then immediately close the file. The user will not
even be aware that it was opened.

Hope this helps.

Mr. B
 
Hi Mr. B

thanks for your idea, but I really don't want the files to be open.

Nicodemus
 
Back
Top