Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
hmm hmm is offline
external usenet poster
 
Posts: 175
Default Drag/drop to open zipped Excel file

A few times a week I get many large zip folders containing .TXT files
(through an FTP server), which I must unzip in order to open in Excel.
Because of the largeness of the folders, I must often delete the unzipped
version after viewing, necessitating re-unzipping the next time.

Rather than go through this cumbersome (and slow) procedure, is there any
way I open the files by draging them from the zip folder directly into Excel?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4,393
Default Drag/drop to open zipped Excel file

Here is the result of an experiment I did:
1) Put a TXT and a XLS file in to a ZIP file
2) Opened the Zip file with WINZIP
3) I already had Excel open, so I can see the Excel window with the WinZip
window on top of it.
4) I dragged the TXT file onto the Excel workspace; and that file opened
5) I repeated this with the XLS file
Does this answer you question?
But: Why not unzip the entire file and then delete the Zip file after each
download?
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"hmm" wrote in message
...
A few times a week I get many large zip folders containing .TXT files
(through an FTP server), which I must unzip in order to open in Excel.
Because of the largeness of the folders, I must often delete the unzipped
version after viewing, necessitating re-unzipping the next time.

Rather than go through this cumbersome (and slow) procedure, is there any
way I open the files by draging them from the zip folder directly into
Excel?



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
How can I further compress a zipped Excel file that is 148MB? Chip Pearson Excel Discussion (Misc queries) 1 July 5th 07 02:00 PM
Drag and Drop in Excel VT Excel Discussion (Misc queries) 2 July 5th 07 01:17 PM
how do i open zipped files searching for discussion New Users to Excel 2 July 16th 06 05:07 AM
Drag and Drop file to open Excel (or MSWord SJB Excel Discussion (Misc queries) 0 January 7th 06 12:32 AM
I can't open an xls.file compressed(zipped)folder in Windows XP? Kadi Excel Discussion (Misc queries) 0 November 16th 05 04:51 PM


All times are GMT +1. The time now is 01:16 AM.

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

About Us

"It's about Microsoft Excel"