Hi,
Trying to do this in an non-English Office 2016 installation.
The last line fails to open the as the bLimit evaluates as true/false in non-English language. The SQLString becomes in this case "SELECT Process.ProcessName FROM Process WHERE Process.IsApproved = True And Process.HasOutdoors = Sant". (Sant is True in Swedish).Please Login or Register to view this content.
How do I work around this? Is there any setting in VBA where you force variables to be english? I want my macro to be installation independent.
I could of course write
And use this instead of bLimit. But my VBA program is much larger than this, and I wouldn't want to search/replace all these issues in SQL queries.Please Login or Register to view this content.
Thanks in advance,
Johan
Bookmarks