Help with VB Call function from Excel

[Lawrence M. Seldin, CMC, CPC]

The current code in VB Excel makes me "hard code" all of my datasources.

The specific syntax is:

Call WLE.WebUpdate("$Auto_DailyDataSource1")
Call WLE.WebUpdate("$Auto_WeeklyDataSource

Can someone help modify this code so that any datasource that begins with the name of "$Auto_" with
any name after the "_" be updated.


Here is my existing VB Excel code:

// begin

Public Declare Sub Sleep Lib "kernel32" Alias "Sleep" (ByVal dwMilliseconds As Long)

Sub auto_open()
Dim WLE As WealthLab.WL3
Set WLE = New WealthLab.WL3
Sleep(5000)
Call WLE.WebUpdate("$Auto_DailyDataSource1")
Call WLE.WebUpdate("$Auto_WeeklyDataSource2")
Set WLE = Nothing
Application.Quit
End Sub

// end

Thanks much,

Lawrence M. Seldin, CMC, CPC
Author of POWER TIPS FOR THE APPLE NEWTON and INTRODUCTION TO CSP
Author of RECRUITSOURCE PEOPLESOFT EXAM and RECRUITSOURCE SAP/R3 EXAM


NOTE: To send me an email, remove TAKEOUT from my email address: (e-mail address removed)

NOTE: My web home page: www.seldin.net