Hi,
I've tried to modify the code I found here : http://www.excel-easy.com/vba/exampl...rt-sheets.html. The code runs through but nothing is happening (no error messages are displayed). I'm not quite sure what's going wrong (the files are present in the said directory). Any help would be great! Here's my code :
Thanks,
Please Login or Register to view this content.
amphi
Last edited by amphinomos; 03-27-2014 at 11:23 AM.
Hi, I think maybe you need an additional \, that code is looking for files in C:\test\ which are named files_to_import*.xl??". I'd maybe suggest:
Please Login or Register to view this content.
Thanks ragulduy! That solved one of the problems but now I get an "Object variable not set error" on this line...Please Login or Register to view this content.
You need to define what "sheet" is.
I would also advise against using sheet as a variable name as it might clash with something already defined in the vba object model. mySheet would be better. Maybe try something like:
Please Login or Register to view this content.
I just deleted "total" as you set the variable twice but other than that the code worked. Many many thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks