Excel Macro to open two excel files and merge them and send the merged one as an attachment
Posted on 2009-12-17
I would need your help in developing an excel macro.It would need to do the following:-
1)Open a text file at c:\myscripts\names.txt,where the file names of the two excel files to be opened will be stored with their locations.
2)Process those two files and merge them in one.
3)Delete two columns and format each column with a predefined width.
4)Send the file as an attachment in Outlook to the address contained in the text file stored in the directory (c:\myscripts\address)
Guys i need your special support to get me through this :)