View Single Post
 
Old 05-10-2023, 05:42 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 932
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

Quote:
Originally Posted by p45cal View Post
I had to use:
fs.Visible=True
so that I could see the workbook
I wanted to format dates column for case the converter app will be used by user with non-European local settings. As the app itself will be used in European country, then inserting dates into range formatted as General automatically converts the range as local date. Probably computers of all employees there are using local settings with right date format. Until they will have problem with some employee having different local settings for his/her computer, I'll drop this case!

[/QUOTE] strTargetSheet contained an empty string, so I had to add a line like:
strTargetSheet="MyNewName"[/QUOTE]
I added a row where strTargetSheet was declared only - to show variable's format. In real code, there is more of it, where it's value is read from SetUp page of converter app, or when it is not determined, its default value is composed. There was no need to include all this.

Thanks anyway for responding!
Reply With Quote