Search:

MS Office Forum

Ask Question UnAnswered

Home » Forum » MS Office

RSS Feeds

Question when using Multiple Workbooks

Asked By: Phil Date: Aug 15 Category: MS Office Views: 814

I am new to VBA and had a bacis question:

I am using a collection of workbooks. When toggling betwqeen the
workbooks, How do I know which work book is currently selected?

1 Answer Found

Answer #1 Answered By: William Evans Answered On: Aug 15

ActiveWorkbook.Name will give you the filename of the currently selected
workbook.

Didn't find what you were looking for? Find more on Question when using Multiple Workbooks Or get search suggestion and latest updates.

Your Answer

Please login to post answer

Tagged:question multiple workbooks

Previous Post:

deleting columns

Next Post:

How to format a User Cell Data

Using code on multiple worksheets in a workbook

Prob running workbook activate code when workbook is opened by anot

Change Workbook's Name

Next Workbook or Previous Workbook

Making a Workbook as an Active Workbook without opening it

Run Macor in a closed workbook and refer to the closed workbook

Workbook Tracking Question

Using Exvba can I open an outlook message and then its excel workbook

Activate Workbook by using a variable

Using VBA To get and write values from other workbooks

Can't save/close workbook opened with GetObject using VBA

use Excel as Multiple NotePads but some questions

Best way to load multiple images across multiple classes in an appl

Workbook font?

Workbooks ( "personal.xls" ).IsAddin = True

excel asks for the project password when closing a workbook

Collate info within workbook

Problem with Workbooks.opentext problem

MOVING SHEETS BETWEEN WORKBOOKS

How to use Workbooks.opentext method in VB.NET

macro to get info from workbook thats name changes

Delete open workbook

reconcile data from samew workbook but in different sheet

List of objects on a worksheet within a workbook

Searching for data in workbooks

RSS Feeds:	Articles \| Forum \| New Users \| Activities \| Interview FAQ \| Poll \| Hotlinks
Social Networking:	Hall of Fame \| Facebook \| Twitter \| LinkedIn
Terms:	Terms of Use \| Privacy Policy \| Contact us

MS Office Forum

Question when using Multiple Workbooks

1 Answer Found

Your Answer

Related Post