How to write Macros function to open other Excel files?
Hello
I need help please, I want to write a function in Macros enables me to have pop up window, and from that window i can choose another excel file and import it to my spread sheet then import another file to second sheet and so on??
thanks and regards
So you want each file to be selected and then imported?
How about the macro opening each file from a folder, importing the data and then closing each one?
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]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks