How to disable autoopen() programmatically
 

Hi All,

sorry for my poor english, but i hope you understand me.

I have an Excel-File, that has a autopen-Macro, which shows a Fom, when
loading the Excel-File.

Now i want to read some data from the worksheet by vb_script, vb, .net
(programming language doesen't matter). But now, the auto_open-Makro is
annoying, because it pop-ups on the screen. So how can i disable this
macro by program (not in Excel himself, that would be easy!) ?

Thanks in advance

Karl

How to disable autoopen() programmatically
 

Hi Karl

Sub Auto_open()
MsgBox "Hi"
End Sub

Must be in a normal module
If you use a Auto_open macro then this wil not run if you open the file with a macro

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


"Karl Steinam" wrote in message ...
Hi All,

sorry for my poor english, but i hope you understand me.

I have an Excel-File, that has a autopen-Macro, which shows a Fom, when loading the Excel-File.

Now i want to read some data from the worksheet by vb_script, vb, .net (programming language doesen't matter). But now, the
auto_open-Makro is annoying, because it pop-ups on the screen. So how can i disable this macro by program (not in Excel himself,
that would be easy!) ?

Thanks in advance

Karl

How to disable autoopen() programmatically
 

Ron de Bruin wrote:

Hi Karl

Sub Auto_open()
MsgBox "Hi"
End Sub

Must be in a normal module
If you use a Auto_open macro then this wil not run if you open the file with a macro

Thanks for the quick answer

KS