Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userform in Excel
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userform in Excel
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) On Mon, 7 Sep 2009 09:25:01 -0700, TotallyConfused wrote: 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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userform in Excel
My 2-cents...
I've used this befo 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-- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Chip Pearson" wrote: 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) On Mon, 7 Sep 2009 09:25:01 -0700, TotallyConfused wrote: 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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userform in Excel
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. "Chip Pearson" wrote: 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) On Mon, 7 Sep 2009 09:25:01 -0700, TotallyConfused wrote: 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. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userform in Excel
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?? "ryguy7272" wrote: My 2-cents... I've used this befo 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-- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Chip Pearson" wrote: 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) On Mon, 7 Sep 2009 09:25:01 -0700, TotallyConfused wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
fill userform textbox from userform listbox clik event | Excel Programming | |||
Is there an easy Copy/Paste of a Userform ? (Entire Userform Including tx & cbx's) | Excel Programming | |||
Looping procedure calls userform; how to exit loop (via userform button)? | Excel Programming | |||
Activating userform and filling it with data form row where userform is activate | Excel Programming | |||
Linking userform to userform in Excel 2003 | Excel Programming |