Command button on form to open excell spreadsheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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?
Click to expand...

Try
Application.FollowHyperlink "c:\Path\FileName.xls"
 
Back
Top