Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi All,
I am getting a type mismatch error on this line: Set doc = wdApp.Documents.Open(fDialog) what might be the reason? Here is the whole code: Dim wdApp As Object Dim doc As Object On Error Resume Next Set wdApp = GetObject("C:\My Documents\Address.dotx", "Word.Application") If Err.Number < 0 Then 'Word isn't already running Set wdApp = CreateObject("Word.Application") End If On Error GoTo 0 Dim FName As String fDialog = Application.FileDialog(msoFileDialogFilePicker).Sh ow On Error Resume Next Set doc = wdApp.Documents.Open(fDialog) wdApp.ActiveDocument.Variables("Address").Value = Me.Address.Value wdApp.ActiveDocument.Variables("City").Value = Me.City.Value wdApp.ActiveDocument.Fields.Update FName = "C:\My Documents\" & "Address" & ".doc" wdApp.ActiveDocument.SaveAs FileName:=FName wdApp.Visible = True Set doc = Nothing Set wdApp = Nothing wApp.Quit End Sub Please help! Thanks in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Visual Basic Error Run Time Error, Type Mismatch | Excel Discussion (Misc queries) | |||
runtime error 13 - type mismatch error in Excel 97 on Citrix | Excel Programming | |||
Conditional Formatting - Run Time Error '13' Type Mismatch Error | Excel Programming | |||
Help: Compile error: type mismatch: array or user defined type expected | Excel Programming | |||
Befuddled with For Next Loop ------ Run - Time Error '13' Type Mismatch Error | Excel Programming |