Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error message when opening a .doc file using excel macro
Morning,
I have created a macro in excel that when the user clicks a "done" button a word document is opened from a shared drive. this is what i have so far: ------------------------------------ Dim x As String Dim wordApp As Object ThisWorkbook.Save x = Range("A156") Set wordApp = CreateObject("Word.Application") wordApp.Documents.Open "\\Flcscsrv02\share\Mercury Transactions\Test Docs\ " & x & "\Test word document.doc" ------------------------------------ when i run the macro the first time, nothing happens. when i run it a second time, i get the "File in Use" pop up. Where am i going wrong here? -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200703/1 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
stop error message when opening a non existant file in a macro | Excel Discussion (Misc queries) | |||
Unnecessary error message on opening file with links | Links and Linking in Excel | |||
Error message opening Excel file | Excel Discussion (Misc queries) | |||
"Unable to read file" error message when opening a Excel file that contains a PivotTable report. | Charts and Charting in Excel | |||
Error message when opening file | Excel Programming |