Getting Macros to Run Together (with same range selection as input)

I am currently trying to get three subroutines to run harmoniously with each other and for some reason or another (my VBA noobness most likely) I can't seem to figure out the call statements correctly, nor am I sure of the best way to pass the selected range and have them run off this range. I've arrived at this point of trying to integrate the pieces of this project together (they successfully and do their job alone) via a lot of help from OnErrorGoto0 within this thread: http://www.excelforum.com/excel-prog...59#post2700959

The following is the code I'm trying to get to run together, I have them all within a single module and attempt to call the second from the first. The second purely just sends the range to the third. When developing them I would test the second and the third together and the first alone, and both ran successfully. Although the second and the third requiring a few files to be stored locally on your machine for the tag cloud to actually be generated within the web browser.

Please Login or Register  to view this content.

I can tell the last subroutine is not being run as I never see the "Macro Finished." So it's more than it just not being passed the range, I believe its not being ran at all. One thing I would like to change is for the first subroutine MakeTable3 to run purely off of whatever range is selected (similar to how the other two subroutines have been written to just run off the selected range)...I'd like to the user to be able to highlight a range and just press play and have the summary sheet appear. Thanks in advance to anyone who has any advice for how I can accomplish this! This forum rocks!

Have you tried stepping through each line to see where there is a miss?

It should be

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

before the Exit Sub.

Please Login or Register  to view this content.

Can't answer the rest as I'm not sure what the question is.

I was actually addressing the second part, but got the variable name wrong. Replace

Please Login or Register  to view this content.

with just

Please Login or Register  to view this content.

I would also replace

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

At the time you try to run the code, that control does not exist, so the compiler won't like it. You will need something like

Please Login or Register  to view this content.

I'll try adding the construction earlier but the browser isn't used until the third subroutine and I have it being constructed at the end of the first. I'll report back in a little with good results hopefully. Fingers crossed.

Edit: Ah hah I replaced 'With Sheets("Incident Summary").WebBrowser1' with the line you provided me and I did not get that message. My tag cloud was blank however but in my experience fiddling with that subroutine that was usually because it was passed nothing as the range...going to start fiddling with that now but have other work with a nearer deadline so may have to wait til the AM.

Edit II: OK so I have had some time to return to this. What is currently happening is that when I run the code before my tag cloud appears I must turn design mode on then off.

For some reason after I do this my tag cloud will appear...very odd. When I try to record myself clicking the design mode button twice I get nothing recorded. Also worth mentioning is that the vertical scroll bar typically on the right hand side of a WebBrowser control appears with the tag cloud...i.e. is not visible then upon entering/exiting design mode it appears as well.

The "Macro Finished." message is also not appearing leading me to believe its still doing something with the construction of the WebBrowser...not really sure on this one any help would be awesome!

What happens if you remove the Do...Loop from the webbrowser code?

Comment out that line too. Do you get the message box?

Which line is "that" line your speaking of? I get the feeling its not finishing with this chunk of the code since it never tells me "Macro Finished." Thanks again for your help .

Let me know if you'd like me to email you the jscript files that work with this macro...perhaps it'd be easier if you had them so you saw exactly what was happening with respect to the tag cloud and WebBrowser...just let me know.

This line

Please Login or Register  to view this content.

OK, so that implies that your loop is never finishing for some reason. Try

Please Login or Register  to view this content.

(I am doing this from memory so that might not be correct syntax)

With that chunk of the macro coded as follows:

Please Login or Register  to view this content.

The loop seems to run through as I get the macro finished message but I unfortunately still must double click on the "Design Mode" button for the tag cloud to appear.

I've also noticed that at some point during this troubleshooting i've done something such that I'm no longer allowed to record macros from this workbook at all (its the whole workbook too i don't get it).

Edit: This morning when I rebooted and opened the workbook again I can record. But when I record myself clicking on the design mode button twice it does not seem to record anything at all :-(. This is getting frustrating soooo close but yet so far it seems.