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