Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Extract the text between last comma and last but one comma. | Excel Worksheet Functions | |||
Comma Delimited-need comma at beginnng & end | Excel Discussion (Misc queries) | |||
what does ~ operator mean? | Excel Discussion (Misc queries) | |||
Excel How do I create a comma delineated xls file to a comma delineated. | Excel Discussion (Misc queries) | |||
Can the AND operator be of use here? | Excel Programming |