Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
RWN
 
Posts: n/a
Default Location of Temp File(s) - If any

Does XL create temp files (as does Word)?
If so, where are they created?
(Word creates them in the same directory as the Document.)

--
Regards;
Rob
------------------------------------------------------------------------


  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
it does. Normally in the regular Windows temp folder

--
Regards
Frank Kabel
Frankfurt, Germany
"RWN" schrieb im Newsbeitrag
...
Does XL create temp files (as does Word)?
If so, where are they created?
(Word creates them in the same directory as the Document.)

--
Regards;
Rob
------------------------------------------------------------------------




  #3   Report Post  
RWN
 
Posts: n/a
Default

Thanks Frank;

So does the rule about saving/opening directly from a floppy *not* apply to Excel?
(I'm trying to resolve a problem for someone)

Any idea as to the naming structure applied to the temp XL files?

--
Regards;
Rob
------------------------------------------------------------------------
"Frank Kabel" wrote in message
...
Hi
it does. Normally in the regular Windows temp folder

--
Regards
Frank Kabel
Frankfurt, Germany
"RWN" schrieb im Newsbeitrag
...
Does XL create temp files (as does Word)?
If so, where are they created?
(Word creates them in the same directory as the Document.)

--
Regards;
Rob
------------------------------------------------------------------------






  #4   Report Post  
Dave Peterson
 
Posts: n/a
Default

That rule applies to excel (as well as all office programs).

It's probably not a bad rule for any program nowadays.

If you open a workbook in excel, you can go look at the files in your Temp
folder.

In fact, look at your temp folder first, so you can notice the changes.



RWN wrote:

Thanks Frank;

So does the rule about saving/opening directly from a floppy *not* apply to Excel?
(I'm trying to resolve a problem for someone)

Any idea as to the naming structure applied to the temp XL files?

--
Regards;
Rob
------------------------------------------------------------------------
"Frank Kabel" wrote in message
...
Hi
it does. Normally in the regular Windows temp folder

--
Regards
Frank Kabel
Frankfurt, Germany
"RWN" schrieb im Newsbeitrag
...
Does XL create temp files (as does Word)?
If so, where are they created?
(Word creates them in the same directory as the Document.)

--
Regards;
Rob
------------------------------------------------------------------------





--

Dave Peterson
  #5   Report Post  
RWN
 
Posts: n/a
Default

Thanks Dave, I found them;
(I was looking in the wrong "Temp" folder <blush).

A colleague is having problems reading a disk and mentioned that he was saving Excel files
directly to it.
I knew (from hard experience-a long time ago) that Word will corrupt a disk in these
circumstances but wasn't sure if Excel would do the same.

--
Regards;
Rob
------------------------------------------------------------------------
"Dave Peterson" wrote in message
...
That rule applies to excel (as well as all office programs).

It's probably not a bad rule for any program nowadays.

If you open a workbook in excel, you can go look at the files in your Temp
folder.

In fact, look at your temp folder first, so you can notice the changes.



RWN wrote:

Thanks Frank;

So does the rule about saving/opening directly from a floppy *not* apply to Excel?
(I'm trying to resolve a problem for someone)

Any idea as to the naming structure applied to the temp XL files?

--
Regards;
Rob
------------------------------------------------------------------------
"Frank Kabel" wrote in message
...
Hi
it does. Normally in the regular Windows temp folder

--
Regards
Frank Kabel
Frankfurt, Germany
"RWN" schrieb im Newsbeitrag
...
Does XL create temp files (as does Word)?
If so, where are they created?
(Word creates them in the same directory as the Document.)

--
Regards;
Rob
------------------------------------------------------------------------





--

Dave Peterson





  #6   Report Post  
Jon Peltier
 
Posts: n/a
Default

Excel will corrupt the file, trash the disk, and melt your motherboard if you work
off a floppy. Don't do it.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

RWN wrote:

Thanks Dave, I found them;
(I was looking in the wrong "Temp" folder <blush).

A colleague is having problems reading a disk and mentioned that he was saving Excel files
directly to it.
I knew (from hard experience-a long time ago) that Word will corrupt a disk in these
circumstances but wasn't sure if Excel would do the same.


  #7   Report Post  
Dana DeLouis
 
Posts: n/a
Default

Here's one of a few articles you may find interesting...

You receive an error message when you access files from a floppy disk in
Excel
http://support.microsoft.com/default...b;en-us;214042


Not useful, but the following will show your UserId Temp Folder..

Debug.Print
CreateObject("Scripting.FileSystemObject").GetSpec ialFolder(2)

C:\DOCUME~1\MyUserId\LOCALS~1\Temp

--
Dana DeLouis
Win XP & Office 2003


"RWN" wrote in message
...
Thanks Dave, I found them;
(I was looking in the wrong "Temp" folder <blush).

A colleague is having problems reading a disk and mentioned that he was
saving Excel files
directly to it.
I knew (from hard experience-a long time ago) that Word will corrupt a
disk in these
circumstances but wasn't sure if Excel would do the same.

--
Regards;
Rob
------------------------------------------------------------------------
"Dave Peterson" wrote in message
...
That rule applies to excel (as well as all office programs).

It's probably not a bad rule for any program nowadays.

If you open a workbook in excel, you can go look at the files in your
Temp
folder.

In fact, look at your temp folder first, so you can notice the changes.



RWN wrote:

Thanks Frank;

So does the rule about saving/opening directly from a floppy *not*
apply to Excel?
(I'm trying to resolve a problem for someone)

Any idea as to the naming structure applied to the temp XL files?

--
Regards;
Rob
------------------------------------------------------------------------
"Frank Kabel" wrote in message
...
Hi
it does. Normally in the regular Windows temp folder

--
Regards
Frank Kabel
Frankfurt, Germany
"RWN" schrieb im Newsbeitrag
...
Does XL create temp files (as does Word)?
If so, where are they created?
(Word creates them in the same directory as the Document.)

--
Regards;
Rob
------------------------------------------------------------------------


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
Problems opening Excel files using DFS links Byron Excel Discussion (Misc queries) 2 January 1st 05 11:31 PM
multiple text files URGENT tasha Excel Discussion (Misc queries) 1 December 19th 04 05:44 PM
importing multiple text files??? tashayu Excel Discussion (Misc queries) 0 December 19th 04 02:43 PM
How to open 123 files with excel Jeff B 813 Excel Discussion (Misc queries) 3 December 8th 04 09:11 PM
Why does Excel saves all my files as temporary files? Arija Excel Discussion (Misc queries) 2 December 7th 04 11:38 PM


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