Formula to launch an excel file on a server?

HCL Domino Domino Forum
1

I have a form with a field that contains the path and filename of an excel file I want to edit. I simply want to launch that file. Can someone help me with the formula or LS?

example…

FIELD FileNm:=“s:\myreports\dailyreport.xls”

Thanks in advance!

2

Subject: Formula to launch an excel file on a server?

Take a look at @command with execute…

This formula launches 1­2­3 for Windows and loads the worksheet named SALES.WK4.

@Command( [Execute]; “C:\123W\PROGRAMS\123W.EXE”; “C:\123W\WORK\SALES.WK4” )

You could take that and convert to Excel.

3

Subject: Formula to launch an excel file on a server?

I found this tidbit along the way and squirrelled it until now.

File:///Your/Network/File/Path/

Since this is being executed at any location, you should use DNS-resolvable names, not drive letters.

I.E.

File:///server1/shared/notesstuff/excel.xls

Not even sure if this works, but it’s the next thing I would try.

4

Subject: Formula to launch an excel file on a server?

The value in the field FileNm is My Report.xls

I am using this formula, but it tries to open a file called ‘My.xls’. I know this is a spaces issue. How do I syntax the command to handle these spaces? Thank you

X:=FileNm;

@Command([Execute]; “C:\Program Files\Microsoft Office\Office10\excel.exe”; X)

5

Subject: Try:

X := “"” + FileNm + “"”;@Command([Execute]; “C:\Program Files\Microsoft Office\Office10\excel.exe”; X)

6

Subject: RE: Try:

Works great, thanks Bill

7

Subject: Formula to launch an excel file on a server?

I found this tidbit along the way and squirrelled it until now.

File:///Your/Network/File/Path/

Since this is being executed at any location, you should use DNS-resolvable names, not drive letters.

I.E.

File:///server1/shared/notesstuff/excel.xls

Not even sure if this works, but it’s the next thing I would try.