Hello,

I am getting an error trying to open the sheet....any other suggestions or
is that how it has to work?Once again, it opens a work book but not a
specific sheet and no matter what i do it goes to the workbook....any futher
assistance would be appreciated.

"fredg" wrote:

On Thu, 12 Aug 2004 08:51:25 -0700,
wrote:

Hello,

I had posted this question in design and i received a
spammer link so here is my question and i hope you can
help,

On my form, i have tried the steps with the command button
to open an excell
worksheet on event but the results are it opens a
workbook and then i have
to use file open on the workbook to open a sheet.Is there
a way i can use the
command button to open a saved worksheet(for example--
JoesNotes) on my
desktop or if not just to open any blank excell worksheet?

Try
Application.FollowHyperlink "c:\Path\FileName.xls"
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.