Declaring a multidimensional const ????

[ksor]

I would like to declare a multidimensional const of 11 pairs of 2 strings, but oh it hurt to find out how !



I can get this to work:

Dim MainFolders As String
MainFolders = [{"BILLEDE","IMG_files"; "BO_KOMMENTAR","BO_docs"; "DELTOG_I","GUEST_docs"; "GENST_KOMMENTAR","GENST_docs"; "NOTATER","NOTAT_docs"; "PARFORHOLD","PARF_docs"; "PERSONKOMMENTAR","PERS_docs"; "STED","KMZ_files"; "STED_Beskrivelse","STED_docs"}]

but it's NOT a const and a complete mess to look at !

Yeah, it could be implemented with a lot of OTHER methods, but I want it as a Const ;-))

How to do the declaring as a Const ?
Why does the normal split line sign ( space+underscore) NOT work here ?

2 questions = 2 answers ;-))

[June7]

Cross-post https://access-programmers.co.uk/for...d.php?t=302885

[ksor]

I would like to declare a multidimensional const of 11 pairs of 2 strings, but oh it hurt to find out how !

I can get this to work:

Dim MainFolders As String
MainFolders = [{"BILLEDE","IMG_files"; "BO_KOMMENTAR","BO_docs"; "DELTOG_I","GUEST_docs"; "GENST_KOMMENTAR","GENST_docs"; "NOTATER","NOTAT_docs"; "PARFORHOLD","PARF_docs"; "PERSONKOMMENTAR","PERS_docs"; "STED","KMZ_files"; "STED_Beskrivelse","STED_docs"}]

but it's NOT a const and a complete mess to look at !

Yeah, it could be implemented with a lot of OTHER methods, but I want it as a Const ;-))

How to do the declaring as a Const ?
Why does the normal split line sign ( space+underscore) NOT work here ?

2 questions = 2 answers ;-))

... and ?

I'll have to search around where I can get an answer ...

[ssanfu]

Please read this about cross-posting https://www.excelguru.ca/content.php...-cross-posters


You have a solution on access-programmers.......

[ksor]

Please read this about cross-posting https://www.excelguru.ca/content.php...-cross-posters


You have a solution on access-programmers.......

Why not just link to the solution instead of linking to a "doctors degree in Xposting" ?

[ssanfu]

Why should I post a link to the solution in the other forum you posted in?
It is OK to post in multiple forums; the point is that it is polite to post the links to the forums where you cross-posted so we don't waste our time.


Good luck with your project.......

[Missinglinq]

Why not just link to the solution instead of linking to a "doctors degree in Xposting" ?

Because he's trying to teach you about forum etiquette and courtesy...something you really should be aware of considering your time here and on other forums.

Linq ;0)>

[ksor]

Get yourself some bigger shoes !