Hi,
I have excel files from file1, file2, file3,........file10. I need a macro to import all the file. Is there any solutions for it?
Hi,
I have excel files from file1, file2, file3,........file10. I need a macro to import all the file. Is there any solutions for it?
Yes this is possible. Is there just 1 sheet in each file that needs to be imported?
Are all the files stored in one folder?
You want to import the files into a new excel file? or an existing excel file?
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]
I want all these files to be imported to access.
Here is a link to help
http://www.accessmvp.com/kdsnell/EXCEL_Import.htm
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks