RE: $$Excel-Macros$$ Assign already open workbooks name to variables using wildcard

2014-09-04 Thread Nitin Balodi
--"Do all the good you can,By all the means you can,In all the ways you can,In all the 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-mac

Re: $$Excel-Macros$$ Assign already open workbooks name to variables using wildcard

2014-09-04 Thread Paul Schreiner
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

RE: $$Excel-Macros$$ Assign already open workbooks name to variables using wildcard

2014-09-04 Thread Nitin Balodi
: $$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

Re: $$Excel-Macros$$ Assign already open workbooks name to variables using wildcard

2014-09-04 Thread Paul Schreiner
- From: Nitin Balodi >To: "excel-macros@googlegroups.com" >Sent: Thursday, September 4, 2014 1:58 AM >Subject: $$Excel-Macros$$ Assign already open workbooks name to variables >using wildcard > > > > >Hi Experts, > >I require your help in

$$Excel-Macros$$ Assign already open workbooks name to variables using wildcard

2014-09-03 Thread Nitin Balodi
Hi Experts, I require your help in another problem. I have n excel files already opened but want to assign file name to variables like File1 = ForecastLastUpdated_*.xls* File2 = ForecastLastUpdated_ReferenceInformation*.xls* Highlighted in red are file name pattern and will be using these varia