Hmmm. Don't know what to tell you. I just did a simple test using Access 2003
and Northwind, and it insists on sending in Excel 95 format. I even tried using
acFormatXLSX, and got the same result! The only workaround that comes to mind
is to use TransferSpreadsheet acSpreadSheetType9, and then use Outlook
automation to build a message and attach the exported file. Looks like an old
bug in 2003. Because that version is so old, it won't get fixed. Any chance to
upgrade to 2007?
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: Thursday, August 09, 2012 2:11 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] AcformatXLS produce Error
Sorry John, I will leave the entire thread intact,
Yes I have excel 2003 installed on my laptop, BUT
I will run the MDE apps on the pc that only running access 2003 runtime and no
excel installed.
Thanks
--- In MS_Access_Professionals@yahoogroups.com, John Viescas <JohnV@...> wrote:
>
> 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
>
------------------------------------
Yahoo! Groups Links
Tidak ada komentar:
Posting Komentar