Posted to microsoft.public.excel.programming

Sony[_2_]

external usenet poster

Posts: 3

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Passing Variable to LINEST	RW	Excel Worksheet Functions	5	May 24th 05 07:00 PM
Passing a variable to a Worksheet at open time	Neil	Excel Programming	0	September 18th 03 03:52 PM
passing a variable as an argument to a function	Drew[_6_]	Excel Programming	3	July 25th 03 08:51 PM
Passing a variable to a range statement	Mervyn Thomas[_3_]	Excel Programming	3	July 25th 03 02:40 PM
Passing a value to a variable from Userform	Neal Steiner	Excel Programming	1	July 18th 03 09:12 PM

All times are GMT +1. The time now is 03:38 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us