Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Afternoon all,
I'm hitting a slight problem trying to get the ShellAndWait command running, using the example on Ron DeBruin's site at: http://www.rondebruin.nl/zip.htm. I've simply copied & pasted the code relating to "Zip The ActiveWorkbook" as a starting point. Specifically, I'm getting a "Sub Or Function Not Defined" error on the line ShellAndWait ShellStr, vbHide I'm wondering whether a specific required reference is not active, or whether this function isn't available in this Excel version (2k). Replacing ShellAndWait with Shell works ok, but I don't want VBA to continue running until the zip operation is complete. Yes, I know I could simply insert an Application.Wait, but this is gonna niggle at me until I know what's going on! Any ideas appreciated, cheers! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Use MS Query to query data within the current work book | Excel Discussion (Misc queries) | |||
Convert hard coded query criteria to Parameter Query | Excel Discussion (Misc queries) | |||
Excel 2007 / MS Query - editing existing query to another sheet | Excel Discussion (Misc queries) | |||
Save data retreived from query without saving query | Excel Discussion (Misc queries) | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) |