executable to install macro into personal.xls
 

Hi, Excel macro noob here :)

I have the need to install a macro on some users machine (clients) an
was wondering how I could go about it. I'm thinking, detect i
personal.xls exists, and "some how" (tm) copy the contents of my ne
module into it.

Does that sound right

--
facet
-----------------------------------------------------------------------
facets's Profile: http://www.excelforum.com/member.php...fo&userid=2483
View this thread: http://www.excelforum.com/showthread.php?threadid=38383

executable to install macro into personal.xls
 

You can write code in a workbook that opens other workbooks and insert
modules and code.

Jeroen


--
Kaak
------------------------------------------------------------------------
Kaak's Profile: http://www.excelforum.com/member.php...fo&userid=7513
View this thread: http://www.excelforum.com/showthread...hreadid=383836

executable to install macro into personal.xls
 

The best way would be to write your code in an add-in and
distribute the add-in to the users.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"facets"
wrote in message
...

Hi, Excel macro noob here :)

I have the need to install a macro on some users machine
(clients) and
was wondering how I could go about it. I'm thinking, detect if
personal.xls exists, and "some how" (tm) copy the contents of
my new
module into it.

Does that sound right?


--
facets
------------------------------------------------------------------------
facets's Profile:
http://www.excelforum.com/member.php...o&userid=24831
View this thread:
http://www.excelforum.com/showthread...hreadid=383836

executable to install macro into personal.xls
 

Follow Chip's advice. Don't mess with anyone's personal.xls workbook. If
your code isn't working properly or if the user doesn't want it, it's a
pain for a user you've imposed it upon to find what's wrong and delete
your code.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


facets wrote:

Hi, Excel macro noob here :)

I have the need to install a macro on some users machine (clients) and
was wondering how I could go about it. I'm thinking, detect if
personal.xls exists, and "some how" (tm) copy the contents of my new
module into it.

Does that sound right?