shadow12345
Well-known Member
- Joined
- May 10, 2004
- Messages
- 1,238
I would like to provide the user with a file open box for them to select a .csv file to open.
Once open I would like to copy all data in that file to sheet called "Current Day" in my workbook called "Testing", then close the .csv file they opened.
Can anyone help?
(ps im thinking that the open file dialog box should be easy to call but im not sure if the macro will wait for the user to open the file before it continues or what)
Once open I would like to copy all data in that file to sheet called "Current Day" in my workbook called "Testing", then close the .csv file they opened.
Can anyone help?
(ps im thinking that the open file dialog box should be easy to call but im not sure if the macro will wait for the user to open the file before it continues or what)