I currently have a button which basically calls a macro which saves the straight table into comma separated file. I then have to manually FTP the file on a monthly basis. I would like to automate the creation & FTP the file on a monthly basis. The document is refreshed on a hourly basis and I do not have publisher. What options do I have?
