Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Newbie question about publishing VBA project to the web

Hello Dear Excel Experts,

I am writing a fairly simple postage calculator in Excel 2000 VBA.
Postage rates are stored on one worksheet, with input text boxes,
control buttons (clear input cells, calculate postage etc.) and output
cells on another. I'd like to publish this on a web page.

I don't want it to look like Excel - just look like text boxes, and
buttons on a web page.

I'm not sure where to start with this. I don't think "Save as a web
page" will work, with interactivity and macros running in the
background. I have standard webspace with my ISP account - do I need
to have special webspace that one can run executables from?

Any help on where to make a start would be appreciated.

L
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,718
Default Newbie question about publishing VBA project to the web

Your best bet may be to let users download your Excel file.

If you Save as Webpage with interactivity then you'll have to replace your
macros with ASP scripts or whatever. And users will need to have the Office
Web Components installed.

Otherwise, you should develop this as a true web application using Frontpage
or the tool of your choice.

--
Jim Rech
Excel MVP
"Leodiensian" wrote in message
om...
| Hello Dear Excel Experts,
|
| I am writing a fairly simple postage calculator in Excel 2000 VBA.
| Postage rates are stored on one worksheet, with input text boxes,
| control buttons (clear input cells, calculate postage etc.) and output
| cells on another. I'd like to publish this on a web page.
|
| I don't want it to look like Excel - just look like text boxes, and
| buttons on a web page.
|
| I'm not sure where to start with this. I don't think "Save as a web
| page" will work, with interactivity and macros running in the
| background. I have standard webspace with my ISP account - do I need
| to have special webspace that one can run executables from?
|
| Any help on where to make a start would be appreciated.
|
| L


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Newbie question wayne New Users to Excel 6 June 27th 08 02:23 PM
Real Newbie newbie question Dave New Users to Excel 0 January 10th 07 07:55 PM
Newbie Question - Subtraction Formula Question [email protected] Excel Discussion (Misc queries) 3 May 5th 06 05:50 PM
Newbie Question Pete B Excel Discussion (Misc queries) 0 December 29th 05 11:27 AM
Newbie Question Random Excel Programming 2 August 3rd 03 03:25 PM


All times are GMT +1. The time now is 05:59 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"