OutputTo Excel Macro different to VB

[Guest]

I have a macro that OutputTo's a spreadsheet. This creates the latest version
of Excel. When i convert the macro to VBA and run it it creates a 5.0/95
file.

Any ideas please.

VBA is ...

DoCmd.OutputTo acQuery, "Branch Planner All", acFormatXLS, "c:\data\Branch
Planner.xls", False, "", 0

When i open the spreadsheet and save it i get the extra screen asking if i
wish to update it to the latest version which i dont want.

 

[Guest]

Steve,

I answered this yesterday as a reply to your post then.

Lee Robinson

 

[Guest]

Sorry Lee, for some reason i counldnt open my first question so i
re-submitted. I wanted to use OutputTo rather than transfer text as it
formats the cells correctly, transfertext doesnt, in my vb i open the excel
sheet and do an "End Down" and an "End Right", because outputto formats the
cells i go to the last line and column which was output, even if its empty,
with transfertext there isnt any formatting to i go to row 65536 and colmn IV.

Hence i wanted to get to the bottom of why outputto didnt work consistantly.

Steve