Previous Topic Next Topic

Macros

Closed
vinu - Oct 6, 2009 at 10:34 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Oct 6, 2009 at 08:42 PM
Hello,
I need to copy paste data between 2 excel files. I need to do this same kind of copying & pasting between different pairs of excel files.
I created a macro between one such pair and saved it in 'Personal.xls'. But then when I try copying & pasting between a different pair of similar excel files, the macro keeps asking for the files I used for creating the macro and does not do the task for this pair of excel files. Help!

1 response

Answer 1 / 1
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Oct 6, 2009 at 08:42 PM
Is there a mention of workbook names in your code. What variable did you use to define the two workbooks. Please post your code.
0

Similar discussions

Macro-Copy data from one workbook to another
Krishna -
Dvibe -

12 responses
One Button To Execute Two Macros
azmiismail -
azmiismail -

4 responses
Automation of running excel macros
Ped -
Aurorian -

11 responses
enabling macros on shared workbooks
SARC -
Petros -

4 responses
combining two separate macros into one
kat -
Devarajan -

8 responses