Search results for query: *

Apologies for the messy code. Skip, you're a rock star! Problem solved---your suggestion to add the VBAProject name "Personal.xlsb!" to the called macro name solved it and was the only change needed. I do have another question somewhat related to this, and will start a different thread for...

Skip, Thanks for the response! I tried your suggestions and made the changes as follows below, also noticing that I had no Dim statement for xlApp, but it still gives me the same error message for the Call command line. The excel macro...

I'm trying to figure out why my Word 2010 VBA will not run an Excel macro from within a Word macro. I can successfully do the reverse and run a Word macro from an Excel macro (and pass variables into that Word macro) but get an error (shown below) when trying to do it the other way around, and...

Thanks for the clarifications. I have an external monitor attached to my laptop and when I test/run my excel macros I like to keep the VBE window open for convenience to step through and edit code That's why I wanted the module1 pane to stay showing without having to close/open VBE or...

Thanks for the response, combo. It occurred to me there might be a much simpler solution...and indeed there was...the KISS principle is alive and well. Turns out I had to do was Hide the form after unloading it---that did the trick, leaving Module1 pane showing in the current procedure...

I run the RowRangeForm macro (below) from within another Excel macro, both in Module1 of my VBAProject (Personal.XLSB). The form macro works fine but the VBA Editor remains showing the Userform pane instead of switching back to the active Module1 pane. I want Module1 and Procedure that called...

Hi all. I'm running an Excel macro that opens a specific excel workbook, then calls some Word macros that capture different highlighted strings which then get placed back into the Excel workbook. I'm not having trouble passing Excel variables from the parent Excel macro into my Word macros...