topic Re: Writing vb script into an Excel file in ODS and Base Reporting

Writing vb script into an Excel file

Airgonomike — Fri, 31 Jan 2014 16:11:43 GMT

Hi,

Is it possible to use ExcelXp to write some vb macros into the Excel file at the time it is created?

Example, would I be able to create an Excel file with this Macro pre-written in it?

Sub Macro()

Sheets(1).Select

End Sub

Re: Writing vb script into an Excel file

Cynthia_sas — Fri, 31 Jan 2014 23:08:18 GMT

Hi:

This is a question for Tech Support. I know that with some of the tagset templates, especially the ones designed for Excel, it is possible to use an Excel macro. I am not so sure about VB. The tagsets.tableeditor template, for example uses embedded JavaScript code to take an HTML file and write it to Excel. But, I don't know how "modifiable" the JavaScript is or whether you can substitute VB instead. Really a question for the tagset templates and VB experts in Tech Support.

cynthia

Re: Writing vb script into an Excel file

mattyclown — Sat, 08 Feb 2014 03:31:31 GMT

I did not use ExcelXpm to create Excel file so I do not know whether following code is what you are looking for. Hope it can offer you some useful information to help you finish your Excel reading application.

You can find the code at this page:

VBScript to Write a Macro within an Excel file - Stack Overflow