Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Numberformat: automation from MS Access
From access i am creating excel workbooks and worksheets within each
workbook. I am using a template, which opens with one worksheet. I add the data I need to this sheet, copy the sheet forward and loop through my recordset until recordset = EOF. My problem is that the number formatting does not copy forward from the original sheet. The original sheet remains the same, but each sheet my routine copies, contains incorrect formatting. I even attempted to format the cells in the code, but it will not "take". See the section of my code below that attempts to do this. xlApp.Range("E15").Value = "'" & strPer1 'Period 1 label xlApp.Range("E16").Value = rsData.Fields(3).Value 'Period 1 value+ xlApp.Range("E16").NumberFormat = "#,##0_);[Red](#,##0_)" What am i doing wrong? Is it an excel default issue? template? Thanks in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel automation through .NET Interop: NumberFormat property looks like NumberFormatLocal | Excel Programming | |||
automation from access into excel | Excel Discussion (Misc queries) | |||
Numberformat for Cells using Automation | Excel Programming | |||
Access 2000 - Automation example please | Excel Programming | |||
Automation Excel & Access | Excel Programming |