Open Excel Directly instead of in IE 1

[Tahas]

Hello friends,

I have an Excel file template that my users need to access from our intranet that uses cold Fusion. This file has macros that I created using VBA codes. I need help in opening file directly in Excel as opposed to Internet Explorer.

Any help would be highly appreciated.

Kind regards,
TH

 

[LyndonOHRC]

<cfcontent type="Application/vnd.ms-excel" file="C:\YourFolder\YourFile.xls" deletefile="no">

Lyndon

---People Remember about 10% of what you say ---They never forget how you made them feel. Covey

 

[Tahas]

Hello Lyndon,

Thanks for your help. Unfortunately, this is the reply that I received from web team

"I inserted the code but it doesn't seem to do anything."

I don't know how to tell them again

Thanks,
TH

 

[LyndonOHRC]

Are you sure you have the correct path and file name of the file you are trying to download? Remember the path is reletave to the web server.

It might help if you include the tag exactly a you've written it in your response.

Lyndon

---People Remember about 10% of what you say ---They never forget how you made them feel. Covey

 

[Tahas]

Happy Friday Lyndon,

Below is how I have provided my code to programmer.

<cfcontent type="Application/vnd.ms-excel" file="\\Fsmain\Hss\Triple P live database\Triple P Seminar\Age Group (0-12)\Triple P Seminar - Age 0-12.xls" deletefile="no">

On another site I got following instruction to open file directly in Excel
Navigate to Control Panel > Tools > Folder Options > File types > Select xls > Advanced > un check "browse in same window" box.

BUT Cold Fusion does two things with this:
1. Open IE instance without opening file PLUS
2. Open file directly in Excel but as read-only

Thanks,
Taha

 

[LyndonOHRC]

Does CF have permission in that folder? Also, from the server console open that path/file name, as you are passing it to the file argument in cfcontent tag and see if it is valid.

Lyndon

---People Remember about 10% of what you say ---They never forget how you made them feel. Covey

 

[Tahas]

Yes ,I checked and it is valid

 

[LyndonOHRC]

I believe you have to use your file system path and file name i.e. C:\YourFolder\YourFile.xls with the File argument of this tag.

Lyndon

---People Remember about 10% of what you say ---They never forget how you made them feel. Covey

 

[Steve688]

For what it's worth this late...

We had the same issue opening ANY excel file from the web. The only way we could find around it was to change the individual client's Folder options.

Oopen Windows Explorer
Tools -> Folder options -> File Types
Find the XLS extension.
Click the 'advanced' button and remove the checkmark for 'Browse in same Window'

This works okay in a small environment. In a larger client enviroment it might be possible to apply some sort of policy for this setting.

(works for any other extension too)

HTH

Steve

 

[Tahas]

Thanks Steve for your help

Regards,
TH