| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open file from vba
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Open file from vba
Juan wrote:
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 he http://www.contextures.com/xlfaqMac.html#LoopBooks to use *.doc instead of *.xls -- Regards, Juan Pablo González |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Open file from vba
Beautiful
Works great, thanks Juan!!! -----Original Message----- Juan wrote: 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 he http://www.contextures.com/xlfaqMac.html#LoopBooks to use *.doc instead of *.xls -- Regards, Juan Pablo González . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Unable to open a 82 KB XLSM file due to "Too many different cellformats" & "Converter failed to open the file." errors. | Excel Discussion (Misc queries) | |||
| Unable to open a 82 KB XLSM file due to "Too many different cellformats" & "Converter failed to open the file." errors. | Setting up and Configuration of Excel | |||
| excel 2003 saved file will not open without a blank workbook open | Excel Discussion (Misc queries) | |||
| In Excel - Use Windows Explorer instead of File Open to open file | Excel Discussion (Misc queries) | |||
| How do I stop Excel from closing the open file each time I open a. | Setting up and Configuration of Excel | |||
![Juan[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
