auto open

  Josquius 21:23 07 Apr 2004
Locked

Josquius Wed, 31.03.04 | 20:12
On excel how can you get VB programmes to run when you open up the document in question?
Also is there anyway to make things happen on certain dates without saying if date= 1/2/05 (i.e. the first of the month every month)



VoG™ Wed, 31.03.04 | 20:19
Sub Auto_Open()
If Day(Now()) = 1 then

Call MySubroutine

End If

End Sub





I thought it was done however the auto open is not working, so how do you get a auto open on excel?

  VoG II 21:27 07 Apr 2004

If the routine is in an Excel modulle and is called

Auto_Open

then it should run.

To check that it is add this immediately after Sub Auto_Run

MsgBox "Running"

  Josquius 21:28 07 Apr 2004

ah a excel module, I put it in with a normal form, I'll try one of these module things

  VoG II 21:28 07 Apr 2004

after Sub Auto_Open

obviously! :o(

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Alienware 17 R4 2017 review

Is this the future of VR and AR?

Best iPad buying guide 2017

Comment regarder le Bureau des Légendes en ligne ?