auto open

  Josquius 21:23 07 Apr 04
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 04

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 04

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 04

after Sub Auto_Open

obviously! :o(

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

LG G6 review: Hands-on with LG’s bold, big-screen shot at perfection

1995-2015: How technology has changed the world in 20 years

How the 2017 Oscar-winning VFX of The Jungle Book were created

The 22 best Safari extensions | Best Safari plugins: Improve Apple's Safari web browser with these…