| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to open a zip file and extract its contents in a macro?
Hi
I need to save space in my hard disk so i have to zip some files, but i need them for consulting values and make some reports, i need to run a macro that opens the zip file, extract the workbook copy some values from it and then close it without making changes, and close the zip file. The zip file and the workbook have the same name. This operation is done by hand 5 times everyday so you'll understand my need. Please any help is needed |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Open Excel file from VB and open MACRO | Excel Discussion (Misc queries) | |||
| 2007 Macro to Open File, Delete Contents, Save New File | Excel Discussion (Misc queries) | |||
| How to save file in a macro taking new name from cell contents? | Excel Discussion (Misc queries) | |||
| Macro to extract clip-art file? | Excel Discussion (Misc queries) | |||
| Automate open file, update links, run macro, close and save file | Excel Programming | |||
Threaded Mode
