#1
|
|||
|
|||
Setting "dd.mm.yyyy" date format for Excel column doesn't work properly!
Code:
... Dim fs As Object Dim fo As Object Dim strTargetSheet As String ... Set fs = CreateObject("Excel.Application") Set fo = fs.Workbooks.Add fo.Sheets("Sheet1").Name = strTargetSheet ... fo.Sheets(strTargetSheet).Columns("F").NumberFormat = "dd.mm.yyyy" ... |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Trying to use function =if(isblank(**),"",1) but it doesn't seem to work on the columns Ihave listed | daviddyer2902 | Excel | 1 | 03-06-2023 02:24 AM |
Change the Column reference 'S' to a range ??? Sheets("Customer").Range("S" & ActiveCell.Row) = Date | trevorc | Excel Programming | 1 | 03-04-2021 02:39 PM |
"Uppercase" in Master Layout doesn't work in actual slides | BDesign | PowerPoint | 2 | 07-03-2019 07:06 AM |
Formula to format "I" column based on if "F" column row is not blank | ravl13 | Excel | 3 | 08-22-2017 12:26 PM |
Why the "table of contents" doesn't take the same format of the "headings"? | Jamal NUMAN | Word | 5 | 06-15-2011 10:14 AM |