Code to detect previous active workbook instead of current active workbook

**kosherboy** · 02-20-2014, 06:14 PM

Hello.

I have two workbooks open. The first workbook will always have a different filename but the second workbook will always be called "Chart1". I have a code that inserts the first (unknown) workbook into "Chart1" but for some reason the code is hyperlinking "Charts1" into "Charts1"

!

Please Login or Register  to view this content.

I think the code is detecting the active workbook as the hyperlinked file which is "Chart1" instead of the previously open workbook. So if the code can take the previous open workbook then I think this code would work properly.

Thanks in advance

**HaHoBe** · 02-21-2014, 01:34 AM

Hi, kosherboy,

one way to solve the issue might be to loop through the orkbooks in the instance and get the name of the first workbook which isn´t the destination workbook like:

Please Login or Register  to view this content.

Ciao,
Holger

**kosherboy** · 02-21-2014, 09:40 AM

Hi Hahobe, nice to see you again.
I plugged in your code but it did not insert any hyperlinks. Here is the file that I'm inserting into "Chart1.xlsm": "2014-02-20 no.430430 Product.xlsm"

Thank you.

**HaHoBe** · 02-21-2014, 12:55 PM

Hi, kosherboy,

you would need to start the macro from witin Chart1.xlsm, I don´t know it maybe you were irritated with my description in the other post:

Please Login or Register  to view this content.

If the code won´t do what you want please change into the VBE, place the cursor into the code line

Please Login or Register  to view this content.

and press F9 to set a breakpoint. Start the code again and use F8 to singlestep through the code and see what the code does or where it breaks.

Ciao,
Holger

**kosherboy** · 02-21-2014, 01:41 PM

What description in other post?
The code again did not work and the code highlighted the part of the script that you said I should put a break point in. I'm not sure what I should do next?

Sorry to make you nuts and I do appreciate your help.

**HaHoBe** · 02-21-2014, 01:47 PM

Hi, kosherboy,

a breakpoint is set to get further information about the code and the variables. What you reckognized was exactly what was planned: after setting the breakpoint and starting the procedure the code will stop and allow you to continue to go through the code by pressing F8 thus being able to pass more information than just code doesn´t work (which I can´t find as the code worked fine in the samples I build to test).

Ciao,
Holger

**kosherboy** · 02-21-2014, 01:53 PM

Maybe I am not doing it right. Can you send me the samples you are working with-with the codes already inserted in the VBA?

**HaHoBe** · 02-21-2014, 02:18 PM

Hi, kosherboy,

I thought it was you who was searching help, not me. So to me it would be a better way that you included your macro workbook but anyhow...

Ciao,
Holger

**kosherboy** · 02-21-2014, 02:31 PM

Originally Posted by HaHoBe

Hi, kosherboy,

I thought it was you who was searching help, not me. So to me it would be a better way that you included your macro workbook but anyhow...

Ciao,
Holger

Once again you amazed me!
Thanks!
I modified the code to insert the hyperlink to the pre-selected cell.

Please Login or Register  to view this content.

Everything is working the way i want it to. Can you just tell me how i can get rid of the pop-up window that says "Privacy warning: This document contains macros, ActveX controls....."

Many thanks and best of luck to you:-)

**kosherboy** · 02-24-2014, 04:39 PM

Hey HaHoBe,
I ran into an unforeseen issue. At work I usually have more than one workbook open, the code does not seem to work with other workbooks open aside from the ones involved in your last post. So basically the code will only work if those two workbooks, alone, are open.
You mentioned in this thread and a different thread http://www.excelforum.com/excel-prog...ml#post3592885 that there are more ways to solve this problem? I'm curious as to what they are?

I appreciate all your help and I hope to hear from you soon

**HaHoBe** · 02-25-2014, 01:58 AM

Hi, kosherboy,

Originally Posted by OP

I have two workbooks open.

Originally Posted by #10

At work I usually have more than one workbook open

All the posting I made rely on the information from the opening post.

I will try tonight to have a closer look what may cause the problem.

Ciao,
Holger

**kosherboy** · 02-25-2014, 10:08 AM

You are right, apologies.
Looking forward to hearing from you again

Code to detect previous active workbook instead of current active workbook

LinkBack

Thread Tools

Rate This Thread

Display

Code to detect previous active workbook instead of current active workbook

Re: Code to detect previous active workbook instead of current active workbook

Re: Code to detect previous active workbook instead of current active workbook

Re: Code to detect previous active workbook instead of current active workbook

Re: Code to detect previous active workbook instead of current active workbook

Re: Code to detect previous active workbook instead of current active workbook

Re: Code to detect previous active workbook instead of current active workbook

Re: Code to detect previous active workbook instead of current active workbook

Re: Code to detect previous active workbook instead of current active workbook

Re: Code to detect previous active workbook instead of current active workbook

Re: Code to detect previous active workbook instead of current active workbook

Re: Code to detect previous active workbook instead of current active workbook

Thread Information

Users Browsing this Thread

Similar Threads

VBA macro for hyperlink to active workbook in the active workbook path

[SOLVED] Edit code to close all workbooks except active workbook and other specific workbook

Macro operates on 'closed' workbook & Current Active WB

Saving only the current, active workbook

Paste data from active workbook to another workbook using code.

Bookmarks

Bookmarks

Posting Permissions