OutputTo vs TransferSpreadsheet - Latest version of Excel Problem

[Guest]

We have VB which creates multiple spreadsheets using OutputTo. The VB also
once the file is created, opens it, makes a change and closes the file. For
some reason, when it closes the file, we are prompted to upgrade the
spreadsheet to the latest version.

This didnt happen when we used a macro to "OutputTo"

The VB was created from the working macro to add to our confusion.

By using TransferSpreadsheet we dont get the prompt but we dont get the
formatting we wanted either. Is there either a way to create a spreadsheet
with OutputTo via VB with the latest version or a way to suspend the message
in Excel.

Thanks

Steve

 

[Lee Robinson]

Steve,

According to the help for the TransferSpreadSheet method, the second
parameter is SpreadsheetType the possible values are:
AcSpreadSheetType can be one of these AcSpreadSheetType constants.
acSpreadsheetTypeExcel3
acSpreadsheetTypeExcel4
acSpreadsheetTypeExcel5
acSpreadsheetTypeExcel7
acSpreadsheetTypeExcel8 default
acSpreadsheetTypeExcel9 default
acSpreadsheetTypeLotusWJ2 - Japanese version only
acSpreadsheetTypeLotusWK1
acSpreadsheetTypeLotusWK3
acSpreadsheetTypeLotusWK4


Perhaps specifying another type would help.

Lee Robinson