Search results

The reason i need this to run is i currently have scripts which run and export excel files to a folder. I just need to see 2 files in the folder were created today, if they have been created today i can allow my database to update, if not i want it to display a message so people can manually...

Hi Goh, Dim oFS As Object Dim strFilename As String 'Put your filename here strFilename = "c:\excel stuff\commandbar info.xls" 'This creates an instance of the MS Scripting Runtime FileSystemObject class Set oFS = CreateObject("Scripting.FileSystemObject") MsgBox...

Hi Goh, Thank you for your message. I've added the code but it comes up saying: "Compile Error: Sub or function not defined" I also noted the () brackets do not stay in the code when i enter it!

A question of "to run, or not to run!"?! I have a database which I've 'helped' in creating but now want to make others available to update - in the past this has not gone well! The database uses data from two excel sheets and the problem has been people do not always check if these have been...

The most obvious reason to me for joining a forum is help and advice others can give so firstly i wish to say thank you for any help i receive! I am trying to learn and use VBA with Access primarily, so far with some success, in other area it is an epic fail! Anyway, thank you again for any...