export excel macros

[Brad]

I am gettting a new computer from my IT staff this week. Is there a way to
backup all my personal macros. I have done a search for personal.xls and
have not come up with anything. Can anyone provide answers.

Brad Wilson
(e-mail address removed)

 

[Frank Kabel]

Hi
search for your personal.xls in your xlstart folder

 

[Brad]

I did and I can't find it.

Hi
search for your personal.xls in your xlstart folder

 

[Gord Dibben]

Brad

When you open up a session of Excel is your Personal.xls opened hidden and
your macros are available?

If so, you have one somewhere.

Go to Windows Explorer and Tools>Folder Options>View and make sure "show all
files" is checked.

If not, perhaps your macros are in some other file not named Personal.xls.

Which file(s) open when Excel starts?

Hit ALT + F11 to get to the Visual Basic Editor screen.

Hit CRTL + r to open the Project Explorer.

What do you see listed there?

Gord Dibben Excel MVP

 

[Dave Peterson]

Another option:

Open excel
hit alt-f11 to goto the VBE
hit ctrl-r to see the project explorer
verify that personal.xls was opened.

hit ctrl-g to see the immediate window.
type this and hit enter:

?workbooks("Personal.xls").fullname
or for just the path:
?workbooks("Personal.xls").path