Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Opening multiple text files
I need a macro to open around 30 comma-delimited text
files. I plan to have the macro prompt the user to select the files to be opened but have the macro select the text parameters (comma delimited) instead of the user having to specify the parameters 30 times. After the files are opened, the macro will combine the files into a single sheet. I know how to do that step. It's the opening that I can't figure out. Thanks in advance for any help with this. I also welcome any ideas for opening and combining the files in a single step. By the way, what is the limit of the number of workbooks that can be opened at the same time? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MULTIPLE FILES OPENING | New Users to Excel | |||
opening multiple files into one workbook, but multiple worksheets.... | Excel Discussion (Misc queries) | |||
opening multiple .txt files from multiple folders | Excel Discussion (Misc queries) | |||
How can I view files chronologically when opening multiple files | Excel Discussion (Misc queries) | |||
Opening multiple files | Links and Linking in Excel |