executable to install macro into personal.xls

[facets]

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?

[Kaak]

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

Jeroen

[Chip Pearson]

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" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>

[Jon Peltier]

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?
>
>