StrCompressed = DRIVE_PATH & strMonthAndYear & ".exe /auto " & TEST_OUTPUT_PATH ĭebug.Print "strCompressed = " & strCompressed StrFileName = " " & strMonthAndYear & AR_ID & ".txt " M_strFileName = m_strDrivePath2 & strMonthAndYear & AR_ID & ".txt" 'Set file name ' keeps the code from continuing until the file is de-compressed. ' extracting ZIP file to create the text (.TXT) files to import. ' Set the filename for the compressed file and the text file. Also, in my defense, I didn't write this mess, I'm just trying to fix it since the original dev is no longer available. Please excuse the messiness, I've been tweaking it trying to get the verschlugginer thing to work. I'm checking the value of the string, and it's passing exactly what's above. It's just completely ignoring everything after exe. You get the same exact result if you leave out the output location parameter, and even if you leave out the /auto parameter. When, however, you create a shell in VBA and send the exact same command, it brings up the WinZip interface in normal mode, asking if you'd like instead to extract to C:\Users\UserName\AppData\Local\Temp. \\snt201\FolderName\SubfolderName\FEB23.exe /auto \\snt201\FolderName\SubfolderName\ExtractedFileSubfolder\
When you pull up the Command Prompt and manually enter the following, everything works perfectly: This has worked for YEARS, until it started failing this month. The situation is that we have an application that takes a WinZip self-extracting archive, executes the archive in silent mode, and provides an export location. The company has me working primarily in C# these days, but today I'm fighting Access again.
0 kommentar(er)
