Print Page - Use OLE to apply date format to cells?

Title: Use OLE to apply date format to cells?
Post by: mark_in_atx on January 02, 2018, 05:21:00 AM

When I execute this:

objWB.Worksheets('Worksheet 1').Range('Q12:Q100').NumberFormat="d/m/yyyy"

It applies the number format to the range, not the date format. How do I apply a date format to a range???

Thanks!

Title: Re: Use OLE to apply date format to cells?
Post by: td on January 02, 2018, 06:49:44 AM

Excel stores dates as serial numbers so I am not sure what you are asking.

WinBatch® Technical Support Forum

All Things WinBatch => WinBatch => Topic started by: mark_in_atx on January 02, 2018, 05:21:00 AM