ACCESS FEED: RE: [MS_AccessPros] AcformatXLS produce Error

Rabu, 08 Agustus 2012

RE: [MS_AccessPros] AcformatXLS produce Error

Do you also have Excel 2003 installed?

It helps if you leave the entire thread intact - I had to go back to an old
message to see your original problem.

John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of ivanleon77
Sent: Wednesday, August 08, 2012 11:36 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] AcformatXLS produce Error

--- In MS_Access_Professionals@yahoogroups.com, John Viescas <JohnV@...> wrote:
>
> Solution 1: Get an iPhone or Galaxy S III <s>
>
> Solution 2: Make sure you're using acFormatXLS and not acFormatXLSX
>
> Try sending the file again to yourself using SendObject, but open the message
in
> an email program on your computer. Open the attached file to verify the Excel
> format. You can do that by doing a Save As from Excel to see what format
Excel
> thinks the file is. It probably needs to be 97-2003 format to be readable on
a
> Blackberry.

I try to open it from Thunderbird and save as, it shown that have version excel
5.0/95. I still want to use docmd.sendobject...acformatxls, how to save it as
excel 97-2003 ?

Yes I am using AcformatXLS not XLSX and I am using access 2003.

Thanks

------------------------------------

Yahoo! Groups Links