Hi Bob,

Thanks. This is all quite new to me, but yes, I think I have learnt quite a
lot from this post. I will definitely explore all these ideas, and come back
to you. I have tried Patrick's suggestion, and it seems to take me in the
right direction.

Thanks to you once again.

Mangesh



"Bob Phillips" wrote in message
...
Mangesh,

Many system administrators will restrict the functions of products and the
OS, so that the average user is functionally crippled, as part of company
policy. Such restrictions include the ability to set date and time, to add
system variables, etc., and within Excel to run macros by setting the
security setting to high and stopping the ability to change that.

In this instance, if you want to manipulate Excel spreadsheets via code, I
think you will have to do it externally via automation. That is, create an
application using an approved tool, such as VB, that uses Excel as a
server
app, and manipulates it from within your app. It is very straight-forward,
the main learning exercise is to be aware of which object you are
addressing, and reference properly at all times.

Of course, this still leaves the problem that the user will not be able to
install it, the CD drive will be disabled as well if not even sealed, so
you
will need the co-operation of the system administrators for that. They
might
say no, they might say yes but insist on testing it themselves, or they
might say yes. As you need their co-operation, you could also ask them
about
whether they would install a COM add-in, or a simple Excel add-in.
Whatever
way, your first action should be to discuss with them, otherwise you might
just be wasting your time and effort.

--
HTH

Bob Phillips

"Mangesh Yadav" wrote in message
...
Hi Everyone,

I have a spreadsheet which uses macros extensively. Now if a particular
company has a policy which does not allow macros, what is the
alternative
for my spreadsheet.

I know the question is bit unclear regarding the policies, but even I
don't
know how this is done. Another question I have is: when a particular
company
says that it does not allow macros, what is it that they do to prevent
the
user from allowing a macro to run. (Is it something like they disable
the
Tools Security feature...?)

Thanks in advance.

--
- Mangesh
------------------------------------------
Office XP & Windows XP