How to disable autoopen() programmatically

[Karl Steinam]

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

 

[Ron de Bruin]

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

 

[Karl Steinam]

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