Word macro running from OL VBA throwing error on Word SaveAs??

I have a macro in Word that iterates through my Favorites folder and saves everything out as hyperlinks in a Word doc. I then SaveAs using doc.SaveAs FileName:= _ "C:\Documents and Settings\edward.millis\Documents\MyFaves.htm", _ FileFormat:=wdFormatHTML This macro was written in Word XP, which has now been upgraded to 2007. The OS has also been updated from WinXP Pro to Vista Pro. When I run the macro in Word only, it runs fine - the file is generated and saved to the correct folder in the correct format. I want to email the file out, so I am trying to run it from within an Outlook 2007 macro. (Security settings prevent Word VBA from accessing OL VBA, or I would do it all from within Word.) The OL macro creates the Word instance just fine and runs the macro just fine - until it hits the SaveAs. I put a STOP in the Word code just before the SaveAs to verify this - as soon aas I F8 to the SaveAs, my error handler tells me that Outlook VBA has the following error: -2147417851 Method "Run" of object "Application" failed Any suggestions on getting this macro to run when accessed from OL VBA? Ed

That file path shouldn't exist at all on a Vista system. Does the exact same code really run in Word on Vista without errors? In any case, if there's a Word error going on the problem isn't an Outlook problem but a Word problem. -- Ken Slovak [MVP - Outlook] http://www.slovaktech.com Author: Professional Programming Outlook 2007. Reminder Manager, Extended Reminders, Attachment Options. http://www.slovaktech.com/products.htm "Ed from AZ" <prof_ofwhat@yahoo.com> wrote in message news:6a026697-8927-4b89-a9c0-7d10588a014a@g28g2000yqh.googlegroups.com... >I have a macro in Word that iterates through my Favorites folder and > saves everything out as hyperlinks in a Word doc. I then SaveAs using > doc.SaveAs FileName:= _ > "C:\Documents and Settings\edward.millis\Documents\MyFaves.htm", > _ > FileFormat:=wdFormatHTML > > This macro was written in Word XP, which has now been upgraded to > 2007. The OS has also been updated from WinXP Pro to Vista Pro. > > When I run the macro in Word only, it runs fine - the file is > generated and saved to the correct folder in the correct format. > > I want to email the file out, so I am trying to run it from within an > Outlook 2007 macro. (Security settings prevent Word VBA from > accessing OL VBA, or I would do it all from within Word.) > > The OL macro creates the Word instance just fine and runs the macro > just fine - until it hits the SaveAs. I put a STOP in the Word code > just before the SaveAs to verify this - as soon aas I F8 to the > SaveAs, my error handler tells me that Outlook VBA has the following > error: > -2147417851 > Method "Run" of object "Application" failed > > Any suggestions on getting this macro to run when accessed from OL > VBA? > Ed

> That file path shouldn't exist at all on a Vista system. Wow! I copied it straight off the folder address bar - I thought. The address bar shows the heirarchy separated by >, but when you click in it it turns to /. I'll have to look at that again. But yes, when run from Word, there are no problems. Well, maybe not - it's overwriting a file that's already there, so maybe the newly save file is disappearing into the system somewhere and I'm actually still seeing the previous version. Gotta look at that again! Thanks, Ken. At least I have a good point to start looking. Ed On Mar 2, 1:54=A0pm, "Ken Slovak - [MVP - Outlook]" <kenslo...@mvps.org> wrote: > That file path shouldn't exist at all on a Vista system. Does the exact s= ame > code really run in Word on Vista without errors? In any case, if there's = a > Word error going on the problem isn't an Outlook problem but a Word probl= em. > > -- > Ken Slovak > [MVP - Outlook]http://www.slovaktech.com > Author: Professional Programming Outlook 2007. > Reminder Manager, Extended Reminders, Attachment Options.http://www.slova= ktech.com/products.htm > > "Ed from AZ" <prof_ofw...@yahoo.com> wrote in messagenews:6a026697-8927-4= b89-a9c0-7d10588a014a@g28g2000yqh.googlegroups.com... > > > > >I have a macro in Word that iterates through my Favorites folder and > > saves everything out as hyperlinks in a Word doc. =A0I then SaveAs usin= g > > =A0doc.SaveAs FileName:=3D _ > > =A0 =A0 =A0"C:\Documents and Settings\edward.millis\Documents\MyFaves.h= tm", > > _ > > =A0 =A0 =A0FileFormat:=3DwdFormatHTML > > > This macro was written in Word XP, which has now been upgraded to > > 2007. =A0The OS has also been updated from WinXP Pro to Vista Pro. > > > When I run the macro in Word only, it runs fine - the file is > > generated and saved to the correct folder in the correct format. > > > I want to email the file out, so I am trying to run it from within an > > Outlook 2007 macro. =A0(Security settings prevent Word VBA from > > accessing OL VBA, or I would do it all from within Word.) > > > The OL macro creates the Word instance just fine and runs the macro > > just fine - until it hits the SaveAs. =A0I put a STOP in the Word code > > just before the SaveAs to verify this - as soon aas I F8 to the > > SaveAs, my error handler tells me that Outlook VBA has the following > > error: > > =A0-2147417851 > > =A0Method "Run" of object "Application" failed > > > Any suggestions on getting this macro to run when accessed from OL > > VBA? > > Ed- Hide quoted text - > > - Show quoted text -

I don't know, your setup may be different, but here on one of my Vista setups a document in my Documents folder has a path that looks like this: C:\Users\Ken Slovak.000\Documents\9096xcc.doc. -- Ken Slovak [MVP - Outlook] http://www.slovaktech.com Author: Professional Programming Outlook 2007. Reminder Manager, Extended Reminders, Attachment Options. http://www.slovaktech.com/products.htm "Ed from AZ" <prof_ofwhat@yahoo.com> wrote in message news:3ec2eba3-fe84-41f1-80e1-8c9bd5898755@f17g2000prh.googlegroups.com... > That file path shouldn't exist at all on a Vista system. Wow! I copied it straight off the folder address bar - I thought. The address bar shows the heirarchy separated by >, but when you click in it it turns to /. I'll have to look at that again. But yes, when run from Word, there are no problems. Well, maybe not - it's overwriting a file that's already there, so maybe the newly save file is disappearing into the system somewhere and I'm actually still seeing the previous version. Gotta look at that again! Thanks, Ken. At least I have a good point to start looking. Ed

Vista will allow you to use that name as an alternative to the Users\(userid)\Documents name. Are you using Application.Run (as per the message)? Or is the code exactly as posted - which ought to work (assuming doc is a valid reference)? -- Enjoy, Tony www.WordArticles.com "Ken Slovak - [MVP - Outlook]" <kenslovak@mvps.org> wrote in message news:%23O0vKqkuKHA.6140@TK2MSFTNGP05.phx.gbl... > That file path shouldn't exist at all on a Vista system. Does the exact > same code really run in Word on Vista without errors? In any case, if > there's a Word error going on the problem isn't an Outlook problem but a > Word problem. > > -- > Ken Slovak > [MVP - Outlook] > http://www.slovaktech.com > Author: Professional Programming Outlook 2007. > Reminder Manager, Extended Reminders, Attachment Options. > http://www.slovaktech.com/products.htm > > > "Ed from AZ" <prof_ofwhat@yahoo.com> wrote in message > news:6a026697-8927-4b89-a9c0-7d10588a014a@g28g2000yqh.googlegroups.com... >>I have a macro in Word that iterates through my Favorites folder and >> saves everything out as hyperlinks in a Word doc. I then SaveAs using >> doc.SaveAs FileName:= _ >> "C:\Documents and Settings\edward.millis\Documents\MyFaves.htm", >> _ >> FileFormat:=wdFormatHTML >> >> This macro was written in Word XP, which has now been upgraded to >> 2007. The OS has also been updated from WinXP Pro to Vista Pro. >> >> When I run the macro in Word only, it runs fine - the file is >> generated and saved to the correct folder in the correct format. >> >> I want to email the file out, so I am trying to run it from within an >> Outlook 2007 macro. (Security settings prevent Word VBA from >> accessing OL VBA, or I would do it all from within Word.) >> >> The OL macro creates the Word instance just fine and runs the macro >> just fine - until it hits the SaveAs. I put a STOP in the Word code >> just before the SaveAs to verify this - as soon aas I F8 to the >> SaveAs, my error handler tells me that Outlook VBA has the following >> error: >> -2147417851 >> Method "Run" of object "Application" failed >> >> Any suggestions on getting this macro to run when accessed from OL >> VBA? >> Ed >

Hi, Tony. The Outlook macro has 'Set Word application to running instance or new instance Set appWord =3D GetObject(, "Word.Application") If Err Then Set appWord =3D New Word.Application WordWasNotRunning =3D True End If Err.Clear On Error GoTo BadBoy 'Run Word macro appWord.Visible =3D True appWord.Run "Normal.Module11.GetMyFaves" The Word macro does run. I put a Stop right before the SaveAs command in the Word macro and fixed the file path for Vista. The macro breaks at the Stop, and as soon as I F8 to the SaveAs line it throws the error - not in the Word app, but in the OL app as described in my first post. I'm thinking the next step may be to put everything in OL VBA and just access Word from there to create and save the doc. Just haven't had time to play with that yet. Ed On Mar 8, 12:51=A0pm, "Tony Jollans" <My forename at my surname dot com> wrote: > Vista will allow you to use that name as an alternative to the > Users\(userid)\Documents name. > > Are you using Application.Run (as per the message)? Or is the code exactl= y > as posted - which ought to work (assuming doc is a valid reference)? > > -- > Enjoy, > Tony > > =A0www.WordArticles.com > > "Ken Slovak - [MVP - Outlook]" <kenslo...@mvps.org> wrote in messagenews:= %23O0vKqkuKHA.6140@TK2MSFTNGP05.phx.gbl... > > > > > That file path shouldn't exist at all on a Vista system. Does the exact > > same code really run in Word on Vista without errors? In any case, if > > there's a Word error going on the problem isn't an Outlook problem but = a > > Word problem. > > > -- > > Ken Slovak > > [MVP - Outlook] > >http://www.slovaktech.com > > Author: Professional Programming Outlook 2007. > > Reminder Manager, Extended Reminders, Attachment Options. > >http://www.slovaktech.com/products.htm > > > "Ed from AZ" <prof_ofw...@yahoo.com> wrote in message > >news:6a026697-8927-4b89-a9c0-7d10588a014a@g28g2000yqh.googlegroups.com..= .. > >>I have a macro in Word that iterates through my Favorites folder and > >> saves everything out as hyperlinks in a Word doc. =A0I then SaveAs usi= ng > >> =A0doc.SaveAs FileName:=3D _ > >> =A0 =A0 =A0"C:\Documents and Settings\edward.millis\Documents\MyFaves.= htm", > >> _ > >> =A0 =A0 =A0FileFormat:=3DwdFormatHTML > > >> This macro was written in Word XP, which has now been upgraded to > >> 2007. =A0The OS has also been updated from WinXP Pro to Vista Pro. > > >> When I run the macro in Word only, it runs fine - the file is > >> generated and saved to the correct folder in the correct format. > > >> I want to email the file out, so I am trying to run it from within an > >> Outlook 2007 macro. =A0(Security settings prevent Word VBA from > >> accessing OL VBA, or I would do it all from within Word.) > > >> The OL macro creates the Word instance just fine and runs the macro > >> just fine - until it hits the SaveAs. =A0I put a STOP in the Word code > >> just before the SaveAs to verify this - as soon aas I F8 to the > >> SaveAs, my error handler tells me that Outlook VBA has the following > >> error: > >> =A0-2147417851 > >> =A0Method "Run" of object "Application" failed > > >> Any suggestions on getting this macro to run when accessed from OL > >> VBA? > >> Ed- Hide quoted text - > > - Show quoted text -

The error is in Outlook because .. you don't have any active error trapping, and the error bubbles up to the top and is trapped, ultimately, by the top level VBA in Outlook. If you add an On Error to your Word macro, it should trap the error there. That, however, doesn't help with the actual issue - error code -2147417851 is a rather generic 'server exception' - these can be symptomatic of object errors - lost pointers, or implicit instantiation, for example - that can happen in Automation. Can you post the full Word code as well? -- Enjoy, Tony www.WordArticles.com "Ed from AZ" <prof_ofwhat@yahoo.com> wrote in message news:6d689010-df81-4c34-8d78-76d6aa87c20d@g26g2000yqn.googlegroups.com... Hi, Tony. The Outlook macro has 'Set Word application to running instance or new instance Set appWord = GetObject(, "Word.Application") If Err Then Set appWord = New Word.Application WordWasNotRunning = True End If Err.Clear On Error GoTo BadBoy 'Run Word macro appWord.Visible = True appWord.Run "Normal.Module11.GetMyFaves" The Word macro does run. I put a Stop right before the SaveAs command in the Word macro and fixed the file path for Vista. The macro breaks at the Stop, and as soon as I F8 to the SaveAs line it throws the error - not in the Word app, but in the OL app as described in my first post. I'm thinking the next step may be to put everything in OL VBA and just access Word from there to create and save the doc. Just haven't had time to play with that yet. Ed On Mar 8, 12:51 pm, "Tony Jollans" <My forename at my surname dot com> wrote: > Vista will allow you to use that name as an alternative to the > Users\(userid)\Documents name. > > Are you using Application.Run (as per the message)? Or is the code exactly > as posted - which ought to work (assuming doc is a valid reference)? > > -- > Enjoy, > Tony > > www.WordArticles.com > > "Ken Slovak - [MVP - Outlook]" <kenslo...@mvps.org> wrote in > messagenews:%23O0vKqkuKHA.6140@TK2MSFTNGP05.phx.gbl... > > > > > That file path shouldn't exist at all on a Vista system. Does the exact > > same code really run in Word on Vista without errors? In any case, if > > there's a Word error going on the problem isn't an Outlook problem but a > > Word problem. > > > -- > > Ken Slovak > > [MVP - Outlook] > >http://www.slovaktech.com > > Author: Professional Programming Outlook 2007. > > Reminder Manager, Extended Reminders, Attachment Options. > >http://www.slovaktech.com/products.htm > > > "Ed from AZ" <prof_ofw...@yahoo.com> wrote in message > >news:6a026697-8927-4b89-a9c0-7d10588a014a@g28g2000yqh.googlegroups.com... > >>I have a macro in Word that iterates through my Favorites folder and > >> saves everything out as hyperlinks in a Word doc. I then SaveAs using > >> doc.SaveAs FileName:= _ > >> "C:\Documents and Settings\edward.millis\Documents\MyFaves.htm", > >> _ > >> FileFormat:=wdFormatHTML > > >> This macro was written in Word XP, which has now been upgraded to > >> 2007. The OS has also been updated from WinXP Pro to Vista Pro. > > >> When I run the macro in Word only, it runs fine - the file is > >> generated and saved to the correct folder in the correct format. > > >> I want to email the file out, so I am trying to run it from within an > >> Outlook 2007 macro. (Security settings prevent Word VBA from > >> accessing OL VBA, or I would do it all from within Word.) > > >> The OL macro creates the Word instance just fine and runs the macro > >> just fine - until it hits the SaveAs. I put a STOP in the Word code > >> just before the SaveAs to verify this - as soon aas I F8 to the > >> SaveAs, my error handler tells me that Outlook VBA has the following > >> error: > >> -2147417851 > >> Method "Run" of object "Application" failed > > >> Any suggestions on getting this macro to run when accessed from OL > >> VBA? > >> Ed- Hide quoted text - > > - Show quoted text -

Here's the full code in Word. It's all in one module, most variables declared at the top, and a Sub that calls to a Function. When I run this just in Word, it goes great, saves and closes the doc. When I try to call this from the OL macro, it always errors out at the SaveAs. The doc is there with all the info in it, just not saved. Ed Dim fsoSysObj As FileSystemObject Dim fdrFolder As Folder Dim fdrSubFolder As Folder Dim filFile As file Dim objShell As Shell Dim objFolder As Object Dim objItem As Object Dim objLink As Object Dim doc As Document Dim rng As Range Dim strFldName As String Dim myanchor, strLnkText, strLnkPath Dim ary() As String Dim cntAry As Integer Dim x As Integer ' Function GetFiles(strPath As String, _ Optional blnRecursive As Boolean) As Boolean ' This procedure returns all the files in a directory into ' an array. If called recursively, it also returns ' all files in subfolders. On Error Resume Next ' Get folder. Set fdrFolder =3D fsoSysObj.GetFolder(strPath) ' Skip this folder If fdrFolder.Name =3D "~Work" Then GoTo GetFiles_End strFldName =3D fdrFolder.Name If Err <> 0 Then ' Incorrect path. GetFiles =3D False GoTo GetFiles_End End If On Error GoTo 0 Set objFolder =3D objShell.Namespace(strPath) ' Loop through Files collection, adding to array. For Each filFile In fdrFolder.Files If filFile.Type =3D "Internet Shortcut" Then Set objItem =3D objFolder.ParseName(filFile.Name) Set objLink =3D objItem.GetLink ' Set info in array cntAry =3D cntAry + 1 ReDim Preserve ary(3, cntAry) As String ary(1, cntAry) =3D strFldName ary(2, cntAry) =3D objItem.Name ary(3, cntAry) =3D objLink.Target.Path End If Next filFile ' If Recursive flag is true, call recursively. If blnRecursive Then For Each fdrSubFolder In fdrFolder.SubFolders GetFiles fdrSubFolder.Path, True Next fdrSubFolder End If ' Return True if no error occurred. GetFiles =3D True GetFiles_End: Exit Function End Function Sub GetMyFaves() ' Calls GetFiles function to retrieve Favorites URLs. If Application.Documents.Count < 1 Then Application.Documents.Add Set doc =3D ActiveDocument cntAry =3D 0 ' Return new FileSystemObject. Set fsoSysObj =3D New FileSystemObject ' Shell object provides objects with link properties Set objShell =3D CreateObject("Shell.Application") ' Call recursively, return info into array. If GetFiles("C:\Users\edward.millis\Favorites", True) Then For x =3D 1 To cntAry Set rng =3D doc.Paragraphs(doc.Paragraphs.Count).Range If ary(1, x) <> strFldName Then rng.Text =3D "\" & ary(1, x) & vbCrLf Set rng =3D doc.Paragraphs(doc.Paragraphs.Count).Range End If strFldName =3D ary(1, x) Set myanchor =3D rng strLnkText =3D ary(2, x) strLnkPath =3D ary(3, x) doc.Hyperlinks.Add Anchor:=3Dmyanchor, Address:=3D _ strLnkPath, SubAddress:=3D"", ScreenTip:=3D"", TextToDisplay:=3D = _ strLnkText doc.Content.InsertAfter vbCrLf Next x End If Stop On Error Resume Next doc.SaveAs FileName:=3D _ "C:\Users\edward.millis\Documents\MyFaves.htm", _ FileFormat:=3DwdFormatHTML doc.Close If Err.Number <> 0 Then _ MsgBox Err.Number & ": " & Err.Description On Error GoTo 0 End Sub On Mar 9, 12:33=A0pm, "Tony Jollans" <My forename at my surname dot com> wrote: > The error is in Outlook because .. you don't have any active error trappi= ng, > and the error bubbles up to the top and is trapped, ultimately, by the to= p > level VBA in Outlook. If you add an On Error to your Word macro, it shoul= d > trap the error there. > > That, however, doesn't help with the actual issue - error code -214741785= 1 > is a rather generic 'server exception' - these can be symptomatic of obje= ct > errors - lost pointers, or implicit instantiation, for example - that can > happen in Automation. Can you post the full Word code as well? > > -- > Enjoy, > Tony

Thank you for that, and sorry for the long delay in replying. I can't see any obvious cause of your problem. I did, however, cut and paste both your Outlook and Word codes into 2007 and I had to mess about a bit to get it to work (some of the problems were my environment, but I did need to add a trailing backslash on the Set objFolder line) and when I finally did I got your error - but only once. After that I couldn't repeat the error and, I'm sorry to say, I don't know what may be causing it. -- Enjoy, Tony www.WordArticles.com "Ed from AZ" <prof_ofwhat@yahoo.com> wrote in message news:ce315ea8-7f3f-406a-9bb3-a98465255c6d@w27g2000pre.googlegroups.com... Here's the full code in Word. It's all in one module, most variables declared at the top, and a Sub that calls to a Function. When I run this just in Word, it goes great, saves and closes the doc. When I try to call this from the OL macro, it always errors out at the SaveAs. The doc is there with all the info in it, just not saved. Ed Dim fsoSysObj As FileSystemObject Dim fdrFolder As Folder Dim fdrSubFolder As Folder Dim filFile As file Dim objShell As Shell Dim objFolder As Object Dim objItem As Object Dim objLink As Object Dim doc As Document Dim rng As Range Dim strFldName As String Dim myanchor, strLnkText, strLnkPath Dim ary() As String Dim cntAry As Integer Dim x As Integer ' Function GetFiles(strPath As String, _ Optional blnRecursive As Boolean) As Boolean ' This procedure returns all the files in a directory into ' an array. If called recursively, it also returns ' all files in subfolders. On Error Resume Next ' Get folder. Set fdrFolder = fsoSysObj.GetFolder(strPath) ' Skip this folder If fdrFolder.Name = "~Work" Then GoTo GetFiles_End strFldName = fdrFolder.Name If Err <> 0 Then ' Incorrect path. GetFiles = False GoTo GetFiles_End End If On Error GoTo 0 Set objFolder = objShell.Namespace(strPath) ' Loop through Files collection, adding to array. For Each filFile In fdrFolder.Files If filFile.Type = "Internet Shortcut" Then Set objItem = objFolder.ParseName(filFile.Name) Set objLink = objItem.GetLink ' Set info in array cntAry = cntAry + 1 ReDim Preserve ary(3, cntAry) As String ary(1, cntAry) = strFldName ary(2, cntAry) = objItem.Name ary(3, cntAry) = objLink.Target.Path End If Next filFile ' If Recursive flag is true, call recursively. If blnRecursive Then For Each fdrSubFolder In fdrFolder.SubFolders GetFiles fdrSubFolder.Path, True Next fdrSubFolder End If ' Return True if no error occurred. GetFiles = True GetFiles_End: Exit Function End Function Sub GetMyFaves() ' Calls GetFiles function to retrieve Favorites URLs. If Application.Documents.Count < 1 Then Application.Documents.Add Set doc = ActiveDocument cntAry = 0 ' Return new FileSystemObject. Set fsoSysObj = New FileSystemObject ' Shell object provides objects with link properties Set objShell = CreateObject("Shell.Application") ' Call recursively, return info into array. If GetFiles("C:\Users\edward.millis\Favorites", True) Then For x = 1 To cntAry Set rng = doc.Paragraphs(doc.Paragraphs.Count).Range If ary(1, x) <> strFldName Then rng.Text = "\" & ary(1, x) & vbCrLf Set rng = doc.Paragraphs(doc.Paragraphs.Count).Range End If strFldName = ary(1, x) Set myanchor = rng strLnkText = ary(2, x) strLnkPath = ary(3, x) doc.Hyperlinks.Add Anchor:=myanchor, Address:= _ strLnkPath, SubAddress:="", ScreenTip:="", TextToDisplay:= _ strLnkText doc.Content.InsertAfter vbCrLf Next x End If Stop On Error Resume Next doc.SaveAs FileName:= _ "C:\Users\edward.millis\Documents\MyFaves.htm", _ FileFormat:=wdFormatHTML doc.Close If Err.Number <> 0 Then _ MsgBox Err.Number & ": " & Err.Description On Error GoTo 0 End Sub On Mar 9, 12:33 pm, "Tony Jollans" <My forename at my surname dot com> wrote: > The error is in Outlook because .. you don't have any active error > trapping, > and the error bubbles up to the top and is trapped, ultimately, by the top > level VBA in Outlook. If you add an On Error to your Word macro, it should > trap the error there. > > That, however, doesn't help with the actual issue - error code -2147417851 > is a rather generic 'server exception' - these can be symptomatic of > object > errors - lost pointers, or implicit instantiation, for example - that can > happen in Automation. Can you post the full Word code as well? > > -- > Enjoy, > Tony

Similiar Articles:

Word macro running from OL VBA throwing error on Word SaveAs ...
I have a macro in Word that iterates through my Favorites folder and saves everything out as hyperlinks in a Word doc. I then SaveAs using doc.Sa...

Excel 'SaveAs' via Word - microsoft.public.word.vba ...
Word macro running from OL VBA throwing error on Word SaveAs ..... my Favorites folder and saves everything out as hyperlinks in a Word doc. I then SaveAs using ...

Bookmark Macro throwing errors - microsoft.public.word.vba.general ...
Word macro running from OL VBA throwing error on Word SaveAs ..... out as hyperlinks in ... Basic :: Opening Saveas Dialog Box From A Macro??? In Word Using A Bookmark As ...

macro run error! - microsoft.public.word.vba.general
How to set macro to run every 15 minutes? - microsoft.public.excel ... macro run error! - microsoft.public.word.vba.general How to set macro to run every 15 minutes ...

Word 2007 (on Vista) crashes when using CreateObject in VBA ...
Word macro running from OL VBA throwing error on Word SaveAs ..... 2007. The OS has also been updated from WinXP Pro to Vista Pro. > > >> When I run the macro in Word ...

VBA Error when trying to save - microsoft.public.excel
Word macro running from OL VBA throwing error on Word SaveAs ..... so maybe the newly save ... When I try to call this from the OL macro, it always errors out at the ...

Generic name for User folder? - microsoft.public.word.vba.general ...
Word macro running from OL VBA throwing error on Word SaveAs ..... name as an alternative to the > Users\(userid)\Documents name. ... code -214741785= 1 > is a rather ...

Macro for automatically adding filename without .doc - microsoft ...
Word macro running from OL VBA throwing error on Word SaveAs ... I then SaveAs using > doc.SaveAs FileName ... If you add an On Error to your Word macro, it should trap ...

Run Word Setup - microsoft.public.word.docmanagement
Word macro running from OL VBA throwing error on Word SaveAs ... I don't know, your setup may be different, but here on one of my Vista setups a document in my Documents ...

Error in Word - "A valid number is required" - microsoft ...
Word macro running from OL VBA throwing error on Word SaveAs ..... ought to work (assuming doc is a valid ... In any case, if > > there's a Word error going ...

Word macro running from OL VBA throwing error on Word SaveAs??
That file path shouldn't exist at all on a Vista system. Does the exact same code really run in Word on Vista without errors? In any case, if there's a

In XL VBA, Word Document SaveAs throws error
Microsoft Word Document Management: 2: 17th Jan 2012 06:04 AM: Word macro running from OL VBA throwing error on Word SaveAs?? Ed from AZ: Microsoft Outlook VBA Programming

Runtime Error 4198 In Word Macro When ActiveDocument.SaveAs
Openning Excel And Running Macro From Word - Macro; SaveAs Error; Error In SaveAS; Word 200 Vba Macro ... Runtime Error 462 - OLE Word ... I then run word and run a Macro (MailMerge ...

7/30/2012 5:56:23 PM