Telly

Here's an example of a Workbook_Open event that prompts the user for data
whenever the workbook is opened

Private Sub Workbook_Open()

Dim x As Variant

x = Application.InputBox("Enter information")

MsgBox x

End Sub

From where is the data that you want to include coming? Will a user be
typing it in the command line, or is it coming from another program?

--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.

"Telly Massaras" wrote in message
...

Nick,

Thanks for your reply. The values that I want to pass in will be
different every time. One value will be a string and the other is an
number. Once the data is read-in to Excell, it will passed into a macro
which will use the values to form a file name from which to read data.
How would the workbook_open event work? It's triggered upon start-up
but how do the values get into Excell?

Thanks,

Telly...



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!