![]() |
If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Search this Thread | Display Modes |
#1
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Specify Font Name or Face using VBA Macro in Word | JBark | Outlook and VBA | 2 | July 6th 09 03:16 PM |
Word 2007 freezes on startup—“Running virus scan” in status bar | [email protected] | Outlook - General Queries | 0 | July 9th 08 03:28 PM |
Word macro warning | goran | Outlook and VBA | 1 | December 21st 07 09:44 AM |
Outlook macro abends but Word macro runs successfully | Jreue | Outlook and VBA | 0 | December 13th 06 11:55 PM |
Macro to search for word | Dave Neve | Outlook and VBA | 7 | July 26th 06 09:52 PM |