Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: rarkin
  • Content: Threads
  • Order by date
  1. rarkin

    Can't get Word VBA to run an 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...
  2. rarkin

    Switching back to active Module1 pane from UserForm pane

    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...
  3. rarkin

    Getting Word VBA variables into parent Excel VBA macro

    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...

Part and Inventory Search

Back
Top