I used the shell command to call pkunzip a file on my HD.
However, i found out that the SHELL command is asyncronous meaning that it runs the code lines just below the shell command call. If this occurs then my program will have problems.
Is there a way to tell when the SHELL's command call has finally finished (the pkunzip call is done)? I know the SHELL command returns a task ID but i haven't found a way to use this in helping me tell when the call is done.
I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
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.