| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find Personal.xls
Excel & Win XP
I'm stumped. I just reformatted & reinstalled everything. I had all my files backed up including Personal.xls. I know there are 2 XLStart folders and I need to find where Excel stores Personal.xls so that I can copy my backed-up Personal.xls into that folder Simple task. Not I do Tools - Macro - Record New Macro. I select to put my recorded macro in Personal.xls. I type "hello" in A1 and stop the recorder. Windows - Unhide shows me that I now have a hidden Personal.xls file. Good. I unhide Personal.xls and save it as an unhidden file. With Personal.xls active (on the screen) I click File - Save As. The Save As dialog box shows me that Personal.xls is in the XLStart folder. Good. I click the down arrow in the box that shows XLStart and the whole path appears. Good. I go into Explorer and look for that path. Simple. There is no such path. Period. I lose some hair searching for that path. It's not there. I do a search in the whole hardrive for Personal.xls. It's not there. A little light comes on in my head - Hidden files & folders. I go into My Computer - Tools - Folder Options - View tab. I select to view hidden files and folders. Back to Explorer. The path is there. Personal.xls is there. All is well in the world again. Not quite. In Explorer, I do a search of the whole hardrive (I have only one such drive) for Personal.xls. Personal.xls is not found. I click on View - Refresh. It's still not there in the search. I go into Explorer and follow the path to Personal.xls and look at the file attributes. It is not hidden. I solved my problem of where Personal.xls is stored so I made progress. BTW, the search always finds BackupPersonal.xls and Jim'sPersonal.xls. The first is my Personal.xls copied under that name and put into My Documents (for ease of backup) automatically whenever Personal.xls is saved. The second is a friend's Personal.xls. My question: Why doesn't the search of the hardrive in Explorer find Personal.xls, given that it is an unhidden file? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Find Personal.xls
Otto,
Look at the advanced options on the search and see if hidden files is checked. -- HTH ------- Bob Phillips ... looking out across Poole Harbour to the Purbecks "Otto Moehrbach" wrote in message ... Excel & Win XP I'm stumped. I just reformatted & reinstalled everything. I had all my files backed up including Personal.xls. I know there are 2 XLStart folders and I need to find where Excel stores Personal.xls so that I can copy my backed-up Personal.xls into that folder Simple task. Not I do Tools - Macro - Record New Macro. I select to put my recorded macro in Personal.xls. I type "hello" in A1 and stop the recorder. Windows - Unhide shows me that I now have a hidden Personal.xls file. Good. I unhide Personal.xls and save it as an unhidden file. With Personal.xls active (on the screen) I click File - Save As. The Save As dialog box shows me that Personal.xls is in the XLStart folder. Good. I click the down arrow in the box that shows XLStart and the whole path appears. Good. I go into Explorer and look for that path. Simple. There is no such path. Period. I lose some hair searching for that path. It's not there. I do a search in the whole hardrive for Personal.xls. It's not there. A little light comes on in my head - Hidden files & folders. I go into My Computer - Tools - Folder Options - View tab. I select to view hidden files and folders. Back to Explorer. The path is there. Personal.xls is there. All is well in the world again. Not quite. In Explorer, I do a search of the whole hardrive (I have only one such drive) for Personal.xls. Personal.xls is not found. I click on View - Refresh. It's still not there in the search. I go into Explorer and follow the path to Personal.xls and look at the file attributes. It is not hidden. I solved my problem of where Personal.xls is stored so I made progress. BTW, the search always finds BackupPersonal.xls and Jim'sPersonal.xls. The first is my Personal.xls copied under that name and put into My Documents (for ease of backup) automatically whenever Personal.xls is saved. The second is a friend's Personal.xls. My question: Why doesn't the search of the hardrive in Explorer find Personal.xls, given that it is an unhidden file? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Find Personal.xls
Bob
Thanks for your response. That did the trick. Otto "Bob Phillips" wrote in message ... Otto, Look at the advanced options on the search and see if hidden files is checked. -- HTH ------- Bob Phillips ... looking out across Poole Harbour to the Purbecks "Otto Moehrbach" wrote in message ... Excel & Win XP I'm stumped. I just reformatted & reinstalled everything. I had all my files backed up including Personal.xls. I know there are 2 XLStart folders and I need to find where Excel stores Personal.xls so that I can copy my backed-up Personal.xls into that folder Simple task. Not I do Tools - Macro - Record New Macro. I select to put my recorded macro in Personal.xls. I type "hello" in A1 and stop the recorder. Windows - Unhide shows me that I now have a hidden Personal.xls file. Good. I unhide Personal.xls and save it as an unhidden file. With Personal.xls active (on the screen) I click File - Save As. The Save As dialog box shows me that Personal.xls is in the XLStart folder. Good. I click the down arrow in the box that shows XLStart and the whole path appears. Good. I go into Explorer and look for that path. Simple. There is no such path. Period. I lose some hair searching for that path. It's not there. I do a search in the whole hardrive for Personal.xls. It's not there. A little light comes on in my head - Hidden files & folders. I go into My Computer - Tools - Folder Options - View tab. I select to view hidden files and folders. Back to Explorer. The path is there. Personal.xls is there. All is well in the world again. Not quite. In Explorer, I do a search of the whole hardrive (I have only one such drive) for Personal.xls. Personal.xls is not found. I click on View - Refresh. It's still not there in the search. I go into Explorer and follow the path to Personal.xls and look at the file attributes. It is not hidden. I solved my problem of where Personal.xls is stored so I made progress. BTW, the search always finds BackupPersonal.xls and Jim'sPersonal.xls. The first is my Personal.xls copied under that name and put into My Documents (for ease of backup) automatically whenever Personal.xls is saved. The second is a friend's Personal.xls. My question: Why doesn't the search of the hardrive in Explorer find Personal.xls, given that it is an unhidden file? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Find Personal.xls
Thanks Bob. That found it. Otto
"Bob Phillips" wrote in message ... Otto, Look at the advanced options on the search and see if hidden files is checked. -- HTH ------- Bob Phillips ... looking out across Poole Harbour to the Purbecks "Otto Moehrbach" wrote in message ... Excel & Win XP I'm stumped. I just reformatted & reinstalled everything. I had all my files backed up including Personal.xls. I know there are 2 XLStart folders and I need to find where Excel stores Personal.xls so that I can copy my backed-up Personal.xls into that folder Simple task. Not I do Tools - Macro - Record New Macro. I select to put my recorded macro in Personal.xls. I type "hello" in A1 and stop the recorder. Windows - Unhide shows me that I now have a hidden Personal.xls file. Good. I unhide Personal.xls and save it as an unhidden file. With Personal.xls active (on the screen) I click File - Save As. The Save As dialog box shows me that Personal.xls is in the XLStart folder. Good. I click the down arrow in the box that shows XLStart and the whole path appears. Good. I go into Explorer and look for that path. Simple. There is no such path. Period. I lose some hair searching for that path. It's not there. I do a search in the whole hardrive for Personal.xls. It's not there. A little light comes on in my head - Hidden files & folders. I go into My Computer - Tools - Folder Options - View tab. I select to view hidden files and folders. Back to Explorer. The path is there. Personal.xls is there. All is well in the world again. Not quite. In Explorer, I do a search of the whole hardrive (I have only one such drive) for Personal.xls. Personal.xls is not found. I click on View - Refresh. It's still not there in the search. I go into Explorer and follow the path to Personal.xls and look at the file attributes. It is not hidden. I solved my problem of where Personal.xls is stored so I made progress. BTW, the search always finds BackupPersonal.xls and Jim'sPersonal.xls. The first is my Personal.xls copied under that name and put into My Documents (for ease of backup) automatically whenever Personal.xls is saved. The second is a friend's Personal.xls. My question: Why doesn't the search of the hardrive in Explorer find Personal.xls, given that it is an unhidden file? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Personal.xls cannot find | Excel Discussion (Misc queries) | |||
| Upgraded to office 2003 now cannot find personal.xls | Excel Discussion (Misc queries) | |||
| Personal macro workbook and personal.xls | Excel Discussion (Misc queries) | |||
| WHERE TO FIND PERSONAL MACROWORKBOOK | Excel Discussion (Misc queries) | |||
![Otto Moehrbach[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
