Opening Excel file from Form 2

[dbero]

I have tried using the SHELL function with the address of the Excel file a UNC, but to no avail. Can you assist me with the proper use to open an Excel file with focus?

RetVal = Shell("\\a0001-app0229-s\DLCodes\Withdrawn\DLSpeed\feeds\Backdate.xls", 4)

Thank you

 

[Remou]

How about:
hl = "\\a0001-app0229-s\DLCodes\Withdrawn\DLSpeed\feeds\Backdate.xls"
FollowHyperlink hl

 

[dbero]

Thant worked great. Thank you very much.
May I ask another question? When I create a form using the wizard, you can select the "pretty" color schemes. However, when I create a form manually, I see no way to select the "pretty" schemes. Is it possible?

thanks again

 

[Remou]

Yes. Choose Autoformat from the Format menu in design view. You can also create your own custom pretties and save them using Autoformat.