Hi
I have report where I have to export data into it from a few different excel / csv files. In my report I want to be able to run a macro that will open up file 1 witha specified filename and path, copy in the data I need from a specified data range into a specified workbook and data range and then do the same again with another file,
Can anyone help
Thanks
Kerrold
What is the problem with recording what you want to do?
Sure. This can be done. Do you have a sample file that you can upload?
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]
Hi
Thank you for your replies so far... I have now recorded this and have got part of it to work.
How do i specify in the VBA that I want it to copy from cell A2 to the end of the data?
When I record this part it specifies a data range so when i run the macro again the data range changes and if there is more data than before it doesn't pick it all up?
Thanks
Kerry
Identify the lastrow using this -How are you managing with copying from several files? Are you using / running the same code over and over again till your files are done?
Please Login or Register to view this content.
Thankyou, will give that a try.
Yes I have 3 different exports so have duplicated the code amending the file paths and the data ranges accordingly for each one.
Many thanks
Kerry
You can change this code to suit your needs. This code checks a folder for xls files and opens each one and copies the data over. Then closes the file -Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks