Using vba code how to open an Excel file to analize data

[Gezza]

I'm looking for a way of opening an excel file directly after running a report to export to excel using vba code

 

[pbaldy]

2 VBA commands and a technique:

FollowHyperlink
Shell
"automation"

 

[Gezza]

Thank you for reply,

could you please copy and paste the code you suggested?

 

[pbaldy]

The first 2 are in VBA help; did you look there?

 

[Gezza]

Thank you Pbaldy,

I have done it using FollowHyperlink

Regards
Gezza