| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code to check if word doc is already open
Thanks Tom
"Tom Ogilvy" wrote: http://support.microsoft.com?kbid=138621 XL: Macro Code to Check Whether a File Is Already Open http://support.microsoft.com?kbid=291295 XL2002: Macro Code to Check Whether a File Is Already Open http://support.microsoft.com?kbid=213383 XL2000: Macro Code to Check Whether a File Is Already Open http://support.microsoft.com?kbid=184982 WD97: VBA Function to Check If File or Document Is Open -- regards, Tom Ogilvy "Mike" wrote: Could some please shed there intelligence and help with code to check to see if word document is already open Private Sub cmdHelp_Click() Dim objWord As Object Dim objHelpFileDoc As Object Set objWord = CreateObject("Word.Application") objWord.Visible = True Set objHelpFileDoc = objWord.Documents.Open _ ("C:\Mid-Carolina Import Wizard\Help Files\InvoiceCreatorHelp.doc") End Sub Thanks Mike |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Check for a word | Excel Worksheet Functions | |||
| Excel Hyperlink doesn't open Word doc the same way as Word does | Excel Discussion (Misc queries) | |||
| VBA code to check if another window is open? | Excel Programming | |||
| Code in Excel macro to get all open Word docs? | Excel Programming | |||
| How to open a Word or HTML document using VBA code in Excel | Excel Programming | |||
Threaded Mode
