Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formatting all cells or sheet
Although I'm not familair with the Excel object libarary, I am familiar with
VBA. How can I format the whole sheet to use Text as the cell formatting, as opposed to General, the default? Me.Cells.Format...? Thanks, Steve |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formatting all cells or sheet
Activesheet.Cells.Numberformat = "@" -- HTH RP (remove nothere from the email address if mailing direct) "Steve Schroeder" wrote in message ... Although I'm not familair with the Excel object libarary, I am familiar with VBA. How can I format the whole sheet to use Text as the cell formatting, as opposed to General, the default? Me.Cells.Format...? Thanks, Steve |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formatting all cells or sheet
Activesheet.cells.numberformat="@"
"Steve Schroeder" wrote: Although I'm not familair with the Excel object libarary, I am familiar with VBA. How can I format the whole sheet to use Text as the cell formatting, as opposed to General, the default? Me.Cells.Format...? Thanks, Steve |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formatting all cells or sheet
Thanks both of you for your help, that did appear to work. As is usually the
case, the situation is a bit more complicated. Becase the column I am formatting contains a string value of: 12929.00000001 (case number, text, not an 8 decimal place number) Even formatting it to text still leaves it 12929, at least visually. If you pretend to edit the cell, then move to another, it then appears as wished, the full string. I should also mention that this data is coming in from an ASP.Net web page. I actually tried to add the formatting in the VBScript code, but only got an error, incidently not the line I add, i.e.Activesheet.Cells.Numberformat = "@" The error is: Invalid Procedure Call or argument, and it happens on: HTMLProjectItems("Sheet1").Text = sHTML. Here is the VBScript code I'm using. Any thoughts or ideas would be greatly appreciated. Thanks! Sub cmdExcel_onclick() Dim sHTML sHTML = window.document.forms(0).children(4).outerhtml Dim oXL, oBook Set oXL = CreateObject("Excel.Application") Set oBook = oXL.Workbooks.Add oXL.Sheets("Sheet1").Cells.NumberFormat = "@" oBook.HTMLProject.HTMLProjectItems("Sheet1").Text = sHTML oBook.HTMLProject.RefreshDocument oXL.Visible = true oXL.UserControl = true End Sub "Steve Schroeder" wrote in message ... Although I'm not familair with the Excel object libarary, I am familiar with VBA. How can I format the whole sheet to use Text as the cell formatting, as opposed to General, the default? Me.Cells.Format...? Thanks, Steve |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formatting all cells or sheet
Ok, well here's what I did, although it isn't a perfect solution: oXL.Sheets("Sheet1").Columns(1).Cells.NumberFormat = "#####.########" oXL.Sheets("Sheet1").Columns(1).Cells.HorizontalAl ignment = -4131 "Steve Schroeder" wrote in message ... Thanks both of you for your help, that did appear to work. As is usually the case, the situation is a bit more complicated. Becase the column I am formatting contains a string value of: 12929.00000001 (case number, text, not an 8 decimal place number) Even formatting it to text still leaves it 12929, at least visually. If you pretend to edit the cell, then move to another, it then appears as wished, the full string. I should also mention that this data is coming in from an ASP.Net web page. I actually tried to add the formatting in the VBScript code, but only got an error, incidently not the line I add, i.e.Activesheet.Cells.Numberformat = "@" The error is: Invalid Procedure Call or argument, and it happens on: HTMLProjectItems("Sheet1").Text = sHTML. Here is the VBScript code I'm using. Any thoughts or ideas would be greatly appreciated. Thanks! Sub cmdExcel_onclick() Dim sHTML sHTML = window.document.forms(0).children(4).outerhtml Dim oXL, oBook Set oXL = CreateObject("Excel.Application") Set oBook = oXL.Workbooks.Add oXL.Sheets("Sheet1").Cells.NumberFormat = "@" oBook.HTMLProject.HTMLProjectItems("Sheet1").Text = sHTML oBook.HTMLProject.RefreshDocument oXL.Visible = true oXL.UserControl = true End Sub "Steve Schroeder" wrote in message ... Although I'm not familair with the Excel object libarary, I am familiar with VBA. How can I format the whole sheet to use Text as the cell formatting, as opposed to General, the default? Me.Cells.Format...? Thanks, Steve |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel: match two cells in one sheet to two cells in another and return a third cells value | Excel Worksheet Functions | |||
condionally formatting based on another cells formatting? | Excel Discussion (Misc queries) | |||
Is there a shortcut for applying sheet formatting to another sheet | Excel Discussion (Misc queries) | |||
Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
Formatting unlocked cells on protected sheet | Excel Programming |