By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,117 Members | 1,714 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,117 IT Pros & Developers. It's quick & easy.

File saved is too large..

P: 5
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.
Apr 13 '07 #1
Share this Question
Share on Google+
2 Replies


Expert 5K+
P: 8,434
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?
Can you show us the code which does the save? And what version of VB is it written in?
Apr 13 '07 #2

100+
P: 149
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
Apr 13 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.