So im using CDO to automate emailing some excel files i have updated everyday.
These files get saved with tomorrows date - and everytime i try to attach a file it says cannot find specific file.. now if i specify the name exactly then it works however i want this to run even when i am not here so i need vba to recognize tomorrows date and im not sure why its not working as im using the same method to save the file name with tomorrows date?
i get error - the system cannot find the specified file.
Any ideas? ~ have tried using autoit to send CDO email but couldnt get it working either