N/APosted on - 01/06/2012
How could I send email files to be viewed in Excel from the software that is written in Visual Basic 6 (VB6), so that when the receiver opens the Excel book, it will not only shows the data but copies all the codes?
Can you get my point?
If so, please send me some help.
Send Email Files Written in VB6 and Viewed in Excel
That process will require that you use some add-ins, and one such add-in is called the RDBMail utility. The following is how you work with this utility:
First you will need to download it and then extract it to a local directory.
Thereafter you will need to copy RDBMail.xlam to a unprotected directory on your system. You should use one folder for all your add-ins so that it will be easy to backup your add-ins.
After that, you will need to start Excel and then open a workbook.
For ms excel 2007 you will need to click the Microsoft Office Button, and then click Excel Options, and thereafter click the Add-Ins tab.
In case you are using excel 2010 you will need to click on File, and then click on Options, and then click the Add-ins tab.
After that you will go to the Manage drop-down, and there you will choose Excel Add-ins, and then click Go. Use “Browse” to go to the add-in and then you will click on OK.
Lastly you will need to check and make sure that RDBMail is checked in the add-in list and then click OK.