S
Steen
I have got a new computer and want to move macros in my Personal Macro
Workbook from my old computer - any help on how to do?
Steen
Workbook from my old computer - any help on how to do?
Steen
M
Mike H
Hi,
Because you say 'new' computer then I'm assuming you don't have anything in
personal.xls on that computer so you can simply copy the file from the old to
the new. Personal .xls can be found in something like
C:\Documents and Settings\username\Application Data\Microsoft\Excel\XLSTART
Copy it and put it in the same directory on the new computer.
If your new computer does have macros in personal.xls then you can
export the modules from personal.xls(1) as *.bas files to the new one
Mike
Because you say 'new' computer then I'm assuming you don't have anything in
personal.xls on that computer so you can simply copy the file from the old to
the new. Personal .xls can be found in something like
C:\Documents and Settings\username\Application Data\Microsoft\Excel\XLSTART
Copy it and put it in the same directory on the new computer.
If your new computer does have macros in personal.xls then you can
export the modules from personal.xls(1) as *.bas files to the new one
Mike
J
jlclyde
Steen,
What you want to transfer over is the code that is in your personel
macro work book. A way to do this is to create a new macro and store
it in your new computers personel macro workbook. This will unhide it
and make it easy to move your code. Now go to your old computer and
open excel. Click Alt + F11. This will open up VBA. Click view/
Project explorer. Find your Personel macro work book. Find the
modules that you want copied. Transfer these modules to a new
workbook. Now put this new work book onto a disc or flash drive or
email it to your self. Then open the file on your new computer and
move all of the modules to your new personel macro workbook. I like
the email Idea.
Jay
D
Dave Peterson
If you're using the same version of excel, I'd let excel help me find where
things are located.
Open excel on the new pc
alt-f11 to get to the VBE
ctrl-g to see the immediate window
type:
?application.startuppath
For me (winXP Home) and xl2003, I see:
?application.startuppath
C:\Documents and Settings\(username)\Application Data\Microsoft\Excel\XLSTART
This is where my personal.xla (and book.xlt and sheet.xlt) are located.
And since personal.* is just a plain old file, I'd copy it from the old pc and
plop it into this folder on the new pc.
=====
And if you're staying with the same version of excel (just for emphasis), you
may want to copy over your *.xlb file--customized toolbar.
I make a small change to my toolbar on the old pc. Close excel and search for
*.xlb and find the one that's dated right now.
Then I copy that file (to a thumbdrive?)
Then off to the new pc.
Make a small change to the toolbar and find its location.
Close excel and plop the thumbdrive toolbar file into this location.
If you're using different versions of excel, don't do this with your *.xlb
file. You'll want to rebuild the toolbar and see all the new things you can
add. (You may want to review your current toolbar just to see if you could
skinny it down a bit, though.)
And...
Saved from a previous post (so there it's kind of redundant at the end):
I have a short list of things to copy/update when we changed pc's at work.
It's not complete, but may help you.
Word/Excel files:
FileName Use
custom.dic personal dictionary
*.acl personal autocorrect list
mssp2_en.exc personal exclusion dictionary
normal.dot default (for new documents) template
*.dot Any other templates you've made
*.xlb personal toolbar
book.xlt defaults for new workbooks
sheet.xlt defaults for new worksheets
personal.xl* personal macros
*.xlt Any other templates you've made
And don't forget any:
Local files (If you don’t store on LAN)
(Settings) Directories and other defaults (Tools|Options stuff)
====
I've found the easiest way to find these files is to use Windows start
button|Search.
Remember to look through hidden folders/files. And if I find multiple files of
the same name, I open excel (say), then make a minor change to that file. Then
search again. Then I can pick out the current version of the file.
That said, if you're upgrading from an older version of office, I wouldn't copy
the toolbar. (I would take good notes to help me rebuild this toolbar (maybe
even fix it up a bit).)
Same with the normal.dot (I'd let MSWord rebuild that--then just copy|paste any
macros into it manually.)
The *.xlt (book.xlt, sheet.xlt), I'd copy over, but then open and resave them
using the newer version.
things are located.
Open excel on the new pc
alt-f11 to get to the VBE
ctrl-g to see the immediate window
type:
?application.startuppath
For me (winXP Home) and xl2003, I see:
?application.startuppath
C:\Documents and Settings\(username)\Application Data\Microsoft\Excel\XLSTART
This is where my personal.xla (and book.xlt and sheet.xlt) are located.
And since personal.* is just a plain old file, I'd copy it from the old pc and
plop it into this folder on the new pc.
=====
And if you're staying with the same version of excel (just for emphasis), you
may want to copy over your *.xlb file--customized toolbar.
I make a small change to my toolbar on the old pc. Close excel and search for
*.xlb and find the one that's dated right now.
Then I copy that file (to a thumbdrive?)
Then off to the new pc.
Make a small change to the toolbar and find its location.
Close excel and plop the thumbdrive toolbar file into this location.
If you're using different versions of excel, don't do this with your *.xlb
file. You'll want to rebuild the toolbar and see all the new things you can
add. (You may want to review your current toolbar just to see if you could
skinny it down a bit, though.)
And...
Saved from a previous post (so there it's kind of redundant at the end):
I have a short list of things to copy/update when we changed pc's at work.
It's not complete, but may help you.
Word/Excel files:
FileName Use
custom.dic personal dictionary
*.acl personal autocorrect list
mssp2_en.exc personal exclusion dictionary
normal.dot default (for new documents) template
*.dot Any other templates you've made
*.xlb personal toolbar
book.xlt defaults for new workbooks
sheet.xlt defaults for new worksheets
personal.xl* personal macros
*.xlt Any other templates you've made
And don't forget any:
Local files (If you don’t store on LAN)
(Settings) Directories and other defaults (Tools|Options stuff)
====
I've found the easiest way to find these files is to use Windows start
button|Search.
Remember to look through hidden folders/files. And if I find multiple files of
the same name, I open excel (say), then make a minor change to that file. Then
search again. Then I can pick out the current version of the file.
That said, if you're upgrading from an older version of office, I wouldn't copy
the toolbar. (I would take good notes to help me rebuild this toolbar (maybe
even fix it up a bit).)
Same with the normal.dot (I'd let MSWord rebuild that--then just copy|paste any
macros into it manually.)
The *.xlt (book.xlt, sheet.xlt), I'd copy over, but then open and resave them
using the newer version.
S
Steen
Thanks to all of you - it's all working again and I am very happy 
And especial thanks to you Dave for you extra information - great info which
is much appriciated and very usefull in my situation
/Steen
And especial thanks to you Dave for you extra information - great info which
is much appriciated and very usefull in my situation
/Steen