Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I further compress a zipped Excel file that is 148MB? | Excel Discussion (Misc queries) | |||
Drag and Drop in Excel | Excel Discussion (Misc queries) | |||
how do i open zipped files | New Users to Excel | |||
Drag and Drop file to open Excel (or MSWord | Excel Discussion (Misc queries) | |||
I can't open an xls.file compressed(zipped)folder in Windows XP? | Excel Discussion (Misc queries) |