Identify Excel worksheet names from Access

[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.

 

[Guest]

I don't believe there is a way without opening the file.

 

[Guest]

aaah, that's too bad !

Thank you for your answer.

 

[Mr. B]

aaah, that's too bad !

Thank you for your answer.






- Show quoted text -

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

 

[Guest]

Hi Mr. B

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

Nicodemus