comma as concatenation operator ?
Here is a snippet of some extremely annoying code:
"OLEDB;Provider=Microsoft.Jet.OLEDB.4.0;Password=" """;User ID=Admin;Data Source=" & strDir & Left(Sheets("Home").cboMonth, 3) &
"" _
, _
"ls;Mode=Share Deny Write;Extended Properties=""HDR=NO;"";Jet OLEDB:System database="""";Jet OLEDB:Registry Path="""";Jet
OLEDB:Databas" _
, _
"e Password="""";Jet OLEDB:Engine Type=35;Jet OLEDB:Database Locking Mode=0;Jet OLEDB:Global Partial Bulk Ops=2;Jet
OLEDB:Global Bu" _
, _
"lk Transactions=1;Jet OLEDB:New Database Password="""";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt
Database=False;Jet" _
, _
" OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False" _
I hope your newsreader doesn't make this worse by wrapping, but my question is this: each line of this code (written by the macro
recorder) ends with a line continuation character and then the next line is simply a comma and another continuation character. The
only way this makes sense to me is if the comma is being used instead of an ampersand for a concatenation operator. I have never
heard of this before and couldn't find anything about it. Is this for real? The answer is important because I can't use the
auto-generated code as-is. Also, it looks stupid, cutting words in half and generating a nearly blank row before continuing. Why
would it do that?
Most importantly, please tell me if the comma is useable as a concatenation operator.
Thank you in advance !
--
RMC,CPA
|