Publisher and Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jean Lancelin - 02 Apr 2005 08:12 GMT

Hi,

I would like to write a web page under publisher 2003, where there is
button which launch a macro in excel on the server, when clicked.
I found that the following code that I have to put:

Dim xls
Set xls = CreateObject("Excel.Application")
xls.Application.Visible = False
xls.Workbooks.Open ExcelFilePath, 3, False
xls.Run("ThisWorkBook.Macro1")
Set xls = Nothing

But I am a newbe and I don't know how to do.

I thank you in advance for your help.
Jean

Reply to this Message

Ed Bennett - 02 Apr 2005 13:45 GMT

Jean Lancelin <j_lancelin@yahoo.fr> was very recently heard to utter:

> I would like to write a web page under publisher 2003, where there is
> button which launch a macro in excel on the server, when clicked.
> I found that the following code that I have to put:

Why do you want to run a macro in Excel on the SERVER?

You cannot include VBA code in a web page. It doesn't work.

The code you listed is VBScript I think, and will launch Excel on the
CLIENT.

It might open a workbook and so a macro from the server, but it will run on
the client.

This question might be better asked in the .webdesign group.

Signature

Ed Bennett - MVP Microsoft Publisher

Reply to this Message

Tan - 07 Apr 2005 15:45 GMT

Ed,

Is there a possibility to open an Excel document in Publisher and
automatically run a certain macro and doing so in a macro?

Thanks!

Reply to this Message

Ed Bennett - 11 Apr 2005 16:14 GMT

Tan <Tan@discussions.microsoft.com> was very recently heard to utter:

> Is there a possibility to open an Excel document in Publisher and
> automatically run a certain macro and doing so in a macro?

I'm not sure what you're asking - you can insert an Excel sheet as an OLE
object, or you can call Excel and use Excel's automation interface to open a
sheet and execute a macro therein.

Signature

Ed Bennett - MVP Microsoft Publisher

Reply to this Message

Rate this thread: