Really, it doesn't matter what folder you put it in, as long as excel is CONFIGURED to open the files in that folder.
Find out what folder Excel has in the setting "open all files in this folder:" Then put Personal.xlsb in that folder. I have mine on a shared network folder so that it is available at whichever computer I'm working on. Paul ----------------------------------------- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley ----------------------------------------- ________________________________ From: LOtto <lscho...@gmail.com> To: excel-macros@googlegroups.com Sent: Tue, June 19, 2012 1:22:02 PM Subject: $$Excel-Macros$$ Upgraded to windows 7 - question on personal.xlsb workbook We have users in my area that are being upgraded from XP to Windows 7 with Office 2007 software. I want to take the macros written for that user, and place the workbook (personal.xlsb) in the folder where they will start automatically like the old system did. I tried putting it in the following location, but no luck getting it to open. C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE12\ - then both xlstart and startup Is there another file, or location to solve this? Thanks in advance - Lori -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com