vba courses london - Perform deletions on Start up

The UK's most regular instructor-led training courses.
Training information: vba courses london · Excel london

Resolved · Low Priority · Version Standard

Perform deletions on Start up

Julian has attended:
Excel VBA course

by - delegate Julian [3 posts] (2006 Dec 14 Thu, 12:54) Reply

I want to input a future date into a macro that performes a function when:
1. The workbook is opened, and
2. It recognises that the inputted date is today or has been passed

I guess it would be something like this:
The following written in the "Workbook" module

Public Sub DeleteSheetsDate ()
If Date => #25/12/2007# Then Worksheets("Sheets1") _
And Worksheets("Sheets1").Delete
End if
End Sub

Many thanks
Julian

RE: perform deletions on Start up

by - trainer David gold contributer [428 posts] (2007 Jan 2 Tue, 12:45) Reply

Hi Julian

Sorry for the delay in getting back to you but our offices have been closed over Christmas. We our now processing all of our forum posts, so we will get back to shortly with an answer for you question.

Thanks

David

RE: perform deletions on Start up

by - trainer Garry gold contributer [188 posts] (2007 Jan 2 Tue, 16:48) Reply

Sub auto_open()
If Now() > #12/11/2006# Then
Worksheets("Sheet1").Delete
End If
End Sub

this is the code but you must name it auto_open()

· How To Find A Good VB For Access Trainer
· Should You Send Managers To VBA Training?
· Company Roles in Visual Basic Training
· What Is Microsoft Excel VBA and How Can It Help You Work Smarter?
· Introduction to Visual Basic for Applications

Vba tip:

Suspend DisplayAlerts in VBA

To stop Excel asking you things like "Do you want to delete this file...", use the following line of code at the beginning of the relevant VBA procedure:

Application.DisplayAlerts = False

At the end of the procedure make sure you use the following code to reactivate Display Alerts:

Application.DisplayAlerts = True

View all VBA hints and tips