Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

excel vba

Comment:

hi i am havin a problem opening ams word document using a macro in excel this is the code i am using but it only opens word and dosent open the document please help Application.ActivateMicrosoftApp (xlMicrosoftWord) Documents.Open Filename:="""letter.doc""", _ ConfirmConversions:=False, ReadOnly:=False, AddToRecentFiles:=False, _ PasswordDocument:="", PasswordTemplate:="", Revert:=False, _ WritePasswordDocument:="", WritePasswordTemplate:="", Format:= _ wdOpenFormatAuto

Reply:

Hi kam, I'm sorry. I tried but, could not get the correct result. I always log my threads on another form. Normally, I get quick response & solutions thers. Here is the link http://www.vbaexpress.com/forum/

0

Copying Full Path

MS WORD Extract URL or de...

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: I do not know your answer but I do know that you are using the worksheet property instead of a workbook property so your macro is limited to the worksheet. If you do not receive an acceptable answer t...

Summary: You have to open an instance of Access from Excel VBA and then open the database to make your changes. You should get a book on VBA if you don't have one already. John Walkenbach and John Green both ...

Summary: I have failed to find a comprehensible method of writing data to a serial and parallel port on a PC using Excel VBA. I wish to send control code (ESC/P2 codes) to an Epson dot matrix printer and send ...