How do you get a focexec to open an existing Excel 2007 file?

This message has been edited. Last edited by: JohnB,

Is that to read the contents or to open at your PC

I need to create a link on an html paqe that will open an existing spreadsheet so it displays on the user's monitor and they then can do whatever they need to do with it (sorting, etc.).

So I thought the link would execute a focexec that would have code in it to open the spreadsheet.

What does the focexec do ?

If the Excel file exists, just create a link to it.

Does it need to be saved back though, this is where things get tricky.

How do you create a link to it in the HTML Composer?

I don't use composer, but I think you can create a hyperlink from an object on the page like text.


I tried to use it, and OMG, I think that I'll build by hand.

Can you give me an example?

Tom,

I have the documentation, and know how to create a hyperlink in the HTML Composer. I did not see anything on how to open an existing Excel file.

What I need is a specific example of how to do this via a link in the launch page or a call from a focexec that I could create a hyperlink to in the launch page.

Thank you.

Just point to the excel file.

e.g.
URL = http://server....../path.../excelfile.xls

The same as if you typed it into a browsers address bar.

Tried that, but it didn't work.

Where is your excel file ?

Is it under the APP directory structure, or somehwere else ?

I tried putting it in that application's directory and on my local C: drive. Both times the URL didn't work.

Whats the physical location of the file ?

If its sensitive, them PM me.

Waz's URL approach works for me when I plug it into the IE browser address bar (so it should also work as a link on an HTML page). Here is a sample of the address I entered:

//WF server name/APPROOT/app folder name/full EXCEL file name

That should work.

The only thing I can think of at the moment is the file name its self.

Is there any unusual characters in it.

e.g. spaces or ampersands.

Can you try a simple name.

The other thing is if the APPROOT alias is working OK.

It was a browser issue.

There is a fix from Microsoft:

http://support.microsoft.com/kb/162059