Hey Folks,
I have a few Access database applications that are basically just some VBA modules that are kicked off by a macro trigger ... at the end of some of these modules I kick off a shell command that essentially runs a batch file resident on the machine. These apps have worked very well in the last few years, and I am wondering is there a way to perhaps embed the batch file somehow into the Access database so that I don't need that batch file as an extra file required on the system? If not, is there perhaps a way in which I can run the commands that are in the batch file but in VBA? Some of the batch files are fairly lengthy and they basically perform functions such as copying and renaming files across networked drives, ftping certain local files, unzipping certain files, etc.
Thanks for any help and ideas,
Joe
I have a few Access database applications that are basically just some VBA modules that are kicked off by a macro trigger ... at the end of some of these modules I kick off a shell command that essentially runs a batch file resident on the machine. These apps have worked very well in the last few years, and I am wondering is there a way to perhaps embed the batch file somehow into the Access database so that I don't need that batch file as an extra file required on the system? If not, is there perhaps a way in which I can run the commands that are in the batch file but in VBA? Some of the batch files are fairly lengthy and they basically perform functions such as copying and renaming files across networked drives, ftping certain local files, unzipping certain files, etc.
Thanks for any help and ideas,
Joe
