| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
unzipping files
Thanks to Ron's code http://www.rondebruin.nl/zip.htm
i was able to unzip the files. However, I need little modification and I am new to VB so i am not quiet sure how to do so. here's part of my code: FileNameZip = "N:\Customer Counts\CEN.zip" FolderName = "N:\Customer Counts\Tag" FolderName = "N:\Customer Counts\Tag" ShellStr = PathWinZip & "Winzip32 -min -e" _ & " " & Chr(34) & FileNameZip & Chr(34) _ & " " & Chr(34) & FolderName & Chr(34) ShellAndWait ShellStr, vbHide although it is extracting it to " Tag" folder, there are subfolders listed so actually, it is extracting it to: N:\Customer Counts\Tag\dwstage\homedirs\reporting\scripts\data _spool how would I delete the other folders? i want the files to extract to the "Tag" folder. Also, if the file already exist, I want it to overwrite it automatically. Thank you! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
unzipping files
These would both be a function of the command line arguments you furnish to
Winzip. Just identify what the correct arguments are and put them in the command string. -- Regards, Tom Ogilvy "GEORGIA" wrote in message ... Thanks to Ron's code http://www.rondebruin.nl/zip.htm i was able to unzip the files. However, I need little modification and I am new to VB so i am not quiet sure how to do so. here's part of my code: FileNameZip = "N:\Customer Counts\CEN.zip" FolderName = "N:\Customer Counts\Tag" FolderName = "N:\Customer Counts\Tag" ShellStr = PathWinZip & "Winzip32 -min -e" _ & " " & Chr(34) & FileNameZip & Chr(34) _ & " " & Chr(34) & FolderName & Chr(34) ShellAndWait ShellStr, vbHide although it is extracting it to " Tag" folder, there are subfolders listed so actually, it is extracting it to: N:\Customer Counts\Tag\dwstage\homedirs\reporting\scripts\data _spool how would I delete the other folders? i want the files to extract to the "Tag" folder. Also, if the file already exist, I want it to overwrite it automatically. Thank you! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
unzipping files
sorry my ignorance....
how would i go about doing that? "Tom Ogilvy" wrote: These would both be a function of the command line arguments you furnish to Winzip. Just identify what the correct arguments are and put them in the command string. -- Regards, Tom Ogilvy "GEORGIA" wrote in message ... Thanks to Ron's code http://www.rondebruin.nl/zip.htm i was able to unzip the files. However, I need little modification and I am new to VB so i am not quiet sure how to do so. here's part of my code: FileNameZip = "N:\Customer Counts\CEN.zip" FolderName = "N:\Customer Counts\Tag" FolderName = "N:\Customer Counts\Tag" ShellStr = PathWinZip & "Winzip32 -min -e" _ & " " & Chr(34) & FileNameZip & Chr(34) _ & " " & Chr(34) & FolderName & Chr(34) ShellAndWait ShellStr, vbHide although it is extracting it to " Tag" folder, there are subfolders listed so actually, it is extracting it to: N:\Customer Counts\Tag\dwstage\homedirs\reporting\scripts\data _spool how would I delete the other folders? i want the files to extract to the "Tag" folder. Also, if the file already exist, I want it to overwrite it automatically. Thank you! |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
unzipping files
The information page on the command line addon
http://www.winzip.com/prodpagecl.htm says: Fully Documented All commands and options are documented in a Windows help file for ease of reference. I assume if you are using the addon, you have the help file. -- Regards, Tom Ogilvy "GEORGIA" wrote in message ... sorry my ignorance.... how would i go about doing that? "Tom Ogilvy" wrote: These would both be a function of the command line arguments you furnish to Winzip. Just identify what the correct arguments are and put them in the command string. -- Regards, Tom Ogilvy "GEORGIA" wrote in message ... Thanks to Ron's code http://www.rondebruin.nl/zip.htm i was able to unzip the files. However, I need little modification and I am new to VB so i am not quiet sure how to do so. here's part of my code: FileNameZip = "N:\Customer Counts\CEN.zip" FolderName = "N:\Customer Counts\Tag" FolderName = "N:\Customer Counts\Tag" ShellStr = PathWinZip & "Winzip32 -min -e" _ & " " & Chr(34) & FileNameZip & Chr(34) _ & " " & Chr(34) & FolderName & Chr(34) ShellAndWait ShellStr, vbHide although it is extracting it to " Tag" folder, there are subfolders listed so actually, it is extracting it to: N:\Customer Counts\Tag\dwstage\homedirs\reporting\scripts\data _spool how would I delete the other folders? i want the files to extract to the "Tag" folder. Also, if the file already exist, I want it to overwrite it automatically. Thank you! |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
unzipping files
ShellStr = PathWinZip & "Winzip32 -min -e -o" _
& " " & Chr(34) & FileNameZip & Chr(34) _ & " " & Chr(34) & FolderName & Chr(34) should overwrite. As to the path, I believe you would have to build the archive without using the save path option from what I could see. -- Regards, Tom Ogilvy "GEORGIA" wrote in message ... sorry my ignorance.... how would i go about doing that? "Tom Ogilvy" wrote: These would both be a function of the command line arguments you furnish to Winzip. Just identify what the correct arguments are and put them in the command string. -- Regards, Tom Ogilvy "GEORGIA" wrote in message ... Thanks to Ron's code http://www.rondebruin.nl/zip.htm i was able to unzip the files. However, I need little modification and I am new to VB so i am not quiet sure how to do so. here's part of my code: FileNameZip = "N:\Customer Counts\CEN.zip" FolderName = "N:\Customer Counts\Tag" FolderName = "N:\Customer Counts\Tag" ShellStr = PathWinZip & "Winzip32 -min -e" _ & " " & Chr(34) & FileNameZip & Chr(34) _ & " " & Chr(34) & FolderName & Chr(34) ShellAndWait ShellStr, vbHide although it is extracting it to " Tag" folder, there are subfolders listed so actually, it is extracting it to: N:\Customer Counts\Tag\dwstage\homedirs\reporting\scripts\data _spool how would I delete the other folders? i want the files to extract to the "Tag" folder. Also, if the file already exist, I want it to overwrite it automatically. Thank you! |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
unzipping files
Actually, while I haven't tested it. I would expect the default to be to
extract without using the path since there is a -d option to tell it to extract using the path - but since you say it is using the path, that may not be true. Also, the help is for the commandline addon - I assume the arguments would be the same for winzip32 but no guarantee. -- Regards, Tom Ogilvy "Tom Ogilvy" wrote in message ... ShellStr = PathWinZip & "Winzip32 -min -e -o" _ & " " & Chr(34) & FileNameZip & Chr(34) _ & " " & Chr(34) & FolderName & Chr(34) should overwrite. As to the path, I believe you would have to build the archive without using the save path option from what I could see. -- Regards, Tom Ogilvy "GEORGIA" wrote in message ... sorry my ignorance.... how would i go about doing that? "Tom Ogilvy" wrote: These would both be a function of the command line arguments you furnish to Winzip. Just identify what the correct arguments are and put them in the command string. -- Regards, Tom Ogilvy "GEORGIA" wrote in message ... Thanks to Ron's code http://www.rondebruin.nl/zip.htm i was able to unzip the files. However, I need little modification and I am new to VB so i am not quiet sure how to do so. here's part of my code: FileNameZip = "N:\Customer Counts\CEN.zip" FolderName = "N:\Customer Counts\Tag" FolderName = "N:\Customer Counts\Tag" ShellStr = PathWinZip & "Winzip32 -min -e" _ & " " & Chr(34) & FileNameZip & Chr(34) _ & " " & Chr(34) & FolderName & Chr(34) ShellAndWait ShellStr, vbHide although it is extracting it to " Tag" folder, there are subfolders listed so actually, it is extracting it to: N:\Customer Counts\Tag\dwstage\homedirs\reporting\scripts\data _spool how would I delete the other folders? i want the files to extract to the "Tag" folder. Also, if the file already exist, I want it to overwrite it automatically. Thank you! |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
unzipping files
Hi
From the Winzip Help -o and -j stands for "overwrite existing files without prompting" and "Junk pathnames", Unless -j is specified,folder information is used -- Regards Ron de Bruin http://www.rondebruin.nl "Tom Ogilvy" wrote in message ... Actually, while I haven't tested it. I would expect the default to be to extract without using the path since there is a -d option to tell it to extract using the path - but since you say it is using the path, that may not be true. Also, the help is for the commandline addon - I assume the arguments would be the same for winzip32 but no guarantee. -- Regards, Tom Ogilvy "Tom Ogilvy" wrote in message ... ShellStr = PathWinZip & "Winzip32 -min -e -o" _ & " " & Chr(34) & FileNameZip & Chr(34) _ & " " & Chr(34) & FolderName & Chr(34) should overwrite. As to the path, I believe you would have to build the archive without using the save path option from what I could see. -- Regards, Tom Ogilvy "GEORGIA" wrote in message ... sorry my ignorance.... how would i go about doing that? "Tom Ogilvy" wrote: These would both be a function of the command line arguments you furnish to Winzip. Just identify what the correct arguments are and put them in the command string. -- Regards, Tom Ogilvy "GEORGIA" wrote in message ... Thanks to Ron's code http://www.rondebruin.nl/zip.htm i was able to unzip the files. However, I need little modification and I am new to VB so i am not quiet sure how to do so. here's part of my code: FileNameZip = "N:\Customer Counts\CEN.zip" FolderName = "N:\Customer Counts\Tag" FolderName = "N:\Customer Counts\Tag" ShellStr = PathWinZip & "Winzip32 -min -e" _ & " " & Chr(34) & FileNameZip & Chr(34) _ & " " & Chr(34) & FolderName & Chr(34) ShellAndWait ShellStr, vbHide although it is extracting it to " Tag" folder, there are subfolders listed so actually, it is extracting it to: N:\Customer Counts\Tag\dwstage\homedirs\reporting\scripts\data _spool how would I delete the other folders? i want the files to extract to the "Tag" folder. Also, if the file already exist, I want it to overwrite it automatically. Thank you! |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
unzipping files
To the OP:
I was using a different help file and assuming the arguments would be the same - apparently not: http://www.memecode.com/docs/winzip.html -- Regards, Tom Ogilvy "Tom Ogilvy" wrote in message ... Actually, while I haven't tested it. I would expect the default to be to extract without using the path since there is a -d option to tell it to extract using the path - but since you say it is using the path, that may not be true. Also, the help is for the commandline addon - I assume the arguments would be the same for winzip32 but no guarantee. -- Regards, Tom Ogilvy "Tom Ogilvy" wrote in message ... ShellStr = PathWinZip & "Winzip32 -min -e -o" _ & " " & Chr(34) & FileNameZip & Chr(34) _ & " " & Chr(34) & FolderName & Chr(34) should overwrite. As to the path, I believe you would have to build the archive without using the save path option from what I could see. -- Regards, Tom Ogilvy "GEORGIA" wrote in message ... sorry my ignorance.... how would i go about doing that? "Tom Ogilvy" wrote: These would both be a function of the command line arguments you furnish to Winzip. Just identify what the correct arguments are and put them in the command string. -- Regards, Tom Ogilvy "GEORGIA" wrote in message ... Thanks to Ron's code http://www.rondebruin.nl/zip.htm i was able to unzip the files. However, I need little modification and I am new to VB so i am not quiet sure how to do so. here's part of my code: FileNameZip = "N:\Customer Counts\CEN.zip" FolderName = "N:\Customer Counts\Tag" FolderName = "N:\Customer Counts\Tag" ShellStr = PathWinZip & "Winzip32 -min -e" _ & " " & Chr(34) & FileNameZip & Chr(34) _ & " " & Chr(34) & FolderName & Chr(34) ShellAndWait ShellStr, vbHide although it is extracting it to " Tag" folder, there are subfolders listed so actually, it is extracting it to: N:\Customer Counts\Tag\dwstage\homedirs\reporting\scripts\data _spool how would I delete the other folders? i want the files to extract to the "Tag" folder. Also, if the file already exist, I want it to overwrite it automatically. Thank you! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Navigating to Excel files over network slow, but not Word files | Excel Discussion (Misc queries) | |||
| Excel 2007 tmp files filling up drive with XLSM files | Excel Worksheet Functions | |||
| How to change default Open/Files of Type to "Microsoft Excel Files | Excel Discussion (Misc queries) | |||
| Drive Erased, got Files back but only excel files scrambled, help. | Excel Discussion (Misc queries) | |||
| unzipping a file | Excel Programming | |||
Hybrid Mode
