Hey Guys,
I'm new to using Macros in Excel and am having problems.
Although I did not write this code, I believe that it's what I am looking for. I want to upload and append a ton of csv files, but I am getting a run-time error '424' object required message. This is the code:
I'm not sure what to do, can you help me?
Please Login or Register to view this content.
Last edited by ornamentalist; 03-11-2009 at 08:11 AM.
Hi,
Please follow the forum rule and warp your code between /code/ tag
Shijesh Kumar
http://shijesh.wordpress.com/
docmd suggests the code is for Access not excel
how can i make it for excel?
can anyone help?
what u r trying to achieve .. if u can tell.. i would be able to convert it to excel format..
Hi and thanks,
I have over 100 .csv files in a folder, I want to combine all of the data into a single excel file after running the code. Is that hard to do? I tried running that code but I kept getting the 424 message and unfortunately, I am unfamiliar with the Excel Macros Objects, really anything about it. Can you help me out?
Something like this.
No error checking in case 100 csv files exceeds row limit.
Assume csv file contains Field header row, which is only required for the first row.
No dates in csv that may get converted due to mmdd layout.
Please Login or Register to view this content.
Andy, you've saved me so much time.
Thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks