Embed or import one excel workbook to other vba
I have a multiple workbooks which has columns to Workbook and I have standard a standard excel file. All i have to copy each workbook into standard template and save the template with cell D1 and re56yrsasz z s,m`nbx xsnww212 3peat the processes for all workbooks
Process in detail:
Say I have workbooks as 1.xslx; 2.xlsx; 3.xslx; etc., in a particular folder
and i have standard Excel template (Xlsm)
data from (specific columns) each workbook gets copied to excel template and save the template as cell d1 of workbook
how do I create a vba to do this?
I have found some help here but how can read all the excel workbooks?
http://officetricks.com/different-methods-to-import-data-from-external-excel-file/
hope I am clear
Process in detail:
Say I have workbooks as 1.xslx; 2.xlsx; 3.xslx; etc., in a particular folder
and i have standard Excel template (Xlsm)
data from (specific columns) each workbook gets copied to excel template and save the template as cell d1 of workbook
how do I create a vba to do this?
I have found some help here but how can read all the excel workbooks?
http://officetricks.com/different-methods-to-import-data-from-external-excel-file/
hope I am clear
Roy Cox
Attach an example of the source workbooks and the master workbook
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi Roy, nothing seems to happening when i click on import. I have multiple workbooks in the source folder and i have created a folder with "data" and an excel file. when i click on it.. nothing is happening. this query is linked to the previous question i have asked. as I was able to create multiple workbooks I am posting this question
https://www.experts-exchange.com/questions/28971244/VBA-to-copy-paste-columns-form-one-file-to-other.html?anchor=a41811112&anchorAnswerId=41811112#a41811112
https://www.experts-exchange.com/questions/28971244/VBA-to-copy-paste-columns-form-one-file-to-other.html?anchor=a41811112&anchorAnswerId=41811112#a41811112
The code works perfectly on the sample files. Reading the other question is that creating files for each name in the workbook?
I'm going out for an hour or so but I'll check when I get back.
I think I need to work on your previous question first.
I'm going out for an hour or so but I'll check when I get back.
I think I need to work on your previous question first.
ASKER
Sure Roy.. thanks a ton!! for all your help. please bear in mind..output is an upload template to oracle and the data needs to be pasted from row10. again thanks a lot. appreciate it a ton!!!
I have answered your previous question.
This code works for me here, but I think it is unnecessary now that my other code produces the files. Let me know if you need any more help.
This code works for me here, but I think it is unnecessary now that my other code produces the files. Let me know if you need any more help.
ASKER
Simply great
Pleased to help