I want to run a macro for every save of excel file

  • Thread starter srinivas kandagatla
  • Start date
S

srinivas kandagatla

my purpose is if any one creates any excel file in the client system, the
file should also be saved in the backup server.
so i thought of running some macro for every save in excel..
but i donno who to put a macro at excel level not at excel sheet level
Please advice me in this regard
 
B

Bill Dilworth

Two things:

1) It sounds like you want to create an add-in for Excel. This would
require the add-in to be installed on each of the computers, since an add-in
is machine oriented (not just sheet or book oriented), but could be applied
to all new or saved sheets opened thru excel.

2) You have landed in the PowerPoint newsgroup by the whimsy of some magical
elves. To follow up with better answers, you may want repost your question
in the Excel newsgroups. :)

--
Bill Dilworth, Microsoft PPT MVP
===============
Please spend a few minutes checking vestprog2@
out www.pptfaq.com This link will yahoo.
answer most of our questions, before com
you think to ask them.

Change org to com to defuse anti-spam,
ant-virus, anti-nuisance misdirection.
..
..
 

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

Top