Open an existing Excel file using cmd button 2

[DaMorf]

Hi,

I am attempting to write code into a button that will open an existing excel file that i have created.

i can output data to a file but cannot seem to just open it?

Any idea's?

Many thanks,

 

[lespaul]

Check Out Access VBA Forum705, the FAQ area probably has something that will help.


Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases: The Fundamentals of Relational Database Design

 

[PHV]

Two common ways:
1) FollowHyperlink
2) GetObject

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

 

[DaMorf]

PH, thanks for your reply.

How would i incorperate that into the command, do you have an example code?

Thanks

 

[PHV]

What have you tried so far ?

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

 

[DaMorf]

I am trying to add it into an existing button that executes a macro, i am new to VBA so am not sure what kind of code would be required, all i have tried to use so far are docmd functions.

i assumed that i would put in the function followed by the filepath, probably a bit naive!!!

FollowHyperlink "\\t001dfsd3.axa-uk.intraxa\shared3\union_a_sales\planning\Team\(7) Andrew Morfey\Payroll DB Excel Download Files\ExpWholeFormatted"


Thanks,

 

[jebry]

Hi!

You don't need code, just put the path in the hyperlink property of the button and the file will open.

hth


Jeff Bridgham
Purdue University
Graduate School
Data Analyst

 

[DaMorf]

That's done it!!

Thanks both for replies!!!