LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.programming
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



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I see last spreadsheets worked on when opening Excel MikeO Setting up and Configuration of Excel 1 June 24th 09 03:51 PM
Excel won't start. Previously worked fine Don T. Excel Discussion (Misc queries) 6 December 11th 06 12:54 AM
calculate years worked by 3% * salary in excel laurentium3 Excel Worksheet Functions 2 January 18th 06 12:39 AM
Excel needs hh:mm where hh>24 for hours worked per week pmba Excel Worksheet Functions 2 May 16th 05 09:03 PM
how do i calculate hours worked in excel? Skip4t4 Excel Worksheet Functions 9 March 5th 05 07:15 PM


All times are GMT +1. The time now is 05:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"