[VIEWED 4975
TIMES]
|
SAVE! for ease of future access.
|
|
|
Sukuchha
Please log in to subscribe to Sukuchha's postings.
Posted on 06-10-08 4:35
PM
Reply
[Subscribe]
|
Login in to Rate this Post:
0
?
|
|
Hello ,
I am a novice in a VBA excel and i am facing a problem which is as follows: I need to open 50 xls files and store its filename as erray function so that i can use it for further calculation.
Thanks
|
|
|
|
Maverick_
Please log in to subscribe to Maverick_'s postings.
Posted on 06-10-08 7:59
PM
Reply
[Subscribe]
|
Login in to Rate this Post:
0
?
|
|
What is ur problem? to open or to save??
|
|
|
nepalikanchha
Please log in to subscribe to nepalikanchha's postings.
Posted on 06-10-08 9:06
PM
Reply
[Subscribe]
|
Login in to Rate this Post:
0
?
|
|
LOL! Yes, please elaborate.
|
|
|
Raj_Raj
Please log in to subscribe to Raj_Raj's postings.
Posted on 06-10-08 11:17
PM
Reply
[Subscribe]
|
Login in to Rate this Post:
0
?
|
|
Create a table in access and import all the spreadsheets in the table...Do you calculation or whatever..Much easier......
|
|
|
techGuy
Please log in to subscribe to techGuy's postings.
Posted on 06-10-08 11:19
PM
Reply
[Subscribe]
|
Login in to Rate this Post:
0
?
|
|
|
|
|
akawi
Please log in to subscribe to akawi's postings.
Posted on 06-11-08 8:36
PM
Reply
[Subscribe]
|
Login in to Rate this Post:
0
?
|
|
Make a file such as "files.txt" with the names of all excel files in it. In your macro add: Open "files.txt" For Input As #1 For i = 1 To 100 '(number of files =100) Input #1, fName ' fName is the name of file. *********** 'Add your macro here: eg., workbooks.open(fName) ' Other scripts
workbooks(fName).close 'better to close the excel file before opening next ************
Next i Close #1 'don't forget to close the text file
|
|