If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Command button on form to open excell spreadsheet
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? |
#2
|
|||
|
|||
Command button on form to open excell spreadsheet
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. |
#3
|
|||
|
|||
Command button on form to open excell spreadsheet/sheet not openin
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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Form will not stay open | Rich | Using Forms | 4 | June 21st, 2004 10:13 PM |
error opening form "cannot open anymore databases" | martin | Using Forms | 4 | June 18th, 2004 06:07 PM |
Recordset in subform based on field in parent form | Lyn | General Discussion | 15 | June 14th, 2004 03:10 PM |
open form only when necessary | Scott | Using Forms | 2 | June 9th, 2004 04:13 PM |
surely a form with a ListBox can be used in a query? | 1.156 | Running & Setting Up Queries | 14 | June 2nd, 2004 04:54 PM |