LinkBack URL
About LinkBacks
Hi,
I have 2 workbooks, aaa.xls and bbb.xls.
I will like to copy information from bbb.xls (cell N14) to aaa.xls (cell F4). But I do not know what the VBA code can use.
Please help.
Hi,
I have 2 workbooks, aaa.xls and bbb.xls.
I will like to copy information from bbb.xls (cell N14) to aaa.xls (cell F4). But I do not know what the VBA code can use.
Please help.
Last edited by alexnkc; 11-21-2013 at 11:22 PM.
Try this attached sample. This file must be in the same directory as bbb.xls file to work.
Is there other way to copy data from closed workbook (without even needed to open it)
Try to avoid code below:
Please Login or Register to view this content.
Try this then:
Please Login or Register to view this content.
Have considered referencing the data with a formula, instead of copying with VBA?
something as simple as =[bbb.xls]Sheet1!$N$11
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thanks millz and FDibbins..
It is working...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks