Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Has anyone come across this problem in XP
with creating a batch file, by first creating a text file then closing it. Then output using wzunzip.exe as follows:- Open "D:\WMSCall\extract.txt" For Output As #1 Print #1, "D:\WMSCall\wzunzip.exe D:\WMSCall\ZippedFiles\" & Carrier & "\" & fileStr & _ FileYearStr & ".zip D:\WMSCall\ZippedFiles\All\" Close #1 'Rename .TXT to .BAT to enable remote execution Name "D:\WMSCall\extract.txt" As "D:\WMSCall\extract.bat" 'Run extract.bat runBat = Shell("D:\WMSCall\extract.bat") When trying to run this in xp it does not work. Can anyone offer any ideas! thanks in advance |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Instead of making a .bat file, maybe you could just shell out to the unzipping
program. Ron de Bruin has some code to do the opposite (zip--not unzip) at: http://www.rondebruin.nl/zip.htm maybe you can pick it apart and modify parts of it. Jonathan Jones wrote: Has anyone come across this problem in XP with creating a batch file, by first creating a text file then closing it. Then output using wzunzip.exe as follows:- Open "D:\WMSCall\extract.txt" For Output As #1 Print #1, "D:\WMSCall\wzunzip.exe D:\WMSCall\ZippedFiles\" & Carrier & "\" & fileStr & _ FileYearStr & ".zip D:\WMSCall\ZippedFiles\All\" Close #1 'Rename .TXT to .BAT to enable remote execution Name "D:\WMSCall\extract.txt" As "D:\WMSCall\extract.bat" 'Run extract.bat runBat = Shell("D:\WMSCall\extract.bat") When trying to run this in xp it does not work. Can anyone offer any ideas! thanks in advance -- Dave Peterson |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() Dave Thanks for the reply will advise or post the answer, when found Cheers Jonathan *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Jonathan
Maybe this is useful http://www.rondebruin.nl/unzip.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Jonathan Jones" wrote in message ... Dave Thanks for the reply will advise or post the answer, when found Cheers Jonathan *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can I batch convert 97-2003 .xls files to 2007 .xlsx files | Excel Discussion (Misc queries) | |||
zip/unzip excel files | Excel Discussion (Misc queries) | |||
unzip/zip xlsx files | Excel Discussion (Misc queries) | |||
How do I Unzip the files in "ExcelMap-China-Region.Zip" into your | New Users to Excel | |||
Batch conversion of XP files to 97 files | Excel Discussion (Misc queries) |