Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Jul 2006
    Posts
    71
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Office 2010 (Access VBA) export to Excel 2003 .xls?

    We have an Access utility which processes timesheet data. One of its valuable features is that it will export a week's worth of data to a spreadsheet in Excel 2003 format, which the clerks enter into the mainframe payroll program. We're in the throes of upgrading the utility, and this week the programmer's own computer was updated to Office 2010. She told me today that now the utility insists on exporting the spreadsheet to a 2010 format, xlsx.

    Since many of the users don't currently have Office 2010, which is being rolled out over some months, we'd like to find a way for VBA to set the export to a 2003 format, .xls. I have the filter which converts 2010 to 2003, but it will slow everyone down enormously. If Excel can save a file in an earlier format, VBA should be able to specify it . . . . Any suggestions?

    Many thanks,

    axsc

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    6,371
    Thanks
    206
    Thanked 827 Times in 760 Posts
    AXSC,

    You probablly have 2 options here.
    1. Let it export to .xlsx format and install the free MS Conversion pack on all the machines with versions prior to 2007.
    2. Have the programmer change the code to change to save to Office 2000 format. To do this use the DoCmd TransferSpreadsheet method. Check out the help file for specifics.
    May the Forces of good computing be with you!

    RG

    VBA Rules!

    My Systems: Desktop Specs
    Laptop Specs


  3. #3
    Star Lounger
    Join Date
    Jul 2006
    Posts
    71
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Thank you very much! I will share the DoCmd TransferSpreadsheet approach as being the most likely to work well.

    axsc

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •