Thread: need to allow user to input file name to import data
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
kiwis kiwis is offline
external usenet poster
  
Posts: 24
Default 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

Reply With QuoteReply With Quote