VBA Identify Workbook

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

Guest

I need to write a macro that resides in workbook A. Using
Set fromarea = Application.InputBox("Where is the source
data?", , , , , , , 8)
fromarea.parent.name gives me the name of the worksheet
that I referenced (in another workbook). I need a way to
identify the workbook name as well. It is not
activeworkbook or thisworkbook.

Thanks.
 
Hi

It's strictly hierarchial:
fromarea.parent.parent.name
(or path or fullname or whatever WB property)

HTH. Best wishes Harald
 
fromarea.parent.parent.name Or fromarea.worksheet.parent.name

will give you the workbook name.
 
You must log in or register to reply here.

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

How to refer to a workbook? 3
Copying cells and formula from closed workbook to all sheets in open workbook 0
Reference a workbook level named variable. 8
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Worksheet copy problem 2
Adding a sheet to a workbook 1
Macro that opens a separate workbook to a specified worksheet whenthe active workbook is right mouse 8
Run macro from active workbook whose name keeps changing 20

Back
Top