Macro in Excel

[George]

Hi there, what I am asking today is a bit complicated but
here we go, I want to know if I can create a macro in
Excel 2000 that when a specific excel file name "Reports"
opens, a message box will appear asking the user what
report from a specific data base he wants to analyze it in
that excel file. Feel free to ask if you dont understand
what I want to do or what my idea is about. Any help will
be greatly appreciated.

 

[Bob Phillips]

In that specific file, add this macro, or your variation of

Sub Auto_Open()
ans=Inputbox("Which report?")
End Sub

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Guest]

Bob:
But how do I call my database reports from excel, what
code should I use.

 

[Bob Phillips]

I would need more detail on what these database reporters are to answer
that.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[George]

I have 24 reports in my database, all are tabular and they
have data like names, numbers, yes/no. Thanks to you I
have the msgbox to ask the user whats the name of the
report he wants to analyze but now I need the code to call
this reports from the database.