Years ago I did the same sort of export to Excel. I ended up developing a macro in Excel that did all the formatting I needed. I never did get the raw exported data to have the formats I wanted. The macro was a simple button push in Excel so it was an easy and quick task.
Jeff
----- Original Message -----
In query I set the format to "Standard" so I want when exported to excel it still have the format so I don't have reformat on excel.
I try docmd.outputo and can do what I want, the format is exported to excel to BUT it export to excel 5 by default not excel 8/9. Can't open excel5 on smartphone/tablet, I have submit this issue lastmonth, so Need to use docmd.transferspreadsheet.
Thanks
--- In MS_Access_Professionals@yahoogroups.com , "Bill Mosca" <wrmosca@...> wrote:
>
> Formatting does not change how the data is stored, and when you export to Excel
> you are sending the raw data. What do you want the numbers to look like?
>
>
>
> Regards,
> Bill Mosca,
> Founder, MS_Access_Professionals
> That'll do IT < http://thatlldoit.com/ > http://thatlldoit.com
> MS Access MVP
>
> < https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881E >
> https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881E
>
> My Nothing-to-do-with Access blog
>
> < http://wrmosca.wordpress.com > http://wrmosca.wordpress.com
>
>
>
> From: MS_Access_Professionals@yahoogroups.com
> [mailto: MS_Access_Professionals@yahoogroups.com ] On Behalf Of Mas Shine
> Sent: Thursday, August 30, 2012 3:10 AM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] Format Disable when Export to Excel
>
>
>
>
>
> I have a query with 3 fields, A(text),B(number),C(number) I have set the
> format foro B & C to "Standard", If I run the query the format is works
> fine.
>
> BUT when I export those query to excel using docmd.transferspreadsheet
> the format setting is disable so the result in excel is B & C have no
> format.
>
> How to include the format to excel file ?
>
> Thanks
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
--
Jeffrey Park Jones
Excel, Access, Word, Office Expert
Excel and Access, LLC®
http://ExcelAndAccess.Com
919-671-9870
5109 Deer Lake Trail
Wake Forest, NC 27587
jpjones23@centurylink.net
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar