Switch to Open Excel Worksheet

[MaxArk]

How can I automatically go back to an Excel worksheet from Word after
save?

After a document has been saved, I want the user returned to an alread
opened Exce worksheet

 

[MaxArk]

Hi Cindy,

I'm dealing here with Word 2003.
The document from word is a document created from a directory mail
merge. These reports (mail merges) are prompted from user interaction
on an Excel form. What I would like to do in essence is, after the Word
document has been saved, a simple push of a button (on the toolbar
perhaps?) in Word will return the user back to the active Excel
Worksheet.

 

[MaxArk]

Hi MaxArk,
-
I'm dealing here with Word 2003.
The document from word is a document created from a directory mail
merge. These reports (mail merges) are prompted from user interaction
on an Excel form. What I would like to do in essence is, after th
Word
document has been saved, a simple push of a button (on the toolbar
perhaps?) in Word will return the user back to the active Excel
Worksheet.
-
Try this, but note it will start Excel if it's not (no longer
running.

Sub ShowExcelApp
Dim o As Object

Set o = GetObject(, "Excel.Application")
o.Visible = True
Set o = Nothing
End Sub



Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)


This reply is posted in the Newsgroup; please post any follow questio
or
reply in the newsgroup and not by e-mail

Thanks Cindy. Where (how) would I put this code in place and integrat
a toolbar button to do it