Shell to Winword from extra basic

[santlou]

Hi,

I have a macro that creates a txt file.

I want to bring this file up using Word automatically after the file is created. I tried to shell to word, but I cant specify the document name in the shell statement.

myfile = "this is my file.txt"
Shell("Winword " + myfile)

this causes an error because the name of the file needs to be enclosed in quotes. I've tried several methods to invoke this call.. but all fail.

Can anybody help ?

I know that the proper way is to use OLE to get into word, but I figured the shell method is a quick and dirty solution... if i can get it to work.

thanx... Lou

 

[sonofmoog]

I tried your script without declaring a variable for the name of myfile, and it worked fine. Something like:

Shell("Winword","C:\bootlog.txt")

HTH

 

[mbars]

You may also use the following:

myfile = "this is my file.txt"
Shell("Winword " + chr$(34) + myfile + chr$(34))

where chr$(34) is the quote you need

 

[calculus]

While I've never used the Chr(34) option, I've been unable to fire a macro with spaces in the name. No matter what workaround I tried, the only thing that worked was to get the spaces out.