Posted to microsoft.public.excel.programming

Dale[_15_] Dale[_15_] is offline

external usenet poster

Posts: 9

How to retrieve index of workbooks

Hi
I have 7 workbooks open at the same time. I use the master workbook to copy
one of each of the master worksheets into each of the other open workbooks.
How do I retrieve the index and not the name of each workbook? i.e.
workbook(2) and not workbook("test.xls").

Thanks for your help.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
using 3 tables in one spreadsheet and utilising index formula to retrieve information	Aaron Hodson \(Coversure\)	Excel Worksheet Functions	2	November 5th 07 01:40 PM
Retrieve Row index number	loren.pottinger	Excel Discussion (Misc queries)	6	August 30th 06 08:07 PM
retrieve column index...	Bob Bedford	Excel Discussion (Misc queries)	1	May 1st 06 01:22 AM
Retrieve Data from closed workbooks - Ron de Bruin	Ron de Bruin	Excel Programming	0	September 20th 04 07:30 PM
Retrieve Data from closed workbooks - Ron de Bruin	Myriam	Excel Programming	0	September 20th 04 06:47 PM

All times are GMT +1. The time now is 11:44 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us