ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Open a Word document problem (https://www.excelbanter.com/excel-programming/319040-open-word-document-problem.html)

Eric L.

Open a Word document problem
 
Hi,

I have code to open a Word document and that's working fine. However, the
Word document that opens doesn't have the PDF buttons or menu. How can I get
these buttons to show from my Excel VBA code?

Thanks,
Eric

Ron de Bruin

Open a Word document problem
 
Hi Eric

You can change this example for Word

This was suggested by KeepItCool :
Code from KeepItCool (Oct 21, 2004)

Sub LoadXLwithAddins()
Dim xl As Object
Dim ai As Object

Set xl = CreateObject("Excel.Application")

For Each ai In Application.AddIns
If ai.Installed Then
xl.Workbooks.Open(ai.FullName).RunAutoMacros 1
End If
Next

xl.Visible = True
Set xl = Nothing
End Sub


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Eric L." wrote in message ...
Hi,

I have code to open a Word document and that's working fine. However, the
Word document that opens doesn't have the PDF buttons or menu. How can I get
these buttons to show from my Excel VBA code?

Thanks,
Eric





All times are GMT +1. The time now is 12:03 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com