'Server-side' apps

T

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.
 
W

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.
 
P

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.
 
D

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

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
 
P

Peter Huang

Hi,

From your description, it seems that you want to share a workbook with
macro code among a few users, so that every user can access the workbook
independently and run the macro code. Based on my test, it seems to be OK.

Here is my reproduce code.
[UserForm1]
Private Sub CommandButton1_Click()
Dim cn As New Connection
cn.ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist
Security Info=False;Initial Catalog=Northwind;Data Source=<computer>"
cn.Open
Dim rs As New Recordset
rs.CursorLocation = adUseClient
rs.CursorType = adOpenDynamic
rs.Open "Select * from customers", cn
Sheet1.Cells(1, 1).Value = rs.RecordCount
rs.Close
cn.Close
End Sub

[Macro Test]
Sub Test()
UserForm1.Show vbModal
End Sub

1. I shared the workbook on machine A(e.g. \\A\test\test.xls)

2. user A on machine B open \\A\test\test.xls and run the macro test and
then click the button on the form

3. user B on machine C open \\A\test\test.xls and run the macro test and
then click the button on the form
All is OK.

If I have any misunderstanding, please feel free to let me know. You may
have a try or you may just post a reproduce code together with detailed
repro steps so that we can do further troubleshooting.

Also I have reviewed your another post "Limitations of shared workbooks",
it seems that the two ones are related, so I will follow you up here and
close that one first.
If you have any concern, please feel free to let me know.


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.
 
Y

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.
 
D

DieuSoleil

Peter,

I have discovered that the problem is caused when any of the following
attributes of QueryTables are present:

.FieldNames
.PreserveFormatting
.SavePassword
.SaveData

It doesn't appear to matter whether these are set to True or False: in a
shared workbook their presence kills my Sub.

Thanks for all the help.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
 
P

Peter Huang

Hi,

I can reproduce the problem on my side, now I am researching the problem,
if I have any new information, I will update you ASAP.

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.
 
P

Peter Huang

Hi,

I have confirmed the issue with Excel expert that this error is the
expected behavior, as noted in the error message. Because you have used
the "Share Workbook¡­" command to share the workbook, Excel disables
certain object model methods and properties. The methods and properties
that are disabled will return the error you're seeing. It doen'st matter
whether you're the only one with the workbook open or not.

If you still have any concern on this issue, please feel free to post here.

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.
 
P

Peter Huang

Hi DieuSoleil,

If you still have any concern on this issue, please feel free to let me
know.

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Corrupt? Scrolling while viewing two pages side by side, pages go wonky? 0
Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0
You'll need a new app to open this about link 1
Data Form 1
usage "AddressOf TimerProc" in Excel97 1
View only UserForm? 4
Inserting a variable number of rows in a worksheet 1
Select Visible sheets 5

Top