How to send Zip/Excel files automatically through Excel macros?

Question

Basically we generate Excel files every night and by morning each of them needs to be sent to different emails. What Im trying to do is create an auto sender with full paths to each file. I was provided with this code but every time I click the bottom I receive an error.

link to code: http://database.ittoolbox.com/groups/technical-functional/excel-l/send-excel-files-automatically-1827286

Error: "expected line number or label or statement or end of statement"

Thanks

puaka · Accepted Answer

The program is very simple and should work if you have the file name and path in column 1 and its recipients separated by commas in column 2.

You will need to read up on Excel debugging tools. 

It involved running each line of code one of the time to see find the error.

Once the line is identified, every variable to check using the immediate window.

Good luck.

Renee · Answer

I'm not following what is happening. I have never had buttons disappear when I copied the file to a different computer. Do you have the buttons and the macros in the same workbook? If they are in different workbooks, be sure you send both workbooks. If they are in the same workbook, there may be some problem with the Excel on the receiving system. You can try re-installing Excel and use Advanced mode and be sure any optional components regarding forms and/or buttons are installed. I have encountered the buttons being disconnected from the macros, when in a different workbook, if the macro workbook is in a different folder name or a different path. The buttons are there, but don't run the macros. I don't know what is happening in your situation.

Trending News

How to send Zip/Excel files automatically through Excel macros?

2 Answers