| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sending a macro as an executable? | Excel Discussion (Misc queries) | |||
| Personal macro workbook and personal.xls | Excel Discussion (Misc queries) | |||
| macro to executable | Excel Programming | |||
| personal.htm & personal.xls in Macro | Excel Programming | |||
| Excel macro to VB executable | Excel Programming | |||
Linear Mode
