Afin.VBA   AfinScript AFIN 2016
  Start: [F5] or [Ctrl+Q]
<<< Parameters   Info: 5 columns (A:E = 'COCPI..T') from the #11 row are reserved for the AfinScript's program.
e.g. Path = C:\AnyPath      
e.g. Database =        
e.g. Period =        
()        
         
         
Class (Vendor) Object Command Parameters Info The rest: Comments, calculations, row parameters
Afin.VBA commands       .
.        
USING A BUILT-IN AfinScript FUNCTIONS       .
Afin.VBA {if ommitted - AfinScript.xlam} GETDATATEXT arg1=https://www.castorama.pl/produkty/wykonczenie/malowanie/farby-wewnetrzne/farby-biale/farba-lateksowa-alpina-kuchnia-i-lazienka-baza-3-transparentna-2-35-l.html#product;
arg2=xxx;
arg3=content=".{1,10}[0-9][0-9];
arg4=content=";
PasteTo=DataSheet!b2; Clear=3
. If formula text exceeds Excel's formula length limit you can split it as follows:
="1# part of the formula or text value" & ", next part" & ", next part" & ", next part"
Afin.VBA        
.        
Custom
VBA macros
      .
Afin.VBA C:\AnyPath\MyWorkbookWithMacros.xlsm Info   OK, but it stops the program.
Afin.VBA C:\AnyPath\MyWorkbookWithMacros.xlsm Makro0Arg   .
Afin.VBA C:\AnyPath\MyWorkbookWithMacros.xlsm Makro1Arg Arg1=AnyValueTextOrNumber .
Afin.VBA C:\AnyPath\MyWorkbookWithMacros.xlsm Makro2Arg Arg1=20;Arg2=30 .
Afin.VBA C:\AnyPath\MyWorkbookWithMacros.xlsm Makro3Arg Arg1=20;Arg2=30;Arg3=40 .
Afin.VBA C:\AnyPath\LibrariesVBA\SpeechLib.xlsm Speak Arg1=The End  
.        
Custom
VBA functions
      .
Afin.VBA C:\AnyPath\PlikMakrVBA.xlsm SQUARED Arg1=5;PasteTo=MySheet3!D4 .
Afin.VBA C:\AnyPath\FileScriptingObjectsVbaMacros.xlsm GetFileDateTime Arg1=C:\MyPath\MyFile.xlsx; PasteTo=MySheet3!F5  
.        
Other parameters       .
() () () Clear=2;   Clear=0 {Does nothing}
Clear=1 {Clears only specified range}
Clear=2 {Clears the "Current range" (as in VBA)}
Clear=3 {Clears the "UsedRange" (as in VBA) - DEFAULT}
Clear=4 {Deletes the "UsedRange" (as in VBA)}
() () () AddLabels=1;   Used within the function giving a table value, it makes the labels row.
() () () Transpose=1;   Used within the function giving a table value, it transposes the array (the table returned).