Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Opening text files using macro
Look at this site Tom
http://www.cpearson.com/excel/imptext.htm -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl "Tom Arcati" wrote in message ... I have been trying to write a macro that will open several text files (Tab seperated text) and put them in several worksheets within one workbook. This allows all date to be compiled and graphed. I can only get this to work if I "hard code" the text file path and name in the macro. This is not what I need or can use. What I want to do is have the file name defined in a cell and have the macro get the file name from there. This would allow the user enter the files he needs to bring into the workbook. I could not find any infomation for this in the help files. Help please! Tom |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Opening Files - Macro | Excel Worksheet Functions | |||
Opening text files | Excel Discussion (Misc queries) | |||
Opening Files Using a Macro | Excel Discussion (Misc queries) | |||
Macro for opening files that changes names | Excel Discussion (Misc queries) | |||
Opening large text files | Excel Discussion (Misc queries) |