Monthly Archives: September 2018

Visual Basic Script that can be used to rename a file

Here I am trying to automatically load log files into a MS Access file. Log files are actually txt files which need their extension changed if like me you wish to automate their import into MS Access. The following Visual … Continue reading

Posted in All, VBS Scripts | Comments Off on Visual Basic Script that can be used to rename a file

MS Access Function – Run VBS script from within MS Access

A very simple function that will allow you to run any vbs script from within MS Access Function RunVBS() Shell “wscript c:\users\mark\vbs\RenameFile.vbs”, vbHide End Function

Posted in All, VBA Code MS Access, VBS Scripts | Comments Off on MS Access Function – Run VBS script from within MS Access