Thanks.your formula is working.
On Wed, Nov 2, 2011 at 4:40 AM, dguillett1 dguille...@gmail.com wrote:
If you only have that many why not just do thru a formula where the
file does not have to be open. Notice the placement of the '
You could even use indirect to put in the
You are welcome. As I said, it would be easy to change the variables.
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Indrajit $nai
Sent: Wednesday, November 02, 2011 4:55 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Required help in macro / vba
Hi All,
I need your help regarding a macro issue. Suppose I have 5 folder in
different in my
computer desktop and each folder contains a excel file (same name).
Now I want a macro which will open each folder and then open the file and
will copy the
first cell then paste it in my current file
Hi All,
I need your help regarding a macro issue. Suppose I have 5 folder in
different in my
computer desktop and each folder contains a excel file (same name).
Now I want a macro which will open each folder and then open the file and
will copy the
first cell then paste it in my current file
If you only have that many why not just do thru a formula where the file
does not have to be open. Notice the placement of the '
You could even use indirect to put in the file name, etc
='C:\aa\[3.xls]Sheet24'!A3