This was fixed as of 5.4.2. It uses .TAB as the extension. Not sure what they did about the rename/move problem.
-----Original Message----- From: Colin Alfke Sent: Friday, April 19, 2013 1:26 PM To: 'U2 Users List' Subject: Re: [U2] Exporting to Excel after upgrading to MS Excel 2007 I used the .txt extension (as the file is really a text file). The final DDE macro error is because when it opens the file it uses "compatibility" mode which uses a smaller sheet size than the newer version and the last step SBClient does is to copy the sheet to a new sheet with a different name. Excel returns an error on the copy because of the different sizes. I never looked far enough into it to determine if it would be easier to change how Excel opened the file or to modify the scripting commands SBClient sent. Hth Colin -----Original Message----- From: Lunt, Bruce Sent: Friday, April 19, 2013 12:48 PM To: u2-users@listserver.u2ug.org Subject: [U2] Exporting to Excel after upgrading to MS Excel 2007 Hi All, We are on HP9000 running Unidata 7.1 with SB+ using SB Client 5.3. We have been on MS Excel version 2000 and just upgraded to version 2007. Now the default extension for Excel sheets is: xlsx. When I run the transfer program - TU.TO.EXCEL - it now displays this error message before sending the data to Excel. The file you are trying to open,'SBCLIENT.XLS', is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now? I can answer Yes and the data will export to Excel. After the job finishes it displays this error: DDE Macro Error Continue I have modified the program that calls TU.TO.EXCEL to use the extension of 'xlsx' but it still gives me the same errors. Is there some other thing that I can do? Thanks for any help that you can provide. Regards, Bruce Lunt _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users