run macro from workbook A to perform on workbook B

**therealjag** · 11-13-2009, 06:43 AM

Hi there,

I currently have 2 workbooks. Workbook A contains the macro that I have created. Workbook B is a workbook that has been given to me by a work colleague that I dont want to modify or add any modules to.

Basically my macro is functioning, but I when I call it I dont want it to operate on Workbook A I want it to operate on a particular sheet in Workbook B.

I seen from a lot of posts on the net that the following code

Please Login or Register  to view this content.

seems to be able to do this but I believe from what I have seen, you have to add this to Workbook B in my case, and I dont want to do this as I want to keep the original workbook intact.

Is there a way to do this? If you need the workbooks I am working on I can provide them upon request but Im sure the syntax isn't too demanding - I hope!

cheers for any help,

Jag

**broro183** · 11-13-2009, 07:06 AM

hi Jag,

Yes, this can be done & probably without the use of "application.run", it all depends on how you define your sheet/range to be acted on.

I suspect that your code may currently be referencing the "activesheet". If so, this needs to be changed to a more explicit reference for example something like

Please Login or Register  to view this content.

.
Can you please post your existing code?

hth
Rob

**therealjag** · 11-13-2009, 07:12 AM

Hi there, yeah well I've tried the code below, but it still only seems to work on the current workbook, or workbook A in my example:

Please Login or Register  to view this content.

Jag

**broro183** · 11-13-2009, 06:36 PM

hi Jag,

This may work...
If not, can you please provide more detail eg where does the code error?) & perhaps even upload 2 example workbooks?

Please Login or Register  to view this content.

hth
Rob

**therealjag** · 11-19-2009, 11:27 AM

Hi there,

I've tried the above method within my workbooks but I still cant seem to get it working. All it seems to do is just add another new sheet onto the target workbook but doesnt do anything else.

Does anyone know what I am doing wrong with the following code:

Please Login or Register  to view this content.

Cheers,

Jag

**broro183** · 11-20-2009, 08:23 AM

hi Jag,

I may not be near a computer for the next few days so hopefully somone else can help you...
Can you please upload a sample file with the actual layout, some hyperlinks & your latest version of the macros?

Does anyone know what I am doing wrong with the following code:...

The code you've posted in post 5 is seems to have grown from your original code. It would be helpful if you could tell us where/if it errors. Also can you please explain in normal sentences, what your intent of the below lines of code?

Please Login or Register  to view this content.

To try & track down the error, can you please retry my post 4' code with the below section replacing the similar code that's listed in post 4?

Please Login or Register  to view this content.

hth
Rob

run macro from workbook A to perform on workbook B

LinkBack

Thread Tools

Rate This Thread

Display

run macro from workbook A to perform on workbook B

Re: run macro from workbook A to perform on workbook B

Re: run macro from workbook A to perform on workbook B

Re: run macro from workbook A to perform on workbook B

Re: run macro from workbook A to perform on workbook B

Re: run macro from workbook A to perform on workbook B

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions