Simple VBA Spreadsheet (Frontpage

[Marcus]

Does anyboby know how to get simple vba coding to work on
an excel spreadsheet through frontpage. The coding works
within Exel. However once on-line the code falls
over "global Error"

The coding is below

Sub TextBox1_Change()
Cells(4, 2) = TextBox1.Text
End Sub.programming

Sub TextBox2_Change()
Cells(5, 2) = TextBox2.Text
End Sub.
Marcus

 

[MD WebsUnlimited.com]

Hi Marcus,

Excel VBA or any VBA coding that uses the object model of the application
will not work on a web page.

If you need to accomplish this for an intranet then consider using HTA pages
instead. From there you can instantiate the application and run the code.
--
Mike -- FrontPage MVP '97 - '02
http://www.websunlimited.com
Our latest products "At Your Command" and IncludeASP
http://www.websunlimited.com/order/Product/AYC/ayc.htm
http://www.websunlimited.com/order/product/includeASP/includeASP.htm

 

[Guest]

Mike
Sorry about last responce, worked out what client NG means.

However a little confused with regards HTA Pages. What are
they ? I am fairly new to FP.

Marcus

 

[MD WebsUnlimited.com]

HTA's are HTML Application pages. Which means that they are pages that use a
hta extension rather than a .htm one. The system then recognize that they
are allowed special privileges at the desktop. See httt://msdn.microsoft.com
and search for HTA

--
Mike -- FrontPage MVP '97 - '02
http://www.websunlimited.com
Our latest products "At Your Command" and IncludeASP
http://www.websunlimited.com/order/Product/AYC/ayc.htm
http://www.websunlimited.com/order/product/includeASP/includeASP.htm