ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Using a macro to open another document (https://www.excelbanter.com/excel-discussion-misc-queries/154477-using-macro-open-another-document.html)

Bex

Using a macro to open another document
 
I want to have a button in Excel which you click on and it takes you into
word to a specific document in word.

Is this possible?

Thanks

Gary''s Student

Using a macro to open another document
 
The macro:

Sub Macro1()
Dim s As String
s = "cmd.exe /c C:\Hello.doc"
x = Shell(s, 1)
End Sub


will take you to a word doc. Just assign a Forms button to the macro.
--
Gary''s Student - gsnu200737


"Bex" wrote:

I want to have a button in Excel which you click on and it takes you into
word to a specific document in word.

Is this possible?

Thanks



All times are GMT +1. The time now is 11:14 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com