Getting the name & path of a hidden WB

R

Raz

Hi,

Is there any way to get the name of a hidden WB in which the code is written?

Ofcourse using "Activeworkbook.Name" will give me the name of the active wb
and since the wb I'm trying to get is hidden, it's not really active.

I also tried "Windows(1).caption" but whenever I open another workbook the
index of the hidden workbook might change.. I can't expect the order the user
will open the workbooks..

I want the macro to give me the name of the workbook in which it's written.

is there any way to do it?

thanks.
 
R

Raz Boyarski

Hi,

you've solved my problem.
you have no idea how much time I spent on trying to get the solution to the
problem..

I had no idea it's that easy.

thank you very much!
 

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

Move one ws to new wb. Save new Wb with same but modified name as original WB 2
closing another file by code causes failure to run workbook activate event 2
Activate workbook using partial name 5
Copying worksheet from hidden instance of Excel 1
Closing one workbook with a varying name 3
Open wb from a wb and run a macro 3
access data from a closed wb protected with password without openi 6
Error message 1004 2

Top