Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sali
 
Posts: n/a
Default .xls files become scrap objects - .shs files

This same question has been asked in the applications error forum
have gone back 2 months and all files in these folders are now scrap
objects???
using office xp (2002) fully updated as of this morning (Jan, 30, 2006).
User claims that these files were normal and could be opened a couple of
weeks ago. my backups show the files in Nov. as being .shs files.
How do you, if it is possible, change them back.
I have tried the following - none of which works:
change the file extension - not easy to do with .shs - didn't work
drag the scrap object onto a new excel doc - didn't work
tried newer AND older versions of excel - didn't work
screamed at it like a lunatic - laughed at me - so punched the screen - hand
now hurts - still doesn't work
HELP
thanks for in advance for any help.
any additional info needed by you - let me know
thanks
sali

  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default .xls files become scrap objects - .shs files

I can create scrap objects by selecting a range and dragging it to my windows
desktop. (Yeah, I had to play around with excel's window size first.)

After it's on the desktop, if I double click on it, some kind of script runs
(and I get prompted to allow it with all that security stuff). If I allow it to
run, I get a little view window and the scrap opens up in excel (or what ever
application I was in when I created it). (I'm using winXP home and xl2003.)

But these are not normal run of the mill files. You actually have to do
something to create them.

I could rename the scrap.shs file by shelling to DOS:

Windows start button|Run
CMD (win nt/xp)
command (win98)

And traversing to the folder that contains the scrap.

Then use the old DOS REName command:

ren scrap.shs scrap.xls

But don't get your hopes up. When I tried to open the renamed file, excel said
it wasn't the correct format.

======
I think I'd copy one of the .shs files to a different computer. Try double
clicking on it there. If it opens correctly, then maybe the original user
disabled the scripting program associated with .shs.

If that test works, you may want to post to another newsgroup (*scripting*???)
to see if they can help.

===
I would ask the user how he/she created those files--maybe even watch a bit.


Sali wrote:

This same question has been asked in the applications error forum
have gone back 2 months and all files in these folders are now scrap
objects???
using office xp (2002) fully updated as of this morning (Jan, 30, 2006).
User claims that these files were normal and could be opened a couple of
weeks ago. my backups show the files in Nov. as being .shs files.
How do you, if it is possible, change them back.
I have tried the following - none of which works:
change the file extension - not easy to do with .shs - didn't work
drag the scrap object onto a new excel doc - didn't work
tried newer AND older versions of excel - didn't work
screamed at it like a lunatic - laughed at me - so punched the screen - hand
now hurts - still doesn't work
HELP
thanks for in advance for any help.
any additional info needed by you - let me know
thanks
sali


--

Dave Peterson
Reply
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
Can I change open favorites screen to view .xls files not url/lnk Daniel Setting up and Configuration of Excel 1 November 17th 05 12:36 AM
Excel lost association with .xls files. Must use Excel open comm Neil Excel Discussion (Misc queries) 3 November 9th 05 07:16 PM
can't open .XLS files using version 7.0 Silvermarsh Excel Discussion (Misc queries) 1 November 6th 05 06:02 PM
Excel 2003 .XLS files El Maestro Excel Discussion (Misc queries) 0 May 3rd 05 10:53 PM
Cannot access read-only documents. tomgillane Excel Discussion (Misc queries) 14 February 7th 05 10:53 PM


All times are GMT +1. The time now is 03:33 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"