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

closing another file by code causes failure to run workbook activate event 2
Dynamic Naming of Form Button 3
Move one ws to new wb. Save new Wb with same but modified name as original WB 2
Code to delete names works in one WB, but not another WB? 2
Error message 1004 2
Copying worksheet from hidden instance of Excel 1
Delete sheets code error requires object 2
Activate workbook using partial name 5

Top