I want to be able to copy data from a sheet called "timesheet.csv" in another work book and append it to a different sheet in the main work book.
any help would be fantastic!
Matt
I want to be able to copy data from a sheet called "timesheet.csv" in another work book and append it to a different sheet in the main work book.
any help would be fantastic!
Matt
Matt,
If you put this code in the main work book it will add a sheet with the data from your csv file.
Sheets.Add Type:=".....\timesheet.csv"
fill in the path of the csv file on the dots
Kaak
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks