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 |
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 |
All times are GMT +1. The time now is 09:31 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com