I have the following code in a VB4-16 program
I = Shell("PKUNZIP -o A:\ORG-DET.ZIP", 0)
When i converted the program to VB5 this no longer works. I get "File Not Found" (53)
What i would like is get the PKUNZIP.exe out of my H:\ drive
and have it unzip the ORG-DET.ZIP file in the A:\ drive
Well, it is simple.
The problem is that the PKUNZIP.EXE file can not be located in the current directory, windows directory, or the PATH environment variable.
Simply append the path where the PKUNZIP.EXE
I needed to skip over some file processing within a For...Next loop in some old production code and wished that VB (classic) had a statement that would drop down to the end of the current iteration, bypassing the statements that were c…
The debugging module of the VB 6 IDE can be accessed by way of the Debug menu item. That menu item can normally be found in the IDE's main menu line as shown in this picture.
There is also a companion Debug Toolbar that looks like the followin…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code.