Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
need to allow user to input file name to import data
Hi
Need some help on how to prompt the user for the input file (a CSV file) & the macro will copy all the data in the input file into another excel file summary & on worksheet named raw. The input file is a CSV file with only 1 worksheet. I do not need to open this file. The input file is in the same folder as the summary file. any ideas or suggestions are welcome Thank you |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
need to allow user to input file name to import data
To get the filename from the user, use: Application.GetOpenFilename How can you copy the data if you do not intend to open the file ? You can query the file instead: DataImport External DataNew Database Query You can record a macro of whichever method you choose to get the basis of the required code. NickHK "kiwis" wrote in message oups.com... Hi Need some help on how to prompt the user for the input file (a CSV file) & the macro will copy all the data in the input file into another excel file summary & on worksheet named raw. The input file is a CSV file with only 1 worksheet. I do not need to open this file. The input file is in the same folder as the summary file. any ideas or suggestions are welcome Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
User input for import data function | Excel Discussion (Misc queries) | |||
macro to save as a data input by user file name from a designated | Excel Discussion (Misc queries) | |||
Opening a file with User Input | Excel Discussion (Misc queries) | |||
How to input file name in user form | Excel Programming | |||
User Input File Name | Excel Programming |