Variable in Shell Call under VBA
Posted on 2011-10-05
Hi, I have a shell command beneath a button on an access form which works well. My problem is that two directory locations specified within the current shell command can vary from user to user. Here is the VBA:
'Shell """c:\program files\monarch\program\monarch"" ""C:\Temp\AvgBal.txt"" ""C:\Temp\AverageBalances\ModelFiles\AvgBal.xmod"" ""C:\Temp\AverageBalances\AvgBal.mdb"" /t", vbHide
The location C:\Temp can change, as can the C:\Temp\AverageBalances location. What I need is to create each location as a variable and then place the variable within the shell command. Can this be done, and how might it work?