ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel Macros (https://www.excelbanter.com/excel-discussion-misc-queries/35308-excel-macros.html)

costin

Excel Macros
 
Hi,

i would like to back up all my macros i have about 30 of them, i would want
to back them up to my drive on the network but i cannot find where they are
located. are they in a folder where i can just copy paste?

Duke Carey

If you've recorded them and saved them in your Personal workbook:

Go to Window|Unhide & unhide Personal.xls

Do a File| Save as and you'll see where to find it.


"costin" wrote:

Hi,

i would like to back up all my macros i have about 30 of them, i would want
to back them up to my drive on the network but i cannot find where they are
located. are they in a folder where i can just copy paste?


JP Jones

I preseme you macros are located in your personal.xls file. If so this can be
found at:

"C:\Documents and Settings\<Your User Name\Application
Data\Microsoft\Excel\XLSTART\PERSONAL.XLS"

"costin" wrote:

Hi,

i would like to back up all my macros i have about 30 of them, i would want
to back them up to my drive on the network but i cannot find where they are
located. are they in a folder where i can just copy paste?


Dave Peterson

You have an answer to your question in .excel.

costin wrote:

Hi,

i would like to back up all my macros i have about 30 of them, i would want
to back them up to my drive on the network but i cannot find where they are
located. are they in a folder where i can just copy paste?


--

Dave Peterson


All times are GMT +1. The time now is 02:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com