01-18-2012 05:31 PM
Hi. Has anyone successfully identified a way to output multi-tab reports that are readable by *Mac* Excel 2010? The output we currently generate using the ExcelXP tagset works great for PC Excel but fails on the Mac. Our end users are switching to Macs and I'm looking for an alternative to having them access a shared windows server just to open reports.
01-18-2012 08:57 PM
Thanks for the idea. I took a look through the code and example. It appears that the VBS script generated simply automates the process of opening the files in Excel and saving them back out. Since this involves opening the XML files in Excel, it seems that this might work from a PC but not from a Mac, so I'm seemingly back still stuck at square one.
01-19-2012 11:49 AM
very odd...that implies that Office on the Mac doesn't read/render the Spreadsheet ML designed for Office 2003. That seems strange. I wonder whether Microsoft has published a plug-in??? I'd recommend that you check with Tech Support or Google on Office 2003 plug-in for the MAC.
01-19-2012 12:30 PM
SAS Tech Support indicated they're aware the ExcelXP tagset creates files that Mac Excel 2010 can't read. Unfortunately they didn't have any fixes or suggestions for getting around it. I was thinking perhaps someone else had encounted this and found a creative solution. For now I'll try Googling for an Office plug-in or patch as you recommended. Thanks.
01-19-2012 12:52 PM
Do you mean Office for Mac 201? I thought there was a 2008 and a 2011 version of office for mac, not a 2010 one.
Or is there something else that you're doing to get office 2010 on the macs?
01-19-2012 01:52 PM
I just found this, but am not is a position to try it. It does not explicitly say that it deals with Office 2003 format of XML: