Newbie help

[ukmale65000]

I have recently created a database which exports a daily report in Excel. The problem I am having is that the reports are sent out in Excel 95 which cannot be opened by Blackberry. We used to create this report from an excel database and send it out but it went out in excel 97 format which was readable. As a complete "Access" novice I am at a loss on how to cure this problem short of copying the excel 95 report which we create automatically and cutting and pasting into excel 97.
Over to the experts.

 

[boblarson]

How are you exporting it (and getting it in Excel 95 format)? Are you using code, or doing it manually? Which version of Access are you using?

 

[ukmale65000]

Sorry forgot to say im using Access 2000. The report is sent via a macro in EXL format

 

[boblarson]

In a macro you should be able to use the TransferSpreadsheet command and in it you can choose the Excel version under Spreadsheet Type.

 

[ukmale65000]

How then do i export it in an e mail automatically, as I said its probably very simple but then so am I.

 

[boblarson]

Which macro action are you currently using?

 

[ukmale65000]

Im currently using sendobject, which as i say works but sends it in excel 95 which is no good

 

[rsmonkey]

hmm i gave you a script on the other thread about how to do this... but if your insistent about using send object then this will send it as a Excel 2000-2003 file!

DoCmd.SendObject _
    acSendTable, _
    "Table Name", _
    acSpreadsheetTypeExcel9, _ <--- That defines Excel version
    "ToJohn@doe.com", _
    , _
    , _
    "Type Your Email Subject here", _
    "Type any Email Message Here", _
    False

 

[ukmale65000]

Thanks for the help im using the transfere spreadsheet option now which i store and then send out manually.