Running Excel from a Server

  • Thread starter Thread starter ibeetb
  • Start date Start date
I

ibeetb

I have a couple of Excel spreadsheets that contain quite a bit of VBA and
ActiveX objects. I want to put them on a shared server and have others
access them from the server. What do the users who will access this need to
have on their PCs? Do they need to have the activex objects on their client
or does the server just need this?
Will the user just be able to open and run the report from their client?

Thanks
 
Generally, excel runs locally - so they would access the file from a drive
on the server and run it locally. In that case, the local machine would
need to have all referenced ActiveX objects.

It is unclear what you are proposing.
 
Sorry if I wasn't clear. Hope you will get this and I would have explained
it better.

I have an excel spreadhseet which I have run automatically at 11 PM every
night on a server. I want various users to view the spreadsheet - actually
they will NOT have to run it, because it runs and grabs its data at night,
by itslef-automatically.
What I need, is for the macros to NOT be enabled when they open it because
when macros are enabled and they open it, they get errors that they are
missing certain activex objects. So my real question I guess is....how can I
diable the macros in code or what do I need to do in order that they may
open and view the sprdsht without getting the errors, yet I need to have the
macros enabled during the night when the report runs on the server
automatically.....

Thanks
 
Have the spreadsheet save a copy of the data in a separate file. If the
users just need the data and none of the code then no need for them to open
your workbook at all.

Tim
 
This may be a little crude but it should work. By setting the Macro security level to Medium the user will have the option of disabling all macros or VBA code when the spreadsheet is opened. Of course this setting will apply to all spreadsheets with code in them

To change the security level on each local application of Excel go to Tools/Macros/Security. Choose the radio button for Medium

TerryK
 
A possible idea:
I assume all activity is initiated in the workbook_open event. Have the
workbook_open event look at application.Path. If it doesn't match the
server, have it exit the sub. Or you might have a unique environment
variable on the server which you can check with the Environ function.
 
Back
Top