Search code examples
vbashellunc

VBA Shell command - how to format


Can anyone tell me what I need to do to format a VBA shell command to launch MS Access and preload a network based database. I have tried this with the normal windows path and using a UNC i.e Shell "msaccess.exe \\OMRSRV\Projects\Clients\HP\DailyCustomerSatisfaction\HP.accde", vbMaximizedFocus

Cant get it to work - Invalid procedure call or argument!


Solution

  • Thanks @ChipsLetten you kicked the cage nicely there even if you didnt directly offer the solution: it could not have been simpler - msaccess.exe required its path to be included in the statement!