How do I make external application visible?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi!

I currently have a macro that populates a Word Doc and and Excel Spreadsheet
based on values from my form. However, I would like Word/Excel to be visible
after the macro is completed, so the user will be able to see that a
document/spreadsheet has been generated and is ready for editing. Currently,
Word/Excel run in the background, and after the macro is completed, the
applications close. How do I make them visible?

HELP!
 
The easiest fix for this is to use the Shell() function to open the files
after they have been created.

Call Shell("excel " & Chr$(34) & varGetFileName & Chr$(34), vbMaximizedFocus)
 
Back
Top