Creating Worksheet using Server Object
I am using the CreateObject("Excel.Application") to create a workbook from
three separate tables in a sql db. This works great and compiles three separate sheets to one workbook. My issue is that I need the cell formatting to be text for all entries. However the Excel spreadsheet will take my data - 05/05 and translate to 05-May OR my data 0140 and translate to 140. How can I write the vbscript to format all cells to text? -- Olivia Towery |
All times are GMT +1. The time now is 07:06 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com