$$ Assign already open workbooks name to variables
using wildcard
To: excel-macros@googlegroups.com
So, your macro opens all of the (5) workbooks in the folder.You can still use
the loop I've described and use if/elseif/endif like: Sub ListOpenWorkbooks()
Dim wb As Workbook
Dim file1,
e places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-
From: Nitin Balodi
>To: "excel-macros@googlegroups.com"
>Sent: Thursday, September 4, 2014 8:12 AM
>Subject: RE: $$Excel-Macros$$ Assign alrea
: $$Excel-Macros$$ Assign already open workbooks name to variables
using wildcard
To: excel-macros@googlegroups.com
I'm not sure what you're expecting with the wildcard. perhaps you could give
specific examples? The Workbook object contains all of the open workbooks. You
can loop through th
I'm not sure what you're expecting with the wildcard.
perhaps you could give specific examples?
The Workbook object contains all of the open workbooks.
You can loop through the Workbook object and save the filenames in a variable
or array, like:
Option Explicit
Sub ListOpenWorkbooks()
D
