LinkBack URL
About LinkBacks
Excel 2007, did not work for me
get.workbook(1) is not a valid function
Excel 2007, did not work for me
get.workbook(1) is not a valid function
You have to create the defined named formula "SheetNames".
Here's a small sample file created in Excel 2007 that demonstrates this.
List Sheet Names Excel 2007.xlsm
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
thx Tony
must have had a typo
what I was hoping for is Workbook-A getting the worksheet names in Workbook-B
You could use the method in one workbook then just use simple link formulas in the other workbook.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks