Userform in Excel

  • Thread starter Thread starter TotallyConfused
  • Start date Start date
T

TotallyConfused

Sorry if this is a stupid question but do not know who else to ask. Can an
Excel Userform be used on a website? If not what program/application do you
recommend for forms on a website and database to track the data? Thank you.
 
Basically, the answer is "no" to userforms (and Excel in general) on a
web site. Excel should really be used only in a "single user" mode.
Any sort of sharing, even that provided by Excel itself, is, to put it
mildly, problematic.

The larger question of what other applications could be used is a very
broad question, depending many factors, such as how many simultaneous
users might there be, how many records are in the database, what kind
of security you need, whether you intend to develop such web-based
functionality in house or hire it out, whether the users are all
within your company or whether the web site is accessible to the
entire Internet, and, not the least by a mile, how much money do you
have to spend?

If the application is to be used only internally by your company or
working group, no more than, say, 20 users, you could probably do the
whose thing in VB.NET and an Access database, or perhaps even Access
alone. Basic software costs for this would be approx $1000, plus
whatever it would cost to get someone to configure the database and
write some sort of user interface to those databases.

Somewhere in the middle would be SharePoint, which can provide some
Excel-related functionality, running on top of Windows Server 2008 and
SQL Server Express.

At the other end, you could go SQL Server Enterprise, ASP.NET, IIS,
and a dedicated Windows Server 2008 box or two. There, software costs
would be in the $20,000+ range, plus development costs and admin
costs.

Between these scenarios are hundreds of variations.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)
 
My 2-cents...

I've used this before:
http://www.hkvstore.com/aspreportmaker/

I think it cost $100. It works great with an MS Access back end. As the
developers states, the tool can be used with any 'ADO data source', so Excel
should work fine. If you are feeling really ambitious, you may want to try
this:
http://www.microsoft.com/express/vwd/

It is totally free and very powerful!! Only one reason would prevent me
from full recommending this as a solution...it take a bit of work to get
acquainted with web development with VWD. It really depends on your appetite
for these types of things, but I would think it will take a good year or so
to get very proficient with VWD. However, you can probably find some video
tutorials online (there are many) and join some discussion groups (there are
many) and buy some books (there are many) and get up to speed with some BASIC
things in maybe a couple weeks or month or so.

HTH,
Ryan--
 
Thank you very much for your explanation. It was suggested to me to try and
put an Excel userform on our company website. Form is only used for
requesting a service for our dept. However, these service requests would
have to be tracked. Therefore, I would have Excel Userform on Share Point
for users to access form email a copy to receiver who would then download the
request to Access db for tracking. However, I wasn't sure if Excel userform
could be used on web be and therefore my post. Thank you again for your time.
 
Thank you for your 2-cents. I am not a programmer, but have been working
with Access and Excel for years. Do you have to be a programmer to work with
VWD??
 
Back
Top