Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deploy a vba application over an intranet
I have written an xl application (consisting of a userform, and
worksheets which capture data entered via said userform) that I would like to deploy over a corporate intranet. Ideally, I would like to have the worksheets act as my database and store all the information entered. I have 3 questions: Is this possible? What are the implications of multiple users at one time? What (if any) licenses would be required? If it was necessary, I could have one machine dedicated to this task. All users will have high-spec PCs running a minimum of Office 2000. Any help would be appreciated. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deploy a vba application over an intranet
hi,
licences - if all users have xl on their machine then the licence issue is resolved profided your IS dept aquired the neccessary number of licences. as you described i don't think it's possible. not with multiple users at one time. only 1 person have have read/write permissons. the rest would open it read only. if you put the file on a public drive, each user would pull up a copy of the file. each time it was saved, it would overwrite last users input. the data base would have to be a front end\back end set up. it's needs to be set up so that the users input to a form and the input is set to a main database that you control. ie multiple forms, 1 central table with all writing to the 1 table. this would best be done with access. but if you want excel, the dedicated machine might be your best option. nix the network idea. -----Original Message----- I have written an xl application (consisting of a userform, and worksheets which capture data entered via said userform) that I would like to deploy over a corporate intranet. Ideally, I would like to have the worksheets act as my database and store all the information entered. I have 3 questions: Is this possible? What are the implications of multiple users at one time? What (if any) licenses would be required? If it was necessary, I could have one machine dedicated to this task. All users will have high-spec PCs running a minimum of Office 2000. Any help would be appreciated. . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deploy a vba application over an intranet
Additionally then, how do I go from having an xl workbook which contains
the userform and worksheets, to having a front/back end solution where one xl workbook houses my db table (only one will be necessary) and the userform (how do I make this available to users at a url?) can talk to it? Unfortunately, Access is not an option. Many thanks for the help. *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to deploy change of Default Font? | Excel Discussion (Misc queries) | |||
How to deploy an Excel 2003 solution | Excel Discussion (Misc queries) | |||
What's the best way to deploy a VB business logic with Excel? | Excel Programming | |||
Can't deploy my .xls to other PCs... | Excel Programming | |||
Deploy Excel 2002 add-in | Excel Programming |