Barry Brevik wrote: > ...does anyone know if it is possible to embed some kind > of command in a CSV file that will get Excel to autofit > those rows automatically?
The DIY solution is to use XML, for which there are examples around the Net. It's always amazed me that most IT people think that a plain CSV is an adequate deliverable when users want "Excel". End-users often spend hours to days per month, reformatting data delivered like this, rather than making a request to IT for something more useful. I think there is some unstated belief by end-users that IT _can't_ create anything more sophisticated than a CSV, so they often don't bother to ask - it's one of those self-fulfilling situations that people assume won't change so they don't ask and then things never change. Anyway, I'm glad to see people here looking for something a little more professional and I encourage everyone to check with your C-level management or other hardcore Excel users about what they _really_ need from Excel, including multiple sheets in a workbook, charts, highlighted data, and dynamic updates from live databases (including MITS cubes, etc). Seeing there are no other definitive solutions presented in this thread... The problem described is exactly the problem solved with NebulAnalysis: http://Nebula-RnD.com/products/analysis.htm NebulAnalysis and other MS Office integration products were written a few years ago. Unfortunately there was only a small trickle of demand so we are no longer "actively" offering them. For some reason over the last few months a lot of people are looking to control Excel from MV so I might bring it back based on demand and available time. Please have a look at the audio/video demo here: http://Nebula-RnD.com/demos/nebulanalysis/ If you like what you see I may port this to U2 and give it some new life. While you're on the site, check out NebulaManager to see what's possible with Outlook - that's another one that I'd like to bring back. http://nebula-rnd.com/products/manager.htm I have a lot of experience with the internals of all of the Microsoft Office applications, and intend to continue development with Office 12 and the MS Office System. Nebula R&D is growing and now has a team of U2 professionals who can do this sort of work. So if you need to get info to or from any Office product, feel free to ask about what's possible. Tony Gravagno Nebula Research and Development TG@ removethisNebula-RnD.com (We just posted a major website update with completely reworked pages, lots of new content, and a completely new strategic message. Please feel free to browse the site, comment, ask questions, etc. - Thanks!) ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
