Export to Excel Formatting/Hyperlink
I have created a DTS package that generates an Excel spreadsheet. I wanted to do some additional formatting of the spreadsheet after the data transfer, so I wrote some vbscript to open the file and do the formatting. Worked great. Then ran into the problem where the package ran ok locally, but not scheduled. Well, it ran ok, but didn't do the additional formatting because Excel is not installed on the sql server (and I most likely won't be able to have it installed). To get around most of my formatting issues, I went the route of having a template file that is pre-formatted how I want it and just copy it and then export the info to the new file. I can live with the formatting this way, but one column of data I would like to be a hyperlink. My problem is that the export puts that annoying ' format thing in front of text, so I can't send a formula (like =HYPERLINK...) SO...does anyone know how I can do this? It's actually a tracking number that I'm sending embedded in the url, and I want the trackig number to display, and clicking on it takes you to the website.