Hi,
I am trying to copy data from one workbook that is on specific location and then paste data to the another workbook and then save the 'another' workbook with specific name.
I am able to save workbook but I am unable to copy data from one workbook to another. code gives an error. Below is my code. Please help.
Please Login or Register to view this content.
Try this.
If it errors again, report which line is highlighted by the debugger and the error description.Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Hi Alpha,
thank you so much.
Code worked as I wanted. Just wanted one tweak here.
When the workbook - "LearnersinMandateDataExport_3657.xls" is already open. It gives a msg box that workbook is already open.
Could you please suggest the change if the workbook is already open. So instead of going to that path, it just go to the opened workbook.
Originally Posted by AlphaFrog
Try this.
If it errors again, report which line is highlighted by the debugger and the error description.Please Login or Register to view this content.
Last edited by aman2059; 01-24-2016 at 06:31 AM.
You're welcome.
Try this.
Please Login or Register to view this content.
This is solved. Thanks once again.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks