ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Opening Word Document with Macros and not hyperlinks. (https://www.excelbanter.com/excel-discussion-misc-queries/126082-opening-word-document-macros-not-hyperlinks.html)

Thew21

Opening Word Document with Macros and not hyperlinks.
 
Im trying to open a specific word document from within Excel ive used the
formula:

Shell ("H:\Macro work\letter"), vbMaximizedFocus

However this doesnt appear to work, Any ideas would be much appreciated.

Mike

Opening Word Document with Macros and not hyperlinks.
 
for VBA open

http://www.mrexcel.com/archive/Office/19023.html

or more simply Hyprlink from a cell

"Thew21" wrote:

Im trying to open a specific word document from within Excel ive used the
formula:

Shell ("H:\Macro work\letter"), vbMaximizedFocus

However this doesnt appear to work, Any ideas would be much appreciated.


Bob I

Opening Word Document with Macros and not hyperlinks.
 
you would need the rest of the file name, like "letter.DOC"

Thew21 wrote:

Im trying to open a specific word document from within Excel ive used the
formula:

Shell ("H:\Macro work\letter"), vbMaximizedFocus

However this doesnt appear to work, Any ideas would be much appreciated.




All times are GMT +1. The time now is 09:10 PM.

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