Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 208
Default Personal Macro Workbook

Hi

I know that the Personal.xlsb file is stored in the C:\Users\user
name\Application Data\Microsoft\Excel\XLStart folder of each computer in
Vista/Office 07


MY QUESTIONS A

1. Whats the best way to get personal macros from my C drive on my computers
to be available for use across a network so anyone can start Excel and be
able to run my personal macros and hopefully not overwrite any of their
personal macros?

2. I want to take my personal macros from one laptop and put them to use on
another laptop. Do I export the Personal file to a bas file on the laptop to
send from let say onto a flash disk, and them import them into the other
Personal file on the computer to receive via the flash disk? Is this the
best way?

Thank you!

Craig


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,123
Default Personal Macro Workbook

Use a add-in Graig

One way
http://www.rondebruin.nl/qat.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Craig" wrote in message ...
Hi

I know that the Personal.xlsb file is stored in the C:\Users\user
name\Application Data\Microsoft\Excel\XLStart folder of each computer in
Vista/Office 07


MY QUESTIONS A

1. Whats the best way to get personal macros from my C drive on my computers
to be available for use across a network so anyone can start Excel and be
able to run my personal macros and hopefully not overwrite any of their
personal macros?

2. I want to take my personal macros from one laptop and put them to use on
another laptop. Do I export the Personal file to a bas file on the laptop to
send from let say onto a flash disk, and them import them into the other
Personal file on the computer to receive via the flash disk? Is this the
best way?

Thank you!

Craig


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Run macro in workbook from PERSONAL.XLS Brettjg Excel Programming 1 March 18th 08 01:11 AM
Where is Personal Macro Workbook? fxcel Excel Discussion (Misc queries) 2 June 17th 06 02:26 PM
No Personal Macro Workbook? Kou Vang[_2_] Excel Programming 2 February 3rd 06 05:05 PM
Personal macro workbook and personal.xls John Kilkenny Excel Discussion (Misc queries) 1 June 14th 05 09:43 PM


All times are GMT +1. The time now is 02:40 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"