Open excel worksheet from access

[kkgusta]

HI there,
Is anyone here have any example or have any idea to open an excel worksheet from Access using a Command button. I have a table to store the hyper for the excel work sheet.


Thank in advance,

 

[PHV]

Have you tried the FollowHyperlink method ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[kkgusta]

Hi there,
I have tried the hyperlink method but it's not really what I need. The hyperlink can only help me to open the xls file but not display the specific worksheet that I needed. I have just try the method on faq705-1971 but it doesn't work well i think i have miss something.


Anyway thank for you reply. I need to take a rest. will give it a try later.

 

[bubba100]

Have you tried the macro recorder in Excel. That should record the code to move to the sheet you desire.

 

[PHV]

Have you tried something like this ?
FollowHyperlink "\path\to\workbook.xls", "SheetName!$A1:$A1"

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[fldbryan]

Just use the shell command.