ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Auto Open and Passing variable value(s) to MS Word (https://www.excelbanter.com/excel-programming/278217-auto-open-passing-variable-value-s-ms-word.html)

Sony[_2_]

Auto Open and Passing variable value(s) to MS Word
 
Hi,
I want to ask regarding the previous post regarding the Auto Open
method, I have put this simple code :
Sub Workbook_Open()
MsgBox("Auto Open Macro Success")
End Sub

and it still showing up the Enable Macro screen. What's wrong ?.

Secondly, How do you pass a variable value from a MS Excel worksheet
to a MS Word document ?.

Lastly, tons of thanks.

rgds
sony

John Wilson

Auto Open and Passing variable value(s) to MS Word
 
Sony,

Sub Workbook_Open()

It should be "Private Sub Workbook_Open" and it
should be in the "ThisWorkbook" module. I suspect that
you have it in a regular module (and it won't work from there).

and it still showing up the Enable Macro screen.

If you have any code in a workbook and your security setting
is set to "Medium", you'll get this alert every time. Other than
using a digital signature (which is a chore in itself, and expensive)
or setting your security setting to "Low" there isn't any way around this.

John




"Sony" wrote in message
...
Hi,
I want to ask regarding the previous post regarding the Auto Open
method, I have put this simple code :
Sub Workbook_Open()
MsgBox("Auto Open Macro Success")
End Sub

and it still showing up the Enable Macro screen. What's wrong ?.

Secondly, How do you pass a variable value from a MS Excel worksheet
to a MS Word document ?.

Lastly, tons of thanks.

rgds
sony





All times are GMT +1. The time now is 10:41 PM.

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