File saved is too large..

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • nanaalwi
    New Member
    • Dec 2006
    • 5
    #1

    File saved is too large..

    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.
    Tags: None
    • Killer42
      Recognized Expert Expert
      • Oct 2006
      • 8429
      #2
      Originally posted by nanaalwi
      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?

        Comment

        • ansumansahu
          New Member
          • Mar 2007
          • 149
          #3
          Originally posted by nanaalwi
          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 CopyFromRecords et 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

            Comment

            Previous template Next
            Working...