Thanks very much ,but unfortunately its not importing the file into
the desired workbook
On Sep 19, 9:11 pm, NOORAIN ANSARI noorain.ans...@gmail.com wrote:
Dear Ajjw,
Please try.
and see attached sheet..
*Sub import_csvfile()
On Error GoTo abc
Dim csvfile
csvfile =
Dear Ajjw,
It's macro is working fine on my worksheet. Can u share a sample sheet with
us.
--
Thanks regards,
Noorain Ansari
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/
On Tue, Sep 20,
i am very new to vba programming in excel.
So pls help me
I would like to import a csv file daily into a fixed workbook by
asking the name of the csv file from the user.
--
--
Some important links for excel users:
1.
Dear Ajjw,
Please try.
and see attached sheet..
*Sub import_csvfile()
On Error GoTo abc
Dim csvfile
csvfile = Application.GetOpenFilename(CSV (*.CSV),*.CSV, , Please select
CSV file...)
Workbooks.OpenText Filename:=csvfile, Origin:=xlWindows, StartRow:=1
With ActiveWorkbook