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.

How to get Windows 10 for free | How to install Windows 10: There is still a way to avoid paying…

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

Alex Chinneck’s giant ice cube Christmas tree at Kings Cross

Apple rumours & predictions 2017: The iPhone 8, new iPads, and everything else you should expect fr7…