hi all,
i have some problems when i want to copy data from other files.
I want to use Command button to open specific folder, which contains .csv files. When i'll choose one of the files the aplication should put all the data from the file to an excel sheet 1.
could you pls help me with this?
thx a lot
at the moment i have this:
Private Sub CommandButton1_Click()
ChDrive "C:\data"
sGetOpenFile = Application.GetOpenFilename("CSV Files (*.csv), *.csv")
End Sub
Do you want to copy the data from multiple csv files or just 1?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
data from one file in one sheet
so if i have 5 files i need to have 5sheets in one workbook
Use this code -
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks