Launch Excel Document with Script

HCL Domino Domino Forum
1

If I want to launch a word document using script, this works just dandy:

Set msdoc = CreateObject(“word.application”)

msdoc.Documents.Open “C:\Department\WordDocument.doc”

launchdoc.Application.Visible = True

But if I want to do the same thing to launch an Excel workbook, it just isn’t happening.

I’ve researched this up and down and can’t figure out where I’m going wrong, and any suggestions on how to launch an Excel document are far more involved than this relatively simple method for launching an existing Word document.

I do need to use Script because of some other things I have going on in the code, all of which works fine.

Am I just completely missing the boat on this one?

2

Subject: Isn’t it as simple as this?

Dim xlApp As VariantSet xlApp = CreateObject(“Excel.Application”)

Call xlApp.workbooks.open(“C:\temp\whatever.xls”)

xlApp.Visible = True

This code works for me just fine in Notes 6.5 / Excel 2003, and should also work for all recent versions of Notes and Excel, so I don’t know if there is something unusual or broken in your installation.