|
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! |
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! |
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! |
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! |
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! |
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! |
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! |
unzipping files
Why not document the arguments on your page.
-- Regards, Tom Ogilvy "Ron de Bruin" wrote in message ... 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! |
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! |
unzipping files
Hi Tom
I will add them this week -- Regards Ron de Bruin http://www.rondebruin.nl "Tom Ogilvy" wrote in message ... Why not document the arguments on your page. -- Regards, Tom Ogilvy "Ron de Bruin" wrote in message ... 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! |
unzipping files
Done
http://www.rondebruin.nl/zip.htm http://www.rondebruin.nl/unzip.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Ron de Bruin" wrote in message ... Hi Tom I will add them this week -- Regards Ron de Bruin http://www.rondebruin.nl "Tom Ogilvy" wrote in message ... Why not document the arguments on your page. -- Regards, Tom Ogilvy "Ron de Bruin" wrote in message ... 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! |
| All times are GMT +1. The time now is 03:33 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com