Greetings,
Currently im doing an invoice software in which it will automatically save all the data entered by the user into excel file. Then when the user click 'SAVE' button, the excel file will be saved. However, the size of the saved file is very big which is 1.46MB, but if the data is inserted manually into excel (without using the software), the size is only approximately 60kB. Does anyone know what's the problem? Please Help...
Your help is greatly appreciated. Thank you in advance.
The most commonly used approch to transfer data to Excel file from VB is automation.
With Automation, one can use several approaches for transferring these data: These broadly includes the following
>> Transfer data to the sheet cell by cell
>> Transfer data in an array to a range of cells on the excel sheet.
>> Transfer data in an ADO recordset to a range of cells using the CopyFromRecordset method
>> Transfer data to the clipboard and then paste the clipboard contents into an Excel worksheet.
What approach are you exactly following for saving your data.
-ansuman sahu