Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
What happens if you run the following, IOW does it error when you try to
save to the default startup folder Sub testSartUpFolder() Dim sStartFldr As String, sFile As String Dim wb As Workbook sStartFldr = Application.StartupPath If Right$(sStartFldr, 1) < "\" Then sStartFldr = sStartFldr & "\" End If Debug.Print sStartFldr sFile = sStartFldr & "tempFile.xls" '' uncomment to delete unwanted file ' Kill sFile ' Exit Sub Set wb = Workbooks.Add wb.Worksheets(1).Range("a1") = "temp file" wb.SaveAs sFile wb.Close End Sub If the above works fine it's not a file permissions issue Delete the temporary file (assuming it was saved) Regards, Peter T "William" wrote in message ... Loaded Excel 2000 on to my Vista laptop. I now cannot save my PERSONAL.xls file created with Windows XP. On Save, a dialog box opens and states the following: "Your changes could not be saved to "PERSONAL.XLS, but were saved to a temporary document named 0C5190000. Close the existing document, then open the temporary document and save it under a new name." I cannot find the temp document refered to. I've searched everywhere. Windows says it does not exist. I have deleted PERSONAL from xlstart. It says that the folder is now empty. Still every time I open Excel 0c5190000 loads. I can unhide it from Excel and I can edit it, but I cannot rename it nor can I delete it. I have also looked at windows startup, and there is nothing there. Unfortunately I have tried to save the file more than once and now I have 5 or 6 of these alpha numeric files loading. They have copied the macros that I have stored and inserted the alpha numeric file name into macros. It's a mess, and I can't get rid of them. Please Help! William S |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I see last spreadsheets worked on when opening Excel | Setting up and Configuration of Excel | |||
Excel won't start. Previously worked fine | Excel Discussion (Misc queries) | |||
calculate years worked by 3% * salary in excel | Excel Worksheet Functions | |||
Excel needs hh:mm where hh>24 for hours worked per week | Excel Worksheet Functions | |||
how do i calculate hours worked in excel? | Excel Worksheet Functions |