Need to start WORD and open a specific doc ??? 1

[Dylan]

I have a button on a form with code which opens WORD but I would like it to open a specific document when it opens.
The file I want to open has spaces in the filename.
ex "\\Treas_data_fs1\DATA\Senior Citizen\Letter.doc"

Any help would be greatly appreciated ...

thanks Tom

Here is my code so far
(which starts WORD ok with no current document)

##########################################################
Dim oApp As Object

Set oApp = CreateObject("Word.Application")
oApp.Visible = True


Tom Moran
Lansing, Michigan

 

[Ed2020]

I think you can use the shell command to run a shortcut.

Something like this should work:

Shell "X:\Office2K\MSOffice\office\WinWord.EXE '\\Treas_data_fs1\DATA\Senior Citizen\Letter.doc'"

Obviously you'll have to change the file paths accordingly.

Ed Metcalfe.

Please do not feed the trolls.....

 

[mharroff]

Dim oApp As Object

Set oApp = CreateObject("Word.Application")
oApp.Visible = True

oApp.Documents.Open FileName:="\\Treas_data_fs1\DATA\Senior Citizen\Letter.doc

 

[Dylan]

Thanks for the help. It now works as I intended.



Tom Moran
Lansing, Michigan