Simple VBA Spreadsheet (Frontpage

  • Thread starter Thread starter Marcus
  • Start date Start date
M

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
 
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
 
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
 
Back
Top