export excel macros

B

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
[email protected]
 
G

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
 
D

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
 
Top