Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Where is Personal.xls workbook?
I want to transfer my personal.xls workbook to another computer but I can't
find it anywhere on my pc. I thought it was located in the XLSTART folder. I changed my folder options to view hidden files or folders and it still isn't showing up in that folder. I have 3 macro's recorded in it, so it has to show up somewhere. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Where is Personal.xls workbook?
Go to Start--Search--and search all your drives for the file. Make sure
you have the "search hidden files" option selected. "Chris" wrote: I want to transfer my personal.xls workbook to another computer but I can't find it anywhere on my pc. I thought it was located in the XLSTART folder. I changed my folder options to view hidden files or folders and it still isn't showing up in that folder. I have 3 macro's recorded in it, so it has to show up somewhere. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Where is Personal.xls workbook?
First, be careful.
If that other pc already has a personal.xls workbook, then only one of them can be open in excel at the same time. (If you're the user on both PCs, then you'll know what to do--but you could be destroying someone's workbook if you do this.) Second, when I'm not sure, I'll let excel tell me. Open Excel Personal.xls should open, right? hit alt-f11 to get to the VBE hit ctrl-g to see the immediate window type this and hit enter: ?workbooks("Personal.xls").fullname or ?workbooks("Personal.xls").Path Make a note of that location and then off to the other pc. I'd let that pc tell me where to put personal.xls, too. (Assuming that there isn't already one there!) Open excel hit alt-f11 to get to the VBE hit ctrl-g to see the immediate window type this and hit enter: ?application.startuppath for me (xl2003, winXP Home), I get: C:\Documents and Settings\(username)\Application Data\Microsoft\Excel\XLSTART Chris wrote: I want to transfer my personal.xls workbook to another computer but I can't find it anywhere on my pc. I thought it was located in the XLSTART folder. I changed my folder options to view hidden files or folders and it still isn't showing up in that folder. I have 3 macro's recorded in it, so it has to show up somewhere. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protect Workbook vs Worksheet?? | Excel Worksheet Functions | |||
Auto updating a workbook with data from another workbook | Excel Discussion (Misc queries) | |||
Personal macro workbook and personal.xls | Excel Discussion (Misc queries) | |||
How to hyperlink from a workbook to sheets in another workbook? | Excel Worksheet Functions | |||
personal.xls workbook | Excel Discussion (Misc queries) |