Open file from vba

[Juan]

Hi all...

I have a macro that extracts a series of data that comes
on text format on several files and exports them into a
workbook, it used to be arround 30 files each time so I
renamed them: 1.doc, 2.doc, 3.doc and so on so that the
macro could find them and open them. now I need to rename
arround 600 files, is there a way to open a file from vba
regardless of the name? OPEN NEXT or something like that??
Or can anyone sugest a macro to rename all the files into
the previos format (1.doc, 2.doc,...,2000.doc)?

Any help is greatly appreaciated...

regards
JS

 

[Juan Pablo González]

Hi all...

I have a macro that extracts a series of data that comes
on text format on several files and exports them into a
workbook, it used to be arround 30 files each time so I
renamed them: 1.doc, 2.doc, 3.doc and so on so that the
macro could find them and open them. now I need to rename
arround 600 files, is there a way to open a file from vba
regardless of the name? OPEN NEXT or something like that??
Or can anyone sugest a macro to rename all the files into
the previos format (1.doc, 2.doc,...,2000.doc)?

Any help is greatly appreaciated...

regards
JS

You could adapt the code from here:

http://www.contextures.com/xlfaqMac.html#LoopBooks

to use *.doc instead of *.xls

 

[Juan]

Beautiful

Works great, thanks Juan!!!

-----Original Message-----


You could adapt the code from here:

http://www.contextures.com/xlfaqMac.html#LoopBooks

to use *.doc instead of *.xls

--
Regards,

Juan Pablo González


.