Open .xls using Excel Viewer

[Lyda_Faye]

I have my code working to send a .xls to each person. It now opens if the user has MS Excel. But I'd rather use Excel Viewer because it restricts the user to only view and print options. So...

Can I attach a .xls file to an email that will open using Excel Viewer automatically? I want the attachment to always open up using Excel Viewer.

I tried it on an sample icon. It opens fine on the icon but I don't know how/where to code it in VBA of my Excel 2000.


The icon path reads:
"C:\Program Files\XLView\XLVIEW.EXE" " C:\Documents and Settings\lydia\Desktop\OSHA_101001.xls"

 

[Smitty]

I believe that if a user has Excel, the viewer is not an option.

Note If you already have a full version of Microsoft Excel installed on your computer, do not install Microsoft Excel Viewer in the same directory. Doing so causes file conflicts. The default folder location in the installer is c:\Program Files\Xlview.

Why not use .pdf instead?

Smitty