Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto Search Archive files
Is this possible, please:
Use VBA to automate the search for a specific file within an archive file (eg cab, zip etc), and then list the full path of that archive? I have a registered copy of Winzip 9.0 SR-1 and also the Command Line Support Add-On. I can see a manual way, but I really need to automate this to check all archive files on a drive (inc subfolders) if at all possible. Regards. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto Search Archive files
Suggest using Ron's google addin instead
http://www.rondebruin.nl/ -- Don Guillett SalesAid Software "Stuart" wrote in message ... Is this possible, please: Use VBA to automate the search for a specific file within an archive file (eg cab, zip etc), and then list the full path of that archive? I have a registered copy of Winzip 9.0 SR-1 and also the Command Line Support Add-On. I can see a manual way, but I really need to automate this to check all archive files on a drive (inc subfolders) if at all possible. Regards. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto Search Archive files
Many thanks ....it's already installed and oft used.
Are you saying that I can point it to my drive "F:" and set it to search the drive for every '.cab' file (or any other "archive" file), and that I can also set it to look for a file (say abc.txt) within each of those cab files? Regards. "Don Guillett" wrote in message ... Suggest using Ron's google addin instead http://www.rondebruin.nl/ -- Don Guillett SalesAid Software "Stuart" wrote in message ... Is this possible, please: Use VBA to automate the search for a specific file within an archive file (eg cab, zip etc), and then list the full path of that archive? I have a registered copy of Winzip 9.0 SR-1 and also the Command Line Support Add-On. I can see a manual way, but I really need to automate this to check all archive files on a drive (inc subfolders) if at all possible. Regards. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto Search Archive files
Stuart,
Well, at least you can learn a little more here... (just don't ask me any questions) <g http://msdn.microsoft.com/library/de...ml/w9p00a8.asp Extracting Files from Cabinets http://support.microsoft.com/default...-us;132913#toc How to use Extract.exe to copy files from the cabinet files http://support.microsoft.com/default...b;en-us;163811 OFF97: How to Use the CABFILE Viewer Utility Regards, Jim Cone San Francisco, USA "Stuart" wrote in message ... Is this possible, please: Use VBA to automate the search for a specific file within an archive file (eg cab, zip etc), and then list the full path of that archive? I have a registered copy of Winzip 9.0 SR-1 and also the Command Line Support Add-On. I can see a manual way, but I really need to automate this to check all archive files on a drive (inc subfolders) if at all possible. Regards. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moving Files into an archive | Excel Discussion (Misc queries) | |||
Archive Data with Excel files | Excel Discussion (Misc queries) | |||
Auto Archive LIne Items in Excel Worsheet | Excel Discussion (Misc queries) | |||
row archive and auto email | Excel Programming | |||
Emailing Web Archive Formatted (non-interactive) Excel files.... | Excel Programming |