RoryA
MrExcel MVP, Moderator
- Joined
- May 2, 2008
- Messages
- 43,136
- Office Version
- 365
- Platform
- Windows
- MacOS
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Who uses Personal.xls?
- Thread starter Colin Legg
- Start date
Excel Facts
Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.
SuperFerret
Well-known Member
- Joined
- Mar 2, 2009
- Messages
- 515
VoG
Legend
- Joined
- Jun 19, 2002
- Messages
- 63,650
Actually I do now since I had to test for this thread http://www.mrexcel.com/forum/showthread.php?t=483113
How do I change my vote
and does this qualify for another G&T 
How do I change my vote
and does this qualify for another G&T 
Cindy Ellis
MrExcel MVP
- Joined
- Jun 9, 2006
- Messages
- 1,802
I use personal.xls (.xlsb now) to store macros that don't belong to a single workbook...pretty much a repository. (Used to be for custom toolbars...oh well).
Also, a couple of times a year I need to summarize data from 1500 to 5000 machine data files as a set, with a fair amount of data in each (85 columns by ~2000 rows). It's easiest for me to have my tried and true macros handy, rather than lost somewhere in a workbook that I've moved to some other folder, renamed, etc. It also ensures that when I find something that needs to change, it's only in one place. I don't have to go digging to figure out which version of which file had the right code in it.
I've created one or two add-ins for those macros that turned out to be useful for other folks. I haven't had to update a distributed add-in yet...that's for next month. I'll have to check out the links in the earlier posts.
Also, a couple of times a year I need to summarize data from 1500 to 5000 machine data files as a set, with a fair amount of data in each (85 columns by ~2000 rows). It's easiest for me to have my tried and true macros handy, rather than lost somewhere in a workbook that I've moved to some other folder, renamed, etc. It also ensures that when I find something that needs to change, it's only in one place. I don't have to go digging to figure out which version of which file had the right code in it.
I've created one or two add-ins for those macros that turned out to be useful for other folks. I haven't had to update a distributed add-in yet...that's for next month. I'll have to check out the links in the earlier posts.
xenou
MrExcel MVP
- Joined
- Mar 2, 2007
- Messages
- 16,836
- Office Version
- 2019
- Platform
- Windows
I created a Personal.xls for myself long ago, but I renamed it. So I guess technically I do not use Personal.xls ...
Keyboard shortcuts are in there, some menu items, various routines for dealing with imported data - stuff I do daily/weekly - sorting, stripping, cleaning. Otherwise, I tend to create macro workbooks for specific tasks that may come up, but less frequently. One button on my toolbar just for getting rid of wrapped text when exporting from Access (Joe4, saw you have one for Access too). Coffee Mug. I don't remember the piggy bank? How did I miss it. Can't bring myself to put a smiley face up there ...
Keyboard shortcuts are in there, some menu items, various routines for dealing with imported data - stuff I do daily/weekly - sorting, stripping, cleaning. Otherwise, I tend to create macro workbooks for specific tasks that may come up, but less frequently. One button on my toolbar just for getting rid of wrapped text when exporting from Access (Joe4, saw you have one for Access too). Coffee Mug. I don't remember the piggy bank? How did I miss it. Can't bring myself to put a smiley face up there ...
Last edited:
WaterGypsy
Well-known Member
- Joined
- Jan 15, 2010
- Messages
- 700
I've got some personal add-ins and use personal.xls too. A few handy basic routines - a standard re-format of data from a database (format the headers, left align text, whatever), set up footers & headers how I like them. There must be over a dozen. All instantly available via familiar CTRL-SHIFT-shortcut keys. A good boost to productivity - not that I need that. Things happen quickly!
Domski
Well-known Member
- Joined
- Jan 18, 2005
- Messages
- 7,292
A few of my most used ones are for formatting and summarising standard SAP reports how I like them. I save myself hours every week using these little beasties.
I get all lost when I'm at someone else's PC frantically pressing Ctrl+Shift+? and nothing happens!!!
Dom
I get all lost when I'm at someone else's PC frantically pressing Ctrl+Shift+? and nothing happens!!!
Dom
SydneyGeek
MrExcel MVP
- Joined
- Aug 5, 2003
- Messages
- 12,251
I never really got in the habit of using Personal.xls -- probably because I move around so much it'd drive me crazy.
I tend to push useful stuff into a workbook that I use as a code library, and use that instead. Also, if I need to process / update multiple workbooks I will write code in one master and update all workbooks from there. The code still gets to live in one place, it's just more portable.
Denis
I tend to push useful stuff into a workbook that I use as a code library, and use that instead. Also, if I need to process / update multiple workbooks I will write code in one master and update all workbooks from there. The code still gets to live in one place, it's just more portable.
Denis
Smitty
Legend
- Joined
- May 15, 2003
- Messages
- 29,536
I use it, but more along the lines of why Dom does. I have a bunch of formatting code to make report generation easier. I also keep a few code snippets handy for more common board questions (like boilerplate change event code). The rest I keep categorized in a file library of sorts (which I need to consolidate one of these years...
