View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default Excel worked OK on XP

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