'Server-side' apps

[DieuSoleil]

Is it possible to have vba apps server-side? If so, are any licenses
required?

Thanks

 

[Tom Ogilvy]

Office apps are by their very nature, interactive. Thus Microsoft
discourages their use on Servers. If you mean that the server has one copy
on a shared drive and multiple people use it, I would think each person
would need a license.

 

[Wei-Dong XU [MSFT]]

Hi,

Thanks for posting in the group!

I have reviewed your thread. Currently I am finding somebody who could help
you on it. We will post back in the newsgroup as soon as possible.

If there is anything unclear, please feel free to post in the group and we
will follow up there.

Best Regards,
Wei-Dong Xu
Microsoft Product Support Services
Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Peter Huang]

Hi,

As Tom said what do you mean by run vba server-sdie? Do you mean you wants
to automation the Office product and run the vba code inside?
You may try to take a look at the link first.
INFO: Considerations for Server-Side Automation of Office (257757)
http://support.microsoft.com/default.aspx?scid=KB;EN-US;257757

Best regards,

Peter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[DieuSoleil]

Peter,

As a workaround to my other question (Limitations of shared workbooks),
I was wondering if it would be possible to place an excel based app (a
userform which writes data to, and reads data from worksheets) on a
server and thus make it available to multiple users via a url.
Unfortunately I would be unable to use MS Access, but I need to capture
and store all the data entered through the userform.

I could use a dedicated machine for the purpose if necessary.

Would this be possible, and if so how could I achieve it?

Thanks again,
Iain

 

[Yan-Hong Huang[MSFT]]

Hello Iain,

As I understand, currently you has one server which can run Access, Excel
and has some data. Now you want you web client users can view and input
some data into that Access database or Excel work book, right?

If that, that is typically a asp or asp.net web application model. Please
don't use Access, Excel in server side. That is not a good practice. The
best way is to devise a web application so that you web client can
input/view data in server side Access and Excel. All that your client needs
is a web browser such as IE. They don't need Access or Excel installed.

The following are some good articles for your reference:
"HOWTO: Use ASP to Query and Display Database Data in Excel"
http://support.microsoft.com/?id=189198

"HOWTO: Query and Update Excel Data Using ADO From ASP"
http://support.microsoft.com/?id=195951

"HOW TO: Query and Display Excel Data by Using ASP.NET, ADO.NET, and Visual
C# .NET"
http://support.microsoft.com/?id=306572

"HOW TO: Retrieve and Display Records from an Access Database by Using
ASP.NET, ADO.NET, and Visual C# .NET"
http://support.microsoft.com/?id=308100

"HOW TO: Update Information in a Microsoft Access Database Using ASP in
FrontPage 2000"
http://support.microsoft.com/?id=240090

and etc.

If you are not familar with asp or asp.net programming, you may need to buy
some books and learn from it first.

Hope that helps.

Best regards,
Yanhong Huang
Microsoft Community Support

Get Secure! ¨C www.microsoft.com/security
Register to Access MSDN Managed Newsgroups!
-http://support.microsoft.com/default.aspx?scid=/servicedesks/msdn/nospam.as
p&SD=msdn

This posting is provided "AS IS" with no warranties, and confers no rights.