need to allow user to input file name to import data

[kiwis]

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

 

[NickHK]

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:
Data>Import External Data>New Database Query

You can record a macro of whichever method you choose to get the basis of
the required code.

NickHK