[MaxArk[_9_]]

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

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




--
MaxArk

[Cindy M.]

Hi MaxArk,

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

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

Are we talking macro here, or do you have something else in mind?

Which version of Office?

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

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

[MaxArk[_10_]]

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.




Cindy M.;2793370 Wrote:
Hi MaxArk,
-
How can I automatically go back to an Excel worksheet from Word after
a
save?

After a document has been saved, I want the user returned to an
already
opened Exce worksheet.
-
Are we talking macro here, or do you have something else in mind?

Which version of Office?

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

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




--
MaxArk

[Cindy M.]

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

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)
http://www.word.mvps.org

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

[MaxArk[_12_]]

Cindy M.;2796976 Wrote:
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 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.
-
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)
http://www.word.mvps.org

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

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




--
MaxArk

[Cindy M.]

Hi MaxArk,

Where (how) would I put this code in place and integrate
a toolbar button to do it?

Can you tell me more about how you imagine this should
work? It's hard for me to guess exactly how you want it. (I
can't promise it can be exactly how you want it, but it
would be nice to have a starting point...)

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

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