Thread
: [Solved]
Setting "dd.mm.yyyy" date format for Excel column doesn't work properly!
View Single Post
05-10-2023, 04:28 AM
p45cal
Windows 10
Office 2019
Expert
Join Date: Apr 2014
Posts: 948
It worked here, but note that:
1. I had to use:
fs.Visible=True
so that I could see the workbook
2. strTargetSheet contained an empty string, so I had to add a line like:
strTargetSheet="MyNewName"
After which the column was correctly formatted.
p45cal
View Public Profile
Find all posts by p45cal