Storing the Output of DBQuery directly in Excel?

migro · Post by **migro** » Sun Jun 14, 2009 9:38 pm

Hi there,

is there a posibility to store the output of a database query (like in the sample) directly into a excel spreadsheet, e.g. with DBexec?

Code: Select all

//Connect to Datasource
Let>str=Driver={MySQL ODBC 3.51 Driver};Server=someserver.com;Port=3306;Database=example;User=admin;Password=xxxx;Option=3;
DBConnect>str,dbH
 
//Perform SELECT query
Let>SQL=select * from customers where custID='abc123'
DBQuery>dbh,SQL,CUSTOMERS,numrecs,numfields
 
//loop through returned recordset
Let>r=0
Repeat>r
Let>r=r+1
Let>f=0
Repeat>f
  Let>f=f+1
  Let>this_field=CUSTOMERS_%r%_%f%
   Message>this_field

  Wait>0.5
Until>f=numfields
Until>r=numrecs
 
//Close database connection
DBClose>dbH

It would be nice if anyone can extend the sample to show how it should be done. If there is a possibility to do this anyhow

Thanks in advance.

JRL · Post by **JRL** » Wed Jul 01, 2009 4:41 am

I also needed to know how to write to an excel file. The following example does not extend your sample but it might be enough information for you to figure your situation out.

I'm not particularly experienced with SQL so that part was a challenge for me. The read example was on the forum HERE. I used that and a little Googling to figure out how to "Insert".

If you run the following script as-is, be aware that it will create two version 97/2003 excel files on your desktop.

Hope this is helpful.

If you have Macro Scheduler version 11, the dialog color scheme in the following script is from around 1985... give or take a few years.

Code: Select all

Dialog>Dialog1
   Caption=Please Read
   Width=600
   Height=220
   Top=100
   Left=CENTER
   Button=Ok,262,160,75,25,2
   Label=Stop and examine the two test.xls files%CRLF%that should now be on your desktop.%CRLF%%CRLF%Notice test2.xls contains only headers%CRLF%"A" "B"  and "C"%CRLF%%CRLF%Be sure to close both files then pick Ok,45,12,true
EndDialog>Dialog1

SetDialogObjectColor>Dialog1,,0
SetDialogObjectFont>Dialog1,mslabel1,Terminal,12,0,1234567

Let>WLN_NOCRLF=0
IfFileExists>%desktop_dir%\test1.xls
Else
Let>File1=0M8R4KGxGuEAAAAAAAAAAAAAAAAAAAAAPgADAP7/CQAGAAAAAAAAAAAAAAABAAAAAQAAAAAAAAAAEAAAHQAAAAEAAAD+////AAAAAAAAAAD////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////9////IAAAAAMAAAAEAAAABQAAAAYAAAAHAAAACAAAAAkAAAAKAAAACwAAAAwAAAANAAAADgAAAA8AAAAQAAAAEQAAABIAAAATAAAAFAAAABUAAAAWAAAAFwAAABgAAAAZAAAAGgAAABsAAAAcAAAA/v////7///8fAAAA/v////7//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////1IAbwBvAHQAIABFAG4AdAByAHkAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAWAAUA//////////8CAAAAIAgCAAAAAADAAAAAAAAARgAAAAAqupDT2tTJASAzQnPN+ckBHgAAAMACAAAAAAAAVwBvAHIAawBiAG8AbwBrAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABIAAgEEAAAA//////////8AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACAAAAIjQAAAAAAAAFAFMAdQBtAG0AYQByAHkASQBuAGYAbwByAG0AYQB0AGkAbwBuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAKAACAQEAAAADAAAA/////wAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAADQAAAAAAAAAAUARABvAGMAdQBtAGUAbgB0AFMAdQBtAG0AYQByAHkASQBuAGYAbwByAG0AYQB0AGkAbwBuAAAAAAAAAAAAAAA4AAIB////////////////AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABAAAAAgBAAAAAAAACQgQAAAGBQCpH80HyQABAAYEAADhAAIAsATBAAIAAADiAAAAXABwAAUAAGRpY2tsICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBCAAIAsARhAQIAAADAAQAAPQEGAAEAAgADAJwAAgAQABkAAgAAABIAAgAAABMAAgAAAK8BAgAAALwBAgAAAD0AEgB4AFoAUEZEJTgAAAAAAAEAWAJAAAIAAACNAAIAAAAiAAIAAAAOAAIAAQC3AQIAAADaAAIAAAAxAB4A3AAAAAgAkAEAAAACAIIHAUMAYQBsAGkAYgByAGkAMQAeANwAAAAIAJABAAAAAgCCBwFDAGEAbABpAGIAcgBpADEAHgDcAAAACACQAQAAAAIAggcBQwBhAGwAaQBiAHIAaQAxAB4A3AAAAAgAkAEAAAACAIIHAUMAYQBsAGkAYgByAGkAMQAeANwAAAAIAJABAAAAAgCCBwFDAGEAbABpAGIAcgBpADEAHgBoAQEAOAC8AgAAAAIAggcBQwBhAG0AYgByAGkAYQAxAB4ALAEBADgAvAIAAAACAIIHAUMAYQBsAGkAYgByAGkAMQAeAAQBAQA4ALwCAAAAAgCCBwFDAGEAbABpAGIAcgBpADEAHgDcAAEAOAC8AgAAAAIAggcBQwBhAGwAaQBiAHIAaQAxAB4A3AAAABEAkAEAAAACAIIHAUMAYQBsAGkAYgByAGkAMQAeANwAAAAUAJABAAAAAgCCBwFDAGEAbABpAGIAcgBpADEAHgDcAAAAPACQAQAAAAIAggcBQwBhAGwAaQBiAHIAaQAxAB4A3AAAAD4AkAEAAAACAIIHAUMAYQBsAGkAYgByAGkAMQAeANwAAQA/ALwCAAAAAgCCBwFDAGEAbABpAGIAcgBpADEAHgDcAAEANAC8AgAAAAIAggcBQwBhAGwAaQBiAHIAaQAxAB4A3AAAADQAkAEAAAACAIIHAUMAYQBsAGkAYgByAGkAMQAeANwAAQAJALwCAAAAAgCCBwFDAGEAbABpAGIAcgBpADEAHgDcAAAACgCQAQAAAAIAggcBQwBhAGwAaQBiAHIAaQAxAB4A3AACABcAkAEAAAACAIIHAUMAYQBsAGkAYgByAGkAMQAeANwAAQAIALwCAAAAAgCCBwFDAGEAbABpAGIAcgBpADEAHgDcAAAACQCQAQAAAAIAggcBQwBhAGwAaQBiAHIAaQAeBBwABQAXAAAiJCIjLCMjMF8pO1woIiQiIywjIzBcKR4EIQAGABwAACIkIiMsIyMwXyk7W1JlZF1cKCIkIiMsIyMwXCkeBCIABwAdAAAiJCIjLCMjMC4wMF8pO1woIiQiIywjIzAuMDBcKR4EJwAIACIAACIkIiMsIyMwLjAwXyk7W1JlZF1cKCIkIiMsIyMwLjAwXCkeBDcAKgAyAABfKCIkIiogIywjIzBfKTtfKCIkIiogXCgjLCMjMFwpO18oIiQiKiAiLSJfKTtfKEBfKR4ELgApACkAAF8oKiAjLCMjMF8pO18oKiBcKCMsIyMwXCk7XygqICItIl8pO18oQF8pHgQ/ACwAOgAAXygiJCIqICMsIyMwLjAwXyk7XygiJCIqIFwoIywjIzAuMDBcKTtfKCIkIiogIi0iPz9fKTtfKEBfKR4ENgArADEAAF8oKiAjLCMjMC4wMF8pO18oKiBcKCMsIyMwLjAwXCk7XygqICItIj8/Xyk7XyhAXyngABQAAAAAAPX/IAAAAAAAAAAAAAAAwCDgABQABQAAAPX/IAAA9AAAAAAAAAAAwCDgABQABQAAAPX/IAAA9AAAAAAAAAAAwCDgABQABQAAAPX/IAAA9AAAAAAAAAAAwCDgABQABQAAAPX/IAAA9AAAAAAAAAAAwCDgABQABQAAAPX/IAAA9AAAAAAAAAAAwCDgABQABQAAAPX/IAAA9AAAAAAAAAAAwCDgABQABQAAAPX/IAAA9AAAAAAAAAAAwCDgABQABQAAAPX/IAAA9AAAAAAAAAAAwCDgABQABQAAAPX/IAAA9AAAAAAAAAAAwCDgABQABQAAAPX/IAAA9AAAAAAAAAAAwCDgABQABQAAAPX/IAAA9AAAAAAAAAAAwCDgABQABQAAAPX/IAAA9AAAAAAAAAAAwCDgABQABQAAAPX/IAAA9AAAAAAAAAAAwCDgABQABQAAAPX/IAAA9AAAAAAAAAAAwCDgABQAAAAAAAEAIAAAAAAAAAAAAAACwCDgABQABQAAAPX/IAAAtAAAAAAAAAAEnyDgABQABQAAAPX/IAAAtAAAAAAAAAAErSDgABQABQAAAPX/IAAAtAAAAAAAAAAEqiDgABQABQAAAPX/IAAAtAAAAAAAAAAEriDgABQABQAAAPX/IAAAtAAAAAAAAAAEmyDgABQABQAAAPX/IAAAtAAAAAAAAAAEryDgABQABQAAAPX/IAAAtAAAAAAAAAAErCDgABQABQAAAPX/IAAAtAAAAAAAAAAEnSDgABQABQAAAPX/IAAAtAAAAAAAAAAEiyDgABQABQAAAPX/IAAAtAAAAAAAAAAEriDgABQABQAAAPX/IAAAtAAAAAAAAAAErCDgABQABQAAAPX/IAAAtAAAAAAAAAAEsyDgABQAFQAAAPX/IAAAtAAAAAAAAAAEniDgABQAFQAAAPX/IAAAtAAAAAAAAAAEnSDgABQAFQAAAPX/IAAAtAAAAAAAAAAEiyDgABQAFQAAAPX/IAAAtAAAAAAAAAAEpCDgABQAFQAAAPX/IAAAtAAAAAAAAAAEsSDgABQAFQAAAPX/IAAAtAAAAAAAAAAEtCDgABQAFQAAAPX/IAAAtAAAAAAAAAAEviDgABQAFQAAAPX/IAAAtAAAAAAAAAAEiiDgABQAFQAAAPX/IAAAtAAAAAAAAAAEuSDgABQAFQAAAPX/IAAAtAAAAAAAAAAEpCDgABQAFQAAAPX/IAAAtAAAAAAAAAAEsSDgABQAFQAAAPX/IAAAtAAAAAAAAAAEtSDgABQACwAAAPX/IAAAtAAAAAAAAAAErSDgABQADwAAAPX/IAAAlBERlwuXCwAEliDgABQAEQAAAPX/IAAAlGZmvx+/HwAEtyDgABQABQArAPX/IAAA+AAAAAAAAAAAwCDgABQABQApAPX/IAAA+AAAAAAAAAAAwCDgABQABQAsAPX/IAAA+AAAAAAAAAAAwCDgABQABQAqAPX/IAAA+AAAAAAAAAAAwCDgABQAEwAAAPX/IAAA9AAAAAAAAAAAwCDgABQACgAAAPX/IAAAtAAAAAAAAAAEqiDgABQABwAAAPX/IAAA1ABQAAAAHwAAwCDgABQACAAAAPX/IAAA1ABQAAAACwAAwCDgABQACQAAAPX/IAAA1AAgAAAADwAAwCDgABQACQAAAPX/IAAA9AAAAAAAAAAAwCDgABQADQAAAPX/IAAAlBERlwuXCwAEryDgABQAEAAAAPX/IAAA1ABgAAAAGgAAwCDgABQADAAAAPX/IAAAtAAAAAAAAAAEqyDgABQABQAAAPX/IAAAnBERFgsWCwAEmiDgABQADgAAAPX/IAAAlBERvx+/HwAEliDgABQABQAJAPX/IAAA+AAAAAAAAAAAwCDgABQABgAAAPX/IAAA9AAAAAAAAAAAwCDgABQAFAAAAPX/IAAA1ABhAAA+HwAAwCDgABQAEgAAAPX/IAAA9AAAAAAAAAAAwCB8CBQAfAgAAAAAAAAAAAAAAAA+ADrftrt9CC0AfQgAAAAAAAAAAAAAAAAAAAAAAgANABQAAwAAAAEAAAAwMFwpO18oKg4ABQACfQgtAH0IAAAAAAAAAAAAAAAAAQAAAAIADQAUAAMAAAABAAAAMDBcKTtfKCoOAAUAAn0ILQB9CAAAAAAAAAAAAAAAAAIAAAACAA0AFAADAAAAAQAAADAwXCk7XygqDgAFAAJ9CC0AfQgAAAAAAAAAAAAAAAADAAAAAgANABQAAwAAAAEAAAAwMFwpO18oKg4ABQACfQgtAH0IAAAAAAAAAAAAAAAABAAAAAIADQAUAAMAAAABAAAAMDBcKTtfKCoOAAUAAn0ILQB9CAAAAAAAAAAAAAAAAAUAAAACAA0AFAADAAAAAQAAADAwXCk7XygqDgAFAAJ9CC0AfQgAAAAAAAAAAAAAAAAGAAAAAgANABQAAwAAAAEAAAAwMFwpO18oKg4ABQACfQgtAH0IAAAAAAAAAAAAAAAABwAAAAIADQAUAAMAAAABAAAAMDBcKTtfKCoOAAUAAn0ILQB9CAAAAAAAAAAAAAAAAAgAAAACAA0AFAADAAAAAQAAADAwXCk7XygqDgAFAAJ9CC0AfQgAAAAAAAAAAAAAAAAJAAAAAgANABQAAwAAAAEAAAAwMFwpO18oKg4ABQACfQgtAH0IAAAAAAAAAAAAAAAACgAAAAIADQAUAAMAAAABAAAAMDBcKTtfKCoOAAUAAn0ILQB9CAAAAAAAAAAAAAAAAAsAAAACAA0AFAADAAAAAQAAADAwXCk7XygqDgAFAAJ9CC0AfQgAAAAAAAAAAAAAAAAMAAAAAgANABQAAwAAAAEAAAAwMFwpO18oKg4ABQACfQgtAH0IAAAAAAAAAAAAAAAADQAAAAIADQAUAAMAAAABAAAAMDBcKTtfKCoOAAUAAn0ILQB9CAAAAAAAAAAAAAAAAA4AAAACAA0AFAADAAAAAQAAADAwXCk7XygqDgAFAAJ9CC0AfQgAAAAAAAAAAAAAAAAPAAAAAgANABQAAwAAAAEAAAAwMFwpO18oKg4ABQACfQhBAH0IAAAAAAAAAAAAAAAAEAAAAAMADQAUAAMAAAABAAAAMDBcKTtfKCoOAAUAAgQAFAADAGVmBAAAADtfKEBfKSAgfQhBAH0IAAAAAAAAAAAAAAAAEQAAAAMADQAUAAMAAAABAAAAMDBcKTtfKCoOAAUAAgQAFAADAGVmBQAAADtfKEBfKSAgfQhBAH0IAAAAAAAAAAAAAAAAEgAAAAMADQAUAAMAAAABAAAAMDBcKTtfKCoOAAUAAgQAFAADAGVmBgAAADtfKEBfKSAgfQhBAH0IAAAAAAAAAAAAAAAAEwAAAAMADQAUAAMAAAABAAAAMDBcKTtfKCoOAAUAAgQAFAADAGVmBwAAADtfKEBfKSAgfQhBAH0IAAAAAAAAAAAAAAAAFAAAAAMADQAUAAMAAAABAAAAMDBcKTtfKCoOAAUAAgQAFAADAGVmCAAAADtfKEBfKSAgfQhBAH0IAAAAAAAAAAAAAAAAFQAAAAMADQAUAAMAAAABAAAAMDBcKTtfKCoOAAUAAgQAFAADAGVmCQAAADtfKEBfKSAgfQhBAH0IAAAAAAAAAAAAAAAAFgAAAAMADQAUAAMAAAABAAAAMDBcKTtfKCoOAAUAAgQAFAADAMxMBAAAADtfKEBfKSAgfQhBAH0IAAAAAAAAAAAAAAAAFwAAAAMADQAUAAMAAAABAAAAMDBcKTtfKCoOAAUAAgQAFAADAMxMBQAAADtfKEBfKSAgfQhBAH0IAAAAAAAAAAAAAAAAGAAAAAMADQAUAAMAAAABAAAAMDBcKTtfKCoOAAUAAgQAFAADAMxMBgAAADtfKEBfKSAgfQhBAH0IAAAAAAAAAAAAAAAAGQAAAAMADQAUAAMAAAABAAAAMDBcKTtfKCoOAAUAAgQAFAADAMxMBwAAADtfKEBfKSAgfQhBAH0IAAAAAAAAAAAAAAAAGgAAAAMADQAUAAMAAAABAAAAMDBcKTtfKCoOAAUAAgQAFAADAMxMCAAAADtfKEBfKSAgfQhBAH0IAAAAAAAAAAAAAAAAGwAAAAMADQAUAAMAAAABAAAAMDBcKTtfKCoOAAUAAgQAFAADAMxMCQAAADtfKEBfKSAgfQhBAH0IAAAAAAAAAAAAAAAAHAAAAAMADQAUAAMAAAAAAAAAMDBcKTtfKCoOAAUAAgQAFAADADIzBAAAADtfKEBfKSAgfQhBAH0IAAAAAAAAAAAAAAAAHQAAAAMADQAUAAMAAAAAAAAAMDBcKTtfKCoOAAUAAgQAFAADADIzBQAAADtfKEBfKSAgfQhBAH0IAAAAAAAAAAAAAAAAHgAAAAMADQAUAAMAAAAAAAAAMDBcKTtfKCoOAAUAAgQAFAADADIzBgAAADtfKEBfKSAgfQhBAH0IAAAAAAAAAAAAAAAAHwAAAAMADQAUAAMAAAAAAAAAMDBcKTtfKCoOAAUAAgQAFAADADIzBwAAADtfKEBfKSAgfQhBAH0IAAAAAAAAAAAAAAAAIAAAAAMADQAUAAMAAAAAAAAAMDBcKTtfKCoOAAUAAgQAFAADADIzCAAAADtfKEBfKSAgfQhBAH0IAAAAAAAAAAAAAAAAIQAAAAMADQAUAAMAAAAAAAAAMDBcKTtfKCoOAAUAAgQAFAADADIzCQAAADtfKEBfKSAgfQhBAH0IAAAAAAAAAAAAAAAAIgAAAAMADQAUAAMAAAAAAAAAMDBcKTtfKCoOAAUAAgQAFAADAAAABAAAADtfKEBfKSAgfQhBAH0IAAAAAAAAAAAAAAAAIwAAAAMADQAUAAMAAAAAAAAAMDBcKTtfKCoOAAUAAgQAFAADAAAABQAAADtfKEBfKSAgfQhBAH0IAAAAAAAAAAAAAAAAJAAAAAMADQAUAAMAAAAAAAAAMDBcKTtfKCoOAAUAAgQAFAADAAAABgAAADtfKEBfKSAgfQhBAH0IAAAAAAAAAAAAAAAAJQAAAAMADQAUAAMAAAAAAAAAMDBcKTtfKCoOAAUAAgQAFAADAAAABwAAADtfKEBfKSAgfQhBAH0IAAAAAAAAAAAAAAAAJgAAAAMADQAUAAMAAAAAAAAAMDBcKTtfKCoOAAUAAgQAFAADAAAACAAAADtfKEBfKSAgfQhBAH0IAAAAAAAAAAAAAAAAJwAAAAMADQAUAAMAAAAAAAAAMDBcKTtfKCoOAAUAAgQAFAADAAAACQAAADtfKEBfKSAgfQhBAH0IAAAAAAAAAAAAAAAAKAAAAAMADQAUAAIAAACcAAb/MDBcKTtfKCoOAAUAAgQAFAACAAAA/8fO/ztfKEBfKSAgfQiRAH0IAAAAAAAAAAAAAAAAKQAAAAcADQAUAAIAAAD6fQD/MDBcKTtfKCoOAAUAAgQAFAACAAAA8vLy/ztfKEBfKSAgBwAUAAIAAAB/f3//ICAgICAgICAIABQAAgAAAH9/f/8gICAgICAgIAkAFAACAAAAf39//wAAAAAAAAAACgAUAAIAAAB/f3//AAAAAAAAAAB9CJEAfQgAAAAAAAAAAAAAAAAqAAAABwANABQAAwAAAAAAAAAwMFwpO18oKg4ABQACBAAUAAIAAAClpaX/O18oQF8pICAHABQAAgAAAD8/P/8gICAgICAgIAgAFAACAAAAPz8//yAgICAgICAgCQAUAAIAAAA/Pz//AAAAAAAAAAAKABQAAgAAAD8/P/8AAAAAAAAAAH0ILQB9CAAAAAAAAAAAAAAAACsAAAACAA0AFAADAAAAAQAAADAwXCk7XygqDgAFAAJ9CC0AfQgAAAAAAAAAAAAAAAAsAAAAAgANABQAAwAAAAEAAAAwMFwpO18oKg4ABQACfQgtAH0IAAAAAAAAAAAAAAAALQAAAAIADQAUAAMAAAABAAAAMDBcKTtfKCoOAAUAAn0ILQB9CAAAAAAAAAAAAAAAAC4AAAACAA0AFAADAAAAAQAAADAwXCk7XygqDgAFAAJ9CC0AfQgAAAAAAAAAAAAAAAAvAAAAAgANABQAAgAAAH9/f/8wMFwpO18oKg4ABQACfQhBAH0IAAAAAAAAAAAAAAAAMAAAAAMADQAUAAIAAAAAYQD/MDBcKTtfKCoOAAUAAgQAFAACAAAAxu/O/ztfKEBfKSAgfQhBAH0IAAAAAAAAAAAAAAAAMQAAAAMADQAUAAMAAAADAAAAMDBcKTtfKCoOAAUAAggAFAADAAAABAAAADtfKEBfKSAgfQhBAH0IAAAAAAAAAAAAAAAAMgAAAAMADQAUAAMAAAADAAAAMDBcKTtfKCoOAAUAAggAFAADAP8/BAAAADtfKEBfKSAgfQhBAH0IAAAAAAAAAAAAAAAAMwAAAAMADQAUAAMAAAADAAAAMDBcKTtfKCoOAAUAAggAFAADADIzBAAAADtfKEBfKSAgfQgtAH0IAAAAAAAAAAAAAAAANAAAAAIADQAUAAMAAAADAAAAMDBcKTtfKCoOAAUAAn0IkQB9CAAAAAAAAAAAAAAAADUAAAAHAA0AFAACAAAAPz92/zAwXCk7XygqDgAFAAIEABQAAgAAAP/Mmf87XyhAXykgIAcAFAACAAAAf39//yAgICAgICAgCAAUAAIAAAB/f3//ICAgICAgICAJABQAAgAAAH9/f/8AAAAAAAAAAAoAFAACAAAAf39//wAAAAAAAAAAfQhBAH0IAAAAAAAAAAAAAAAANgAAAAMADQAUAAIAAAD6fQD/MDBcKTtfKCoOAAUAAggAFAACAAAA/4AB/ztfKEBfKSAgfQhBAH0IAAAAAAAAAAAAAAAANwAAAAMADQAUAAIAAACcZQD/MDBcKTtfKCoOAAUAAgQAFAACAAAA/+uc/ztfKEBfKSAgfQiRAH0IAAAAAAAAAAAAAAAAOAAAAAcADQAUAAMAAAABAAAAMDBcKTtfKCoOAAUAAgQAFAACAAAA///M/ztfKEBfKSAgBwAUAAIAAACysrL/ICAgICAgICAIABQAAgAAALKysv8gICAgICAgIAkAFAACAAAAsrKy/wAAAAAAAAAACgAUAAIAAACysrL/AAAAAAAAAAB9CJEAfQgAAAAAAAAAAAAAAAA5AAAABwANABQAAgAAAD8/P/8wMFwpO18oKg4ABQACBAAUAAIAAADy8vL/O18oQF8pICAHABQAAgAAAD8/P/8gICAgICAgIAgAFAACAAAAPz8//yAgICAgICAgCQAUAAIAAAA/Pz//AAAAAAAAAAAKABQAAgAAAD8/P/8AAAAAAAAAAH0ILQB9CAAAAAAAAAAAAAAAADoAAAACAA0AFAADAAAAAQAAADAwXCk7XygqDgAFAAJ9CC0AfQgAAAAAAAAAAAAAAAA7AAAAAgANABQAAwAAAAMAAAAwMFwpO18oKg4ABQABfQhVAH0IAAAAAAAAAAAAAAAAPAAAAAQADQAUAAMAAAABAAAAMDBcKTtfKCoOAAUAAgcAFAADAAAABAAAADtfKEBfKSAgCAAUAAMAAAAEAAAAICAgICAgICB9CC0AfQgAAAAAAAAAAAAAAAA9AAAAAgANABQAAgAAAP8AAP8wMFwpO18oKg4ABQACkwISABAADQAAMjAlIC0gQWNjZW50MZIITQCSCAAAAAAAAAAAAAABBB7/DQAyADAAJQAgAC0AIABBAGMAYwBlAG4AdAAxAAAAAwABAAwABwRlZtvl8f8FAAwABwEAAAAAAP8lAAUAApMCEgARAA0AADIwJSAtIEFjY2VudDKSCE0AkggAAAAAAAAAAAAAAQQi/w0AMgAwACUAIAAtACAAQQBjAGMAZQBuAHQAMgAAAAMAAQAMAAcFZWby3dz/BQAMAAcBAAAAAAD/JQAFAAKTAhIAEgANAAAyMCUgLSBBY2NlbnQzkghNAJIIAAAAAAAAAAAAAAEEJv8NADIAMAAlACAALQAgAEEAYwBjAGUAbgB0ADMAAAADAAEADAAHBmVm6vHd/wUADAAHAQAAAAAA/yUABQACkwISABMADQAAMjAlIC0gQWNjZW50NJIITQCSCAAAAAAAAAAAAAABBCr/DQAyADAAJQAgAC0AIABBAGMAYwBlAG4AdAA0AAAAAwABAAwABwdlZuXg7P8FAAwABwEAAAAAAP8lAAUAApMCEgAUAA0AADIwJSAtIEFjY2VudDWSCE0AkggAAAAAAAAAAAAAAQQu/w0AMgAwACUAIAAtACAAQQBjAGMAZQBuAHQANQAAAAMAAQAMAAcIZWbb7vP/BQAMAAcBAAAAAAD/JQAFAAKTAhIAFQANAAAyMCUgLSBBY2NlbnQ2kghNAJIIAAAAAAAAAAAAAAEEMv8NADIAMAAlACAALQAgAEEAYwBjAGUAbgB0ADYAAAADAAEADAAHCWVm/enZ/wUADAAHAQAAAAAA/yUABQACkwISABYADQAANDAlIC0gQWNjZW50MZIITQCSCAAAAAAAAAAAAAABBB//DQA0ADAAJQAgAC0AIABBAGMAYwBlAG4AdAAxAAAAAwABAAwABwTMTLjM5P8FAAwABwEAAAAAAP8lAAUAApMCEgAXAA0AADQwJSAtIEFjY2VudDKSCE0AkggAAAAAAAAAAAAAAQQj/w0ANAAwACUAIAAtACAAQQBjAGMAZQBuAHQAMgAAAAMAAQAMAAcFzEzmubj/BQAMAAcBAAAAAAD/JQAFAAKTAhIAGAANAAA0MCUgLSBBY2NlbnQzkghNAJIIAAAAAAAAAAAAAAEEJ/8NADQAMAAlACAALQAgAEEAYwBjAGUAbgB0ADMAAAADAAEADAAHBsxM1+S8/wUADAAHAQAAAAAA/yUABQACkwISABkADQAANDAlIC0gQWNjZW50NJIITQCSCAAAAAAAAAAAAAABBCv/DQA0ADAAJQAgAC0AIABBAGMAYwBlAG4AdAA0AAAAAwABAAwABwfMTMzA2v8FAAwABwEAAAAAAP8lAAUAApMCEgAaAA0AADQwJSAtIEFjY2VudDWSCE0AkggAAAAAAAAAAAAAAQQv/w0ANAAwACUAIAAtACAAQQBjAGMAZQBuAHQANQAAAAMAAQAMAAcIzEy23ej/BQAMAAcBAAAAAAD/JQAFAAKTAhIAGwANAAA0MCUgLSBBY2NlbnQ2kghNAJIIAAAAAAAAAAAAAAEEM/8NADQAMAAlACAALQAgAEEAYwBjAGUAbgB0ADYAAAADAAEADAAHCcxM/NW0/wUADAAHAQAAAAAA/yUABQACkwISABwADQAANjAlIC0gQWNjZW50MZIITQCSCAAAAAAAAAAAAAABBCD/DQA2ADAAJQAgAC0AIABBAGMAYwBlAG4AdAAxAAAAAwABAAwABwQyM5Wz1/8FAAwABwAAAP////8lAAUAApMCEgAdAA0AADYwJSAtIEFjY2VudDKSCE0AkggAAAAAAAAAAAAAAQQk/w0ANgAwACUAIAAtACAAQQBjAGMAZQBuAHQAMgAAAAMAAQAMAAcFMjPZl5X/BQAMAAcAAAD/////JQAFAAKTAhIAHgANAAA2MCUgLSBBY2NlbnQzkghNAJIIAAAAAAAAAAAAAAEEKP8NADYAMAAlACAALQAgAEEAYwBjAGUAbgB0ADMAAAADAAEADAAHBjIzwtaa/wUADAAHAAAA/////yUABQACkwISAB8ADQAANjAlIC0gQWNjZW50NJIITQCSCAAAAAAAAAAAAAABBCz/DQA2ADAAJQAgAC0AIABBAGMAYwBlAG4AdAA0AAAAAwABAAwABwcyM7Khx/8FAAwABwAAAP////8lAAUAApMCEgAgAA0AADYwJSAtIEFjY2VudDWSCE0AkggAAAAAAAAAAAAAAQQw/w0ANgAwACUAIAAtACAAQQBjAGMAZQBuAHQANQAAAAMAAQAMAAcIMjOTzd3/BQAMAAcAAAD/////JQAFAAKTAhIAIQANAAA2MCUgLSBBY2NlbnQ2kghNAJIIAAAAAAAAAAAAAAEENP8NADYAMAAlACAALQAgAEEAYwBjAGUAbgB0ADYAAAADAAEADAAHCTIz+sCQ/wUADAAHAAAA/////yUABQACkwIMACIABwAAQWNjZW50MZIIQQCSCAAAAAAAAAAAAAABBB3/BwBBAGMAYwBlAG4AdAAxAAAAAwABAAwABwQAAE+Bvf8FAAwABwAAAP////8lAAUAApMCDAAjAAcAAEFjY2VudDKSCEEAkggAAAAAAAAAAAAAAQQh/wcAQQBjAGMAZQBuAHQAMgAAAAMAAQAMAAcFAADAUE3/BQAMAAcAAAD/////JQAFAAKTAgwAJAAHAABBY2NlbnQzkghBAJIIAAAAAAAAAAAAAAEEJf8HAEEAYwBjAGUAbgB0ADMAAAADAAEADAAHBgAAm7tZ/wUADAAHAAAA/////yUABQACkwIMACUABwAAQWNjZW50NJIIQQCSCAAAAAAAAAAAAAABBCn/BwBBAGMAYwBlAG4AdAA0AAAAAwABAAwABwcAAIBkov8FAAwABwAAAP////8lAAUAApMCDAAmAAcAAEFjY2VudDWSCEEAkggAAAAAAAAAAAAAAQQt/wcAQQBjAGMAZQBuAHQANQAAAAMAAQAMAAcIAABLrMb/BQAMAAcAAAD/////JQAFAAKTAgwAJwAHAABBY2NlbnQ2kghBAJIIAAAAAAAAAAAAAAEEMf8HAEEAYwBjAGUAbgB0ADYAAAADAAEADAAHCQAA95ZG/wUADAAHAAAA/////yUABQACkwIIACgAAwAAQmFkkgg5AJIIAAAAAAAAAAAAAAEBG/8DAEIAYQBkAAAAAwABAAwABf8AAP/Hzv8FAAwABf8AAJwABv8lAAUAApMCEAApAAsAAENhbGN1bGF0aW9ukgiBAJIIAAAAAAAAAAAAAAECFv8LAEMAYQBsAGMAdQBsAGEAdABpAG8AbgAAAAcAAQAMAAX/AADy8vL/BQAMAAX/AAD6fQD/JQAFAAIGAA4ABf8AAH9/f/8BAAcADgAF/wAAf39//wEACAAOAAX/AAB/f3//AQAJAA4ABf8AAH9/f/8BAJMCDwAqAAoAAENoZWNrIENlbGySCH8AkggAAAAAAAAAAAAAAQIX/woAQwBoAGUAYwBrACAAQwBlAGwAbAAAAAcAAQAMAAX/AAClpaX/BQAMAAcAAAD/////JQAFAAIGAA4ABf8AAD8/P/8GAAcADgAF/wAAPz8//wYACAAOAAX/AAA/Pz//BgAJAA4ABf8AAD8/P/8GAJMCBAArgAP/kgggAJIIAAAAAAAAAAAAAAEFA/8FAEMAbwBtAG0AYQAAAAAAkwIEACyABv+SCCgAkggAAAAAAAAAAAAAAQUG/wkAQwBvAG0AbQBhACAAWwAwAF0AAAAAAJMCBAAtgAT/kggmAJIIAAAAAAAAAAAAAAEFBP8IAEMAdQByAHIAZQBuAGMAeQAAAAAAkwIEAC6AB/+SCC4AkggAAAAAAAAAAAAAAQUH/wwAQwB1AHIAcgBlAG4AYwB5ACAAWwAwAF0AAAAAAJMCFQAvABAAAEV4cGxhbmF0b3J5IFRleHSSCEcAkggAAAAAAAAAAAAAAQI1/xAARQB4AHAAbABhAG4AYQB0AG8AcgB5ACAAVABlAHgAdAAAAAIABQAMAAX/AAB/f3//JQAFAAKTAgkAMAAEAABHb29kkgg7AJIIAAAAAAAAAAAAAAEBGv8EAEcAbwBvAGQAAAADAAEADAAF/wAAxu/O/wUADAAF/wAAAGEA/yUABQACkwIOADEACQAASGVhZGluZyAxkghHAJIIAAAAAAAAAAAAAAEDEP8JAEgAZQBhAGQAaQBuAGcAIAAxAAAAAwAFAAwABwMAAB9Jff8lAAUAAgcADgAHBAAAT4G9/wUAkwIOADIACQAASGVhZGluZyAykghHAJIIAAAAAAAAAAAAAAEDEf8JAEgAZQBhAGQAaQBuAGcAIAAyAAAAAwAFAAwABwMAAB9Jff8lAAUAAgcADgAHBP8/qMDe/wUAkwIOADMACQAASGVhZGluZyAzkghHAJIIAAAAAAAAAAAAAAEDEv8JAEgAZQBhAGQAaQBuAGcAIAAzAAAAAwAFAAwABwMAAB9Jff8lAAUAAgcADgAHBDIzlbPX/wIAkwIOADQACQAASGVhZGluZyA0kgg5AJIIAAAAAAAAAAAAAAEDE/8JAEgAZQBhAGQAaQBuAGcAIAA0AAAAAgAFAAwABwMAAB9Jff8lAAUAApMCCgA1AAUAAElucHV0kgh1AJIIAAAAAAAAAAAAAAECFP8FAEkAbgBwAHUAdAAAAAcAAQAMAAX/AAD/zJn/BQAMAAX/AAA/P3b/JQAFAAIGAA4ABf8AAH9/f/8BAAcADgAF/wAAf39//wEACAAOAAX/AAB/f3//AQAJAA4ABf8AAH9/f/8BAJMCEAA2AAsAAExpbmtlZCBDZWxskghLAJIIAAAAAAAAAAAAAAECGP8LAEwAaQBuAGsAZQBkACAAQwBlAGwAbAAAAAMABQAMAAX/AAD6fQD/JQAFAAIHAA4ABf8AAP+AAf8GAJMCDAA3AAcAAE5ldXRyYWySCEEAkggAAAAAAAAAAAAAAQEc/wcATgBlAHUAdAByAGEAbAAAAAMAAQAMAAX/AAD/65z/BQAMAAX/AACcZQD/JQAFAAKTAgQAAIAA/5IIMwCSCAAAAAAAAAAAAAABAQD/BgBOAG8AcgBtAGEAbAAAAAIABQAMAAcBAAAAAAD/JQAFAAKTAgkAOAAEAABOb3RlkghiAJIIAAAAAAAAAAAAAAECCv8EAE4AbwB0AGUAAAAFAAEADAAF/wAA///M/wYADgAF/wAAsrKy/wEABwAOAAX/AACysrL/AQAIAA4ABf8AALKysv8BAAkADgAF/wAAsrKy/wEAkwILADkABgAAT3V0cHV0kgh3AJIIAAAAAAAAAAAAAAECFf8GAE8AdQB0AHAAdQB0AAAABwABAAwABf8AAPLy8v8FAAwABf8AAD8/P/8lAAUAAgYADgAF/wAAPz8//wEABwAOAAX/AAA/Pz//AQAIAA4ABf8AAD8/P/8BAAkADgAF/wAAPz8//wEAkwIEADqABf+SCCQAkggAAAAAAAAAAAAAAQUF/wcAUABlAHIAYwBlAG4AdAAAAAAAkwIKADsABQAAVGl0bGWSCDEAkggAAAAAAAAAAAAAAQMP/wUAVABpAHQAbABlAAAAAgAFAAwABwMAAB9Jff8lAAUAAZMCCgA8AAUAAFRvdGFskghNAJIIAAAAAAAAAAAAAAEDGf8FAFQAbwB0AGEAbAAAAAQABQAMAAcBAAAAAAD/JQAFAAIGAA4ABwQAAE+Bvf8BAAcADgAHBAAAT4G9/wYAkwIRAD0ADAAAV2FybmluZyBUZXh0kgg/AJIIAAAAAAAAAAAAAAECC/8MAFcAYQByAG4AaQBuAGcAIABUAGUAeAB0AAAAAgAFAAwABf8AAP8AAP8lAAUAAo4IWACOCAAAAAAAAAAAAACQAAAAEQARAFQAYQBiAGwAZQBTAHQAeQBsAGUATQBlAGQAaQB1AG0AOQBQAGkAdgBvAHQAUwB0AHkAbABlAEwAaQBnAGgAdAAxADYAYAECAAAAhQAOAJQuAAAAAAYAU2hlZXQxhQAOABYxAAAAAAYAU2hlZXQyhQAOAJwyAAAAAAYAU2hlZXQzmggYAJoIAAAAAAAAAAAAAAEAAAAAAAAAAgAAAKMIEACjCAAAAAAAAAAAAAAAAAAAjAAEAAEAAQDBAQgAwQEAAGfmAQD8AGEACQAAAAkAAAAHAABDb21wYW55BwAAQ291bnRyeQgAAERpc3RyaWN0CwAAQUJDIFdpZGdldHMDAABVU0EJAABYWVogR29vZHMHAABFbmdsYW5kBgAARG9yc2V0BAAASW93Yf8AEgAIAMstAAAMAAAAHS4AAF4AAABjCBYAYwgAAAAAAAAAAAAAFgAAAAAAAAACAJYIEACWCAAAAAAAAAAAAABC5QEAmwgQAJsIAAAAAAAAAAAAAAEAAACMCBAAjAgAAAAAAAAAAAAAAAAAAAoAAAAJCBAAAAYQAKkfzQfJAAEABgQAAAsCFAAAAAAAAAAAAAMAAACqLwAArDAAAA0AAgABAAwAAgBkAA8AAgABABEAAgAAABAACAD8qfHSTWJQP18AAgABACoAAgAAACsAAgAAAIIAAgABAIAACAAAAAAAAAAAACUCBAAAACwBgQACAMEEFAAAABUAAACDAAIAAACEAAIAAAAmAAgAZmZmZmZm5j8nAAgAZmZmZmZm5j8oAAgAAAAAAAAA6D8pAAgAAAAAAAAA6D+hACIAAAAsAQEAAQABAAQAQuUBADMzMzMzM9M/MzMzMzMz0z9pc5wIJgCcCAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAPDMAAAAAAAAAAFUAAgAIAH0ADAAAAAAASRQPAAIAAAB9AAwAAQABACQWDwACAAAAfQAMAAIAAgBtGQ8AAgAAAAACDgAAAAAAAwAAAAAAAwAAAAgCEAAAAAAAAwAsAQAAAAAAAQ8ACAIQAAEAAAADACwBAAAAAAABDwAIAhAAAgAAAAMALAEAAAAAAAEPAP0ACgAAAAAADwAAAAAA/QAKAAAAAQAPAAEAAAD9AAoAAAACAA8AAgAAAP0ACgABAAAADwADAAAA/QAKAAEAAQAPAAQAAAD9AAoAAQACAA8ACAAAAP0ACgACAAAADwAFAAAA/QAKAAIAAQAPAAYAAAD9AAoAAgACAA8ABwAAANcACgC6AAAAKAAqACoAPgISALYGAAAAAEAAAAAAAAAAAAAAAIsIEACLCAAAAAAAAAAAAAAAAAIAHQAPAAMBAAIAAAABAAEAAQACAmcIFwBnCAAAAAAAAAAAAAACAAH/////A0QAAAoAAAAJCBAAAAYQAKkfzQfJAAEABgQAAAsCEAAAAAAAAAAAAAAAAAAoMgAADQACAAEADAACAGQADwACAAEAEQACAAAAEAAIAPyp8dJNYlA/XwACAAEAKgACAAAAKwACAAAAggACAAEAgAAIAAAAAAAAAAAAJQIEAAAALAGBAAIAwQQUAAAAFQAAAIMAAgAAAIQAAgAAACYACABmZmZmZmbmPycACABmZmZmZmbmPygACAAAAAAAAADoPykACAAAAAAAAADoP6EAIgAAACwBAQABAAEABAACAAH/MzMzMzMz0z8zMzMzMzPTPwAAnAgmAJwIAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA8MwAAAAAAAAAAVQACAAgAAAIOAAAAAAAAAAAAAAAAAAAAPgISALYAAAAAAEAAAAAAAAAAAAAAAIsIEACLCAAAAAAAAAAAAAAAAAIAHQAPAAMAAAAAAAABAAAAAAAAAGcIFwBnCAAAAAAAAAAAAAACAAH/////A0QAAAoAAAAJCBAAAAYQAKkfzQfJAAEABgQAAAsCEAAAAAAAAAAAAAAAAACuMwAADQACAAEADAACAGQADwACAAEAEQACAAAAEAAIAPyp8dJNYlA/XwACAAEAKgACAAAAKwACAAAAggACAAEAgAAIAAAAAAAAAAAAJQIEAAAALAGBAAIAwQQUAAAAFQAAAIMAAgAAAIQAAgAAACYACABmZmZmZmbmPycACABmZmZmZmbmPygACAAAAAAAAADoPykACAAAAAAAAADoP6EAIgAAACwBAQABAAEABAACAAH/MzMzMzMz0z8zMzMzMzPTPwAAnAgmAJwIAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA8MwAAAAAAAAAAVQACAAgAAAIOAAAAAAAAAAAAAAAAAAAAPgISALYAAAAAAEAAAAAAAAAAAAAAAIsIEACLCAAAAAAAAAAAAAAAAAIAHQAPAAMAAAAAAAABAAAAAAAAAGcIFwBnCAAAAAAAAAAAAAACAAH/////A0QAAAoAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQAAAAIAAAADAAAA/v///wUAAAAGAAAABwAAAAgAAAD+////CgAAAP7////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////+/wAABQECAAAAAAAAAAAAAAAAAAAAAAABAAAA4IWf8vlPaBCrkQgAKyez2TAAAACgAAAABwAAAAEAAABAAAAABAAAAEgAAAAIAAAAWAAAABIAAABoAAAADAAAAIAAAAANAAAAjAAAABMAAACYAAAAAgAAAOQEAAAeAAAACAAAAGRpY2tsAAAAHgAAAAgAAABkaWNrbAAAAB4AAAAQAAAATWljcm9zb2Z0IEV4Y2VsAEAAAAAArDjD2tTJAUAAAACAUnvRyvnJAQMAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA/v8AAAUBAgAAAAAAAAAAAAAAAAAAAAAAAQAAAALVzdWcLhsQk5cIACss+a4wAAAA2AAAAAkAAAABAAAAUAAAAA8AAABYAAAAFwAAAGQAAAALAAAAbAAAABAAAAB0AAAAEwAAAHwAAAAWAAAAhAAAAA0AAACMAAAADAAAALUAAAACAAAA5AQAAB4AAAAEAAAAAAAAAAMAAAAAAAwACwAAAAAAAAALAAAAAAAAAAsAAAAAAAAACwAAAAAAAAAeEAAAAwAAAAcAAABTaGVldDEABwAAAFNoZWV0MgAHAAAAU2hlZXQzAAwQAAACAAAAHgAAAAsAAABXb3Jrc2hlZXRzAAMAAAADAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABAP7/AwoAAP////8gCAIAAAAAAMAAAAAAAABGJgAAAE1pY3Jvc29mdCBPZmZpY2UgRXhjZWwgMjAwMyBXb3Jrc2hlZXQABgAAAEJpZmY4AA4AAABFeGNlbC5TaGVldC44APQ5snEAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQBDAG8AbQBwAE8AYgBqAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABIAAgD///////////////8AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAJAAAAcgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAP///////////////wAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA////////////////AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAD///////////////8AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=
Base64>file1,decode,file1
WriteLn>%desktop_dir%\test1.xls,wres,file1
EndIf
IfFileExists>%desktop_dir%\test2.xls
Else
Let>File2=0M8R4KGxGuEAAAAAAAAAAAAAAAAAAAAAPgADAP7/CQAGAAAAAAAAAAAAAAABAAAAKQAAAAAAAAAAEAAA/v///wAAAAD+////AAAAACgAAAD///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////8JCBAAAAYFAOwVzQfJAAEABgMAAOEAAgCwBMEAAgAAAOIAAABcAHAAAgAAICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIEIAAgCwBGEBAgAAAMABAAA9AQYAAQACAAMAnAACAA4AGQACAAAAEgACAAAAEwACAAAArwECAAAAvAECAAAAPQASAPAAaQDVOUofOAAAAAAAAQBYAkAAAgAAAI0AAgAAACIAAgAAAA4AAgABALcBAgAAANoAAgAAADEAHgDcAAAACACQAQAAAAIAbQcBQwBhAGwAaQBiAHIAaQAxAB4A3AAAAAgAkAEAAAACAG0HAUMAYQBsAGkAYgByAGkAMQAeANwAAAAIAJABAAAAAgBtBwFDAGEAbABpAGIAcgBpADEAHgDcAAAACACQAQAAAAIAbQcBQwBhAGwAaQBiAHIAaQAxAB4A3AAAAAgAkAEAAAACAG0HAUMAYQBsAGkAYgByAGkAMQAeANwAAAAIAJABAAAAAgBtBwFDAGEAbABpAGIAcgBpADEAHgDcAAAACQCQAQAAAAIAbQcBQwBhAGwAaQBiAHIAaQAxAB4A3AAAABQAkAEAAAACAG0HAUMAYQBsAGkAYgByAGkAMQAeANwAAQA0ALwCAAAAAgBtBwFDAGEAbABpAGIAcgBpADEAHgDcAAEACQC8AgAAAAIAbQcBQwBhAGwAaQBiAHIAaQAxAB4A3AACABcAkAEAAAACAG0HAUMAYQBsAGkAYgByAGkAMQAeANwAAAARAJABAAAAAgBtBwFDAGEAbABpAGIAcgBpADEAHgAsAQEAOAC8AgAAAAIAbQcBQwBhAGwAaQBiAHIAaQAxAB4ABAEBADgAvAIAAAACAG0HAUMAYQBsAGkAYgByAGkAMQAeANwAAQA4ALwCAAAAAgBtBwFDAGEAbABpAGIAcgBpADEAHgDcAAAAPgCQAQAAAAIAbQcBQwBhAGwAaQBiAHIAaQAxAB4A3AAAADQAkAEAAAACAG0HAUMAYQBsAGkAYgByAGkAMQAeANwAAAA8AJABAAAAAgBtBwFDAGEAbABpAGIAcgBpADEAHgDcAAEAPwC8AgAAAAIAbQcBQwBhAGwAaQBiAHIAaQAxAB4AaAEBADgAvAIAAAACAG0HAUMAYQBtAGIAcgBpAGEAMQAeANwAAQAIALwCAAAAAgBtBwFDAGEAbABpAGIAcgBpADEAHgDcAAAACgCQAQAAAAIAbQcBQwBhAGwAaQBiAHIAaQAeBBwABQAXAAAiJCIjLCMjMF8pO1woIiQiIywjIzBcKR4EIQAGABwAACIkIiMsIyMwXyk7W1JlZF1cKCIkIiMsIyMwXCkeBCIABwAdAAAiJCIjLCMjMC4wMF8pO1woIiQiIywjIzAuMDBcKR4EJwAIACIAACIkIiMsIyMwLjAwXyk7W1JlZF1cKCIkIiMsIyMwLjAwXCkeBDcAKgAyAABfKCIkIiogIywjIzBfKTtfKCIkIiogXCgjLCMjMFwpO18oIiQiKiAiLSJfKTtfKEBfKR4ELgApACkAAF8oKiAjLCMjMF8pO18oKiBcKCMsIyMwXCk7XygqICItIl8pO18oQF8pHgQ/ACwAOgAAXygiJCIqICMsIyMwLjAwXyk7XygiJCIqIFwoIywjIzAuMDBcKTtfKCIkIiogIi0iPz9fKTtfKEBfKR4ENgArADEAAF8oKiAjLCMjMC4wMF8pO18oKiBcKCMsIyMwLjAwXCk7XygqICItIj8/Xyk7XyhAXyngABQAAAAAAPX/IAAAAAAAAAAAAAAAwCDgABQABQAAAPX/IAAAAAAAAAAAAAAAwCDgABQABQAAAPX/IAAAAAAAAAAAAAAAwCDgABQABQAAAPX/IAAAAAAAAAAAAAAAwCDgABQABQAAAPX/IAAAAAAAAAAAAAAAwCDgABQABQAAAPX/IAAAAAAAAAAAAAAAwCDgABQABQAAAPX/IAAAAAAAAAAAAAAAwCDgABQABQAAAPX/IAAAAAAAAAAAAAAAwCDgABQABQAAAPX/IAAAAAAAAAAAAAAAwCDgABQABQAAAPX/IAAAAAAAAAAAAAAAwCDgABQABQAAAPX/IAAAAAAAAAAAAAAAwCDgABQABQAAAPX/IAAAAAAAAAAAAAAAwCDgABQABQAAAPX/IAAAAAAAAAAAAAAAwCDgABQABQAAAPX/IAAAAAAAAAAAAAAAwCDgABQABQAAAPX/IAAAAAAAAAAAAAAAwCDgABQAAAAAAAEAIAAAAAAAAAAAAAACwCDgABQABgAAAPX/IAAAtAAAAAAAAAAEnyDgABQABgAAAPX/IAAAtAAAAAAAAAAErSDgABQABgAAAPX/IAAAtAAAAAAAAAAEqiDgABQABgAAAPX/IAAAtAAAAAAAAAAEriDgABQABgAAAPX/IAAAtAAAAAAAAAAEmyDgABQABgAAAPX/IAAAtAAAAAAAAAAEryDgABQABgAAAPX/IAAAtAAAAAAAAAAErCDgABQABgAAAPX/IAAAtAAAAAAAAAAEnSDgABQABgAAAPX/IAAAtAAAAAAAAAAEiyDgABQABgAAAPX/IAAAtAAAAAAAAAAEriDgABQABgAAAPX/IAAAtAAAAAAAAAAErCDgABQABgAAAPX/IAAAtAAAAAAAAAAEsyDgABQABwAAAPX/IAAAtAAAAAAAAAAEniDgABQABwAAAPX/IAAAtAAAAAAAAAAEnSDgABQABwAAAPX/IAAAtAAAAAAAAAAEiyDgABQABwAAAPX/IAAAtAAAAAAAAAAEpCDgABQABwAAAPX/IAAAtAAAAAAAAAAEsSDgABQABwAAAPX/IAAAtAAAAAAAAAAEtCDgABQABwAAAPX/IAAAtAAAAAAAAAAEviDgABQABwAAAPX/IAAAtAAAAAAAAAAEiiDgABQABwAAAPX/IAAAtAAAAAAAAAAEuSDgABQABwAAAPX/IAAAtAAAAAAAAAAEpCDgABQABwAAAPX/IAAAtAAAAAAAAAAEsSDgABQABwAAAPX/IAAAtAAAAAAAAAAEtSDgABQACAAAAPX/IAAAtAAAAAAAAAAErSDgABQACQAAAPX/IAAAlBERlwuXCwAEliDgABQACgAAAPX/IAAAlGZmvx+/HwAEtyDgABQABQArAPX/IAAA+AAAAAAAAAAAwCDgABQABQApAPX/IAAA+AAAAAAAAAAAwCDgABQABQAsAPX/IAAA+AAAAAAAAAAAwCDgABQABQAqAPX/IAAA+AAAAAAAAAAAwCDgABQACwAAAPX/IAAA9AAAAAAAAAAAwCDgABQADAAAAPX/IAAAtAAAAAAAAAAEqiDgABQADQAAAPX/IAAA1ABQAAAAHwAAwCDgABQADgAAAPX/IAAA1ABQAAAACwAAwCDgABQADwAAAPX/IAAA1AAgAAAADwAAwCDgABQADwAAAPX/IAAA9AAAAAAAAAAAwCDgABQAEAAAAPX/IAAAlBERlwuXCwAEryDgABQAEQAAAPX/IAAA1ABgAAAAGgAAwCDgABQAEgAAAPX/IAAAtAAAAAAAAAAEqyDgABQABQAAAPX/IAAAnBERFgsWCwAEmiDgABQAEwAAAPX/IAAAlBERvx+/HwAEliDgABQABQAJAPX/IAAA+AAAAAAAAAAAwCDgABQAFAAAAPX/IAAA9AAAAAAAAAAAwCDgABQAFQAAAPX/IAAA1ABhAAA+HwAAwCDgABQAFgAAAPX/IAAA9AAAAAAAAAAAwCCTAhIAEAANAAAyMCUgLSBBY2NlbnQxkwISABEADQAAMjAlIC0gQWNjZW50MpMCEgASAA0AADIwJSAtIEFjY2VudDOTAhIAEwANAAAyMCUgLSBBY2NlbnQ0kwISABQADQAAMjAlIC0gQWNjZW50NZMCEgAVAA0AADIwJSAtIEFjY2VudDaTAhIAFgANAAA0MCUgLSBBY2NlbnQxkwISABcADQAANDAlIC0gQWNjZW50MpMCEgAYAA0AADQwJSAtIEFjY2VudDOTAhIAGQANAAA0MCUgLSBBY2NlbnQ0kwISABoADQAANDAlIC0gQWNjZW50NZMCEgAbAA0AADQwJSAtIEFjY2VudDaTAhIAHAANAAA2MCUgLSBBY2NlbnQxkwISAB0ADQAANjAlIC0gQWNjZW50MpMCEgAeAA0AADYwJSAtIEFjY2VudDOTAhIAHwANAAA2MCUgLSBBY2NlbnQ0kwISACAADQAANjAlIC0gQWNjZW50NZMCEgAhAA0AADYwJSAtIEFjY2VudDaTAgwAIgAHAABBY2NlbnQxkwIMACMABwAAQWNjZW50MpMCDAAkAAcAAEFjY2VudDOTAgwAJQAHAABBY2NlbnQ0kwIMACYABwAAQWNjZW50NZMCDAAnAAcAAEFjY2VudDaTAggAKAADAABCYWSTAhAAKQALAABDYWxjdWxhdGlvbpMCDwAqAAoAAENoZWNrIENlbGyTAgQAK4AD/5MCBAAsgAb/kwIEAC2ABP+TAgQALoAH/5MCFQAvABAAAEV4cGxhbmF0b3J5IFRleHSTAgkAMAAEAABHb29kkwIOADEACQAASGVhZGluZyAxkwIOADIACQAASGVhZGluZyAykwIOADMACQAASGVhZGluZyAzkwIOADQACQAASGVhZGluZyA0kwIKADUABQAASW5wdXSTAhAANgALAABMaW5rZWQgQ2VsbJMCDAA3AAcAAE5ldXRyYWyTAgQAAIAA/5MCCQA4AAQAAE5vdGWTAgsAOQAGAABPdXRwdXSTAgQAOoAF/5MCCgA7AAUAAFRpdGxlkwIKADwABQAAVG90YWyTAhEAPQAMAABXYXJuaW5nIFRleHRgAQIAAACFAA4ApSoAAAAABgBTaGVldDGFAA4AkSwAAAAABgBTaGVldDKFAA4AIS4AAAAABgBTaGVldDOMAAQAAQABAMEBCADBAQAAIr4BAPwAFAADAAAAAwAAAAEAAEEBAABCAQAAQ/8ACgAIAOQOAAAMAAAAYwgWAGMIAAAAAAAAAAAAABYAAAAEAAAAAgB8CBQAfAgAAAAAAAAAAAAAAAA+AF/2dkl9CC0AfQgAAAAAAAAAAAAAAAAAAAAAAgANABQAAwAAAAEAAAAwMFwpO18oKg4ABQACfQgtAH0IAAAAAAAAAAAAAAAADwAAAAIADQAUAAMAAAABAAAAMDBcKTtfKCoOAAUAAn0IQQB9CAAAAAAAAAAAAAAAABAAAAADAA0AFAADAAAAAQAAADAwXCk7XygqDgAFAAIEABQAAwBlZgQAAAA7XyhAXykgIH0IQQB9CAAAAAAAAAAAAAAAABEAAAADAA0AFAADAAAAAQAAADAwXCk7XygqDgAFAAIEABQAAwBlZgUAAAA7XyhAXykgIH0IQQB9CAAAAAAAAAAAAAAAABIAAAADAA0AFAADAAAAAQAAADAwXCk7XygqDgAFAAIEABQAAwBlZgYAAAA7XyhAXykgIH0IQQB9CAAAAAAAAAAAAAAAABMAAAADAA0AFAADAAAAAQAAADAwXCk7XygqDgAFAAIEABQAAwBlZgcAAAA7XyhAXykgIH0IQQB9CAAAAAAAAAAAAAAAABQAAAADAA0AFAADAAAAAQAAADAwXCk7XygqDgAFAAIEABQAAwBlZggAAAA7XyhAXykgIH0IQQB9CAAAAAAAAAAAAAAAABUAAAADAA0AFAADAAAAAQAAADAwXCk7XygqDgAFAAIEABQAAwBlZgkAAAA7XyhAXykgIH0IQQB9CAAAAAAAAAAAAAAAABYAAAADAA0AFAADAAAAAQAAADAwXCk7XygqDgAFAAIEABQAAwDMTAQAAAA7XyhAXykgIH0IQQB9CAAAAAAAAAAAAAAAABcAAAADAA0AFAADAAAAAQAAADAwXCk7XygqDgAFAAIEABQAAwDMTAUAAAA7XyhAXykgIH0IQQB9CAAAAAAAAAAAAAAAABgAAAADAA0AFAADAAAAAQAAADAwXCk7XygqDgAFAAIEABQAAwDMTAYAAAA7XyhAXykgIH0IQQB9CAAAAAAAAAAAAAAAABkAAAADAA0AFAADAAAAAQAAADAwXCk7XygqDgAFAAIEABQAAwDMTAcAAAA7XyhAXykgIH0IQQB9CAAAAAAAAAAAAAAAABoAAAADAA0AFAADAAAAAQAAADAwXCk7XygqDgAFAAIEABQAAwDMTAgAAAA7XyhAXykgIH0IQQB9CAAAAAAAAAAAAAAAABsAAAADAA0AFAADAAAAAQAAADAwXCk7XygqDgAFAAIEABQAAwDMTAkAAAA7XyhAXykgIH0IQQB9CAAAAAAAAAAAAAAAABwAAAADAA0AFAADAAAAAAAAADAwXCk7XygqDgAFAAIEABQAAwAyMwQAAAA7XyhAXykgIH0IQQB9CAAAAAAAAAAAAAAAAB0AAAADAA0AFAADAAAAAAAAADAwXCk7XygqDgAFAAIEABQAAwAyMwUAAAA7XyhAXykgIH0IQQB9CAAAAAAAAAAAAAAAAB4AAAADAA0AFAADAAAAAAAAADAwXCk7XygqDgAFAAIEABQAAwAyMwYAAAA7XyhAXykgIH0IQQB9CAAAAAAAAAAAAAAAAB8AAAADAA0AFAADAAAAAAAAADAwXCk7XygqDgAFAAIEABQAAwAyMwcAAAA7XyhAXykgIH0IQQB9CAAAAAAAAAAAAAAAACAAAAADAA0AFAADAAAAAAAAADAwXCk7XygqDgAFAAIEABQAAwAyMwgAAAA7XyhAXykgIH0IQQB9CAAAAAAAAAAAAAAAACEAAAADAA0AFAADAAAAAAAAADAwXCk7XygqDgAFAAIEABQAAwAyMwkAAAA7XyhAXykgIH0IQQB9CAAAAAAAAAAAAAAAACIAAAADAA0AFAADAAAAAAAAADAwXCk7XygqDgAFAAIEABQAAwAAAAQAAAA7XyhAXykgIH0IQQB9CAAAAAAAAAAAAAAAACMAAAADAA0AFAADAAAAAAAAADAwXCk7XygqDgAFAAIEABQAAwAAAAUAAAA7XyhAXykgIH0IQQB9CAAAAAAAAAAAAAAAACQAAAADAA0AFAADAAAAAAAAADAwXCk7XygqDgAFAAIEABQAAwAAAAYAAAA7XyhAXykgIH0IQQB9CAAAAAAAAAAAAAAAACUAAAADAA0AFAADAAAAAAAAADAwXCk7XygqDgAFAAIEABQAAwAAAAcAAAA7XyhAXykgIH0IQQB9CAAAAAAAAAAAAAAAACYAAAADAA0AFAADAAAAAAAAADAwXCk7XygqDgAFAAIEABQAAwAAAAgAAAA7XyhAXykgIH0IQQB9CAAAAAAAAAAAAAAAACcAAAADAA0AFAADAAAAAAAAADAwXCk7XygqDgAFAAIEABQAAwAAAAkAAAA7XyhAXykgIH0IQQB9CAAAAAAAAAAAAAAAACgAAAADAA0AFAACAAAAnAAG/zAwXCk7XygqDgAFAAIEABQAAgAAAP/Hzv87XyhAXykgIH0IkQB9CAAAAAAAAAAAAAAAACkAAAAHAA0AFAACAAAA+n0A/zAwXCk7XygqDgAFAAIEABQAAgAAAPLy8v87XyhAXykgIAcAFAACAAAAf39//yAgICAgICAgCAAUAAIAAAB/f3//ICAgICAgICAJABQAAgAAAH9/f/8AAAAAAAAAAAoAFAACAAAAf39//wAAAAAAAAAAfQiRAH0IAAAAAAAAAAAAAAAAKgAAAAcADQAUAAMAAAAAAAAAMDBcKTtfKCoOAAUAAgQAFAACAAAApaWl/ztfKEBfKSAgBwAUAAIAAAA/Pz//ICAgICAgICAIABQAAgAAAD8/P/8gICAgICAgIAkAFAACAAAAPz8//wAAAAAAAAAACgAUAAIAAAA/Pz//AAAAAAAAAAB9CC0AfQgAAAAAAAAAAAAAAAAvAAAAAgANABQAAgAAAH9/f/8wMFwpO18oKg4ABQACfQhBAH0IAAAAAAAAAAAAAAAAMAAAAAMADQAUAAIAAAAAYQD/MDBcKTtfKCoOAAUAAgQAFAACAAAAxu/O/ztfKEBfKSAgfQhBAH0IAAAAAAAAAAAAAAAAMQAAAAMADQAUAAMAAAADAAAAMDBcKTtfKCoOAAUAAggAFAADAAAABAAAADtfKEBfKSAgfQhBAH0IAAAAAAAAAAAAAAAAMgAAAAMADQAUAAMAAAADAAAAMDBcKTtfKCoOAAUAAggAFAADAP8/BAAAADtfKEBfKSAgfQhBAH0IAAAAAAAAAAAAAAAAMwAAAAMADQAUAAMAAAADAAAAMDBcKTtfKCoOAAUAAggAFAADADIzBAAAADtfKEBfKSAgfQgtAH0IAAAAAAAAAAAAAAAANAAAAAIADQAUAAMAAAADAAAAMDBcKTtfKCoOAAUAAn0IkQB9CAAAAAAAAAAAAAAAADUAAAAHAA0AFAACAAAAPz92/zAwXCk7XygqDgAFAAIEABQAAgAAAP/Mmf87XyhAXykgIAcAFAACAAAAf39//yAgICAgICAgCAAUAAIAAAB/f3//ICAgICAgICAJABQAAgAAAH9/f/8AAAAAAAAAAAoAFAACAAAAf39//wAAAAAAAAAAfQhBAH0IAAAAAAAAAAAAAAAANgAAAAMADQAUAAIAAAD6fQD/MDBcKTtfKCoOAAUAAggAFAACAAAA/4AB/ztfKEBfKSAgfQhBAH0IAAAAAAAAAAAAAAAANwAAAAMADQAUAAIAAACcZQD/MDBcKTtfKCoOAAUAAgQAFAACAAAA/+uc/ztfKEBfKSAgfQh4AH0IAAAAAAAAAAAAAAAAOAAAAAUABAAUAAIAAAD//8z/MDBcKTtfKCoHABQAAgAAALKysv8A/+uc/ztfKAgAFAACAAAAsrKy/wB/f3//ICAgCQAUAAIAAACysrL/AH9/f/8gICAKABQAAgAAALKysv8Af39//wAAAH0IkQB9CAAAAAAAAAAAAAAAADkAAAAHAA0AFAACAAAAPz8//zAwXCk7XygqDgAFAAIEABQAAgAAAPLy8v87XygIABQAAgcAFAACAAAAPz8//yAgIAkAFAACCAAUAAIAAAA/Pz//ICAgCgAUAAIJABQAAgAAAD8/P/8AAAAAAAAAAAoAFAACAAAAPz8//wAAAAAAAAAAfQgtAH0IAAAAAAAAAAAAAAAAOwAAAAIADQAUAAMAAAADAAAAMDBcKTtfKCoOAAUAAX0IVQB9CAAAAAAAAAAAAAAAADwAAAAEAA0AFAADAAAAAQAAADAwXCk7XygqDgAFAAIHABQAAwAAAAQAAAA7XygIABQAAggAFAADAAAABAAAACAgIAkAFAACfQgtAH0IAAAAAAAAAAAAAAAAPQAAAAIADQAUAAIAAAD/AAD/MDBcKTtfKCoOAAUAApIITQCSCAAAAAAAAAAAAAABBB7/DQAyADAAJQAgAC0AIABBAGMAYwBlAG4AdAAxAAAAAwABAAwABwRlZtvl8f8FAAwABwEAAAAAAP8lAAUAApIITQCSCAAAAAAAAAAAAAABBCL/DQAyADAAJQAgAC0AIABBAGMAYwBlAG4AdAAyAAAAAwABAAwABwVlZvLd3P8FAAwABwEAAAAAAP8lAAUAApIITQCSCAAAAAAAAAAAAAABBCb/DQAyADAAJQAgAC0AIABBAGMAYwBlAG4AdAAzAAAAAwABAAwABwZlZurx3f8FAAwABwEAAAAAAP8lAAUAApIITQCSCAAAAAAAAAAAAAABBCr/DQAyADAAJQAgAC0AIABBAGMAYwBlAG4AdAA0AAAAAwABAAwABwdlZuXg7P8FAAwABwEAAAAAAP8lAAUAApIITQCSCAAAAAAAAAAAAAABBC7/DQAyADAAJQAgAC0AIABBAGMAYwBlAG4AdAA1AAAAAwABAAwABwhlZtvu8/8FAAwABwEAAAAAAP8lAAUAApIITQCSCAAAAAAAAAAAAAABBDL/DQAyADAAJQAgAC0AIABBAGMAYwBlAG4AdAA2AAAAAwABAAwABwllZv3p2f8FAAwABwEAAAAAAP8lAAUAApIITQCSCAAAAAAAAAAAAAABBB//DQA0ADAAJQAgAC0AIABBAGMAYwBlAG4AdAAxAAAAAwABAAwABwTMTLjM5P8FAAwABwEAAAAAAP8lAAUAApIITQCSCAAAAAAAAAAAAAABBCP/DQA0ADAAJQAgAC0AIABBAGMAYwBlAG4AdAAyAAAAAwABAAwABwXMTOa5uP8FAAwABwEAAAAAAP8lAAUAApIITQCSCAAAAAAAAAAAAAABBCf/DQA0ADAAJQAgAC0AIABBAGMAYwBlAG4AdAAzAAAAAwABAAwABwbMTNfkvP8FAAwABwEAAAAAAP8lAAUAApIITQCSCAAAAAAAAAAAAAABBCv/DQA0ADAAJQAgAC0AIABBAGMAYwBlAG4AdAA0AAAAAwABAAwABwfMTMzA2v8FAAwABwEAAAAAAP8lAAUAApIITQCSCAAAAAAAAAAAAAABBC//DQA0ADAAJQAgAC0AIABBAGMAYwBlAG4AdAA1AAAAAwABAAwABwjMTLbd6P8FAAwABwEAAAAAAP8lAAUAApIITQCSCAAAAAAAAAAAAAABBDP/DQA0ADAAJQAgAC0AIABBAGMAYwBlAG4AdAA2AAAAAwABAAwABwnMTPzVtP8FAAwABwEAAAAAAP8lAAUAApIITQCSCAAAAAAAAAAAAAABBCD/DQA2ADAAJQAgAC0AIABBAGMAYwBlAG4AdAAxAAAAAwABAAwABwQyM5Wz1/8FAAwABwAAAP////8lAAUAApIITQCSCAAAAAAAAAAAAAABBCT/DQA2ADAAJQAgAC0AIABBAGMAYwBlAG4AdAAyAAAAAwABAAwABwUyM9mXlf8FAAwABwAAAP////8lAAUAApIITQCSCAAAAAAAAAAAAAABBCj/DQA2ADAAJQAgAC0AIABBAGMAYwBlAG4AdAAzAAAAAwABAAwABwYyM8LWmv8FAAwABwAAAP////8lAAUAApIITQCSCAAAAAAAAAAAAAABBCz/DQA2ADAAJQAgAC0AIABBAGMAYwBlAG4AdAA0AAAAAwABAAwABwcyM7Khx/8FAAwABwAAAP////8lAAUAApIITQCSCAAAAAAAAAAAAAABBDD/DQA2ADAAJQAgAC0AIABBAGMAYwBlAG4AdAA1AAAAAwABAAwABwgyM5PN3f8FAAwABwAAAP////8lAAUAApIITQCSCAAAAAAAAAAAAAABBDT/DQA2ADAAJQAgAC0AIABBAGMAYwBlAG4AdAA2AAAAAwABAAwABwkyM/rAkP8FAAwABwAAAP////8lAAUAApIIQQCSCAAAAAAAAAAAAAABBB3/BwBBAGMAYwBlAG4AdAAxAAAAAwABAAwABwQAAE+Bvf8FAAwABwAAAP////8lAAUAApIIQQCSCAAAAAAAAAAAAAABBCH/BwBBAGMAYwBlAG4AdAAyAAAAAwABAAwABwUAAMBQTf8FAAwABwAAAP////8lAAUAApIIQQCSCAAAAAAAAAAAAAABBCX/BwBBAGMAYwBlAG4AdAAzAAAAAwABAAwABwYAAJu7Wf8FAAwABwAAAP////8lAAUAApIIQQCSCAAAAAAAAAAAAAABBCn/BwBBAGMAYwBlAG4AdAA0AAAAAwABAAwABwcAAIBkov8FAAwABwAAAP////8lAAUAApIIQQCSCAAAAAAAAAAAAAABBC3/BwBBAGMAYwBlAG4AdAA1AAAAAwABAAwABwgAAEusxv8FAAwABwAAAP////8lAAUAApIIQQCSCAAAAAAAAAAAAAABBDH/BwBBAGMAYwBlAG4AdAA2AAAAAwABAAwABwkAAPeWRv8FAAwABwAAAP////8lAAUAApIIOQCSCAAAAAAAAAAAAAABARv/AwBCAGEAZAAAAAMAAQAMAAX/AAD/x87/BQAMAAX/AACcAAb/JQAFAAKSCIEAkggAAAAAAAAAAAAAAQIW/wsAQwBhAGwAYwB1AGwAYQB0AGkAbwBuAAAABwABAAwABf8AAPLy8v8FAAwABf8AAPp9AP8lAAUAAgYADgAF/wAAf39//wEABwAOAAX/AAB/f3//AQAIAA4ABf8AAH9/f/8BAAkADgAF/wAAf39//wEAkgh/AJIIAAAAAAAAAAAAAAECF/8KAEMAaABlAGMAawAgAEMAZQBsAGwAAAAHAAEADAAF/wAApaWl/wUADAAHAAAA/////yUABQACBgAOAAX/AAA/Pz//BgAHAA4ABf8AAD8/P/8GAAgADgAF/wAAPz8//wYACQAOAAX/AAA/Pz//BgCSCCAAkggAAAAAAAAAAAAAAQUD/wUAQwBvAG0AbQBhAAAAAACSCCgAkggAAAAAAAAAAAAAAQUG/wkAQwBvAG0AbQBhACAAWwAwAF0AAAAAAJIIJgCSCAAAAAAAAAAAAAABBQT/CABDAHUAcgByAGUAbgBjAHkAAAAAAJIILgCSCAAAAAAAAAAAAAABBQf/DABDAHUAcgByAGUAbgBjAHkAIABbADAAXQAAAAAAkghHAJIIAAAAAAAAAAAAAAECNf8QAEUAeABwAGwAYQBuAGEAdABvAHIAeQAgAFQAZQB4AHQAAAACAAUADAAF/wAAf39//yUABQACkgg7AJIIAAAAAAAAAAAAAAEBGv8EAEcAbwBvAGQAAAADAAEADAAF/wAAxu/O/wUADAAF/wAAAGEA/yUABQACkghHAJIIAAAAAAAAAAAAAAEDEP8JAEgAZQBhAGQAaQBuAGcAIAAxAAAAAwAFAAwABwMAAB9Jff8lAAUAAgcADgAHBAAAT4G9/wUAkghHAJIIAAAAAAAAAAAAAAEDEf8JAEgAZQBhAGQAaQBuAGcAIAAyAAAAAwAFAAwABwMAAB9Jff8lAAUAAgcADgAHBP8/qMDe/wUAkghHAJIIAAAAAAAAAAAAAAEDEv8JAEgAZQBhAGQAaQBuAGcAIAAzAAAAAwAFAAwABwMAAB9Jff8lAAUAAgcADgAHBDIzlbPX/wIAkgg5AJIIAAAAAAAAAAAAAAEDE/8JAEgAZQBhAGQAaQBuAGcAIAA0AAAAAgAFAAwABwMAAB9Jff8lAAUAApIIdQCSCAAAAAAAAAAAAAABAhT/BQBJAG4AcAB1AHQAAAAHAAEADAAF/wAA/8yZ/wUADAAF/wAAPz92/yUABQACBgAOAAX/AAB/f3//AQAHAA4ABf8AAH9/f/8BAAgADgAF/wAAf39//wEACQAOAAX/AAB/f3//AQCSCEsAkggAAAAAAAAAAAAAAQIY/wsATABpAG4AawBlAGQAIABDAGUAbABsAAAAAwAFAAwABf8AAPp9AP8lAAUAAgcADgAF/wAA/4AB/wYAkghBAJIIAAAAAAAAAAAAAAEBHP8HAE4AZQB1AHQAcgBhAGwAAAADAAEADAAF/wAA/+uc/wUADAAF/wAAnGUA/yUABQACkggzAJIIAAAAAAAAAAAAAAEBAP8GAE4AbwByAG0AYQBsAAAAAgAFAAwABwEAAAAAAP8lAAUAApIIYgCSCAAAAAAAAAAAAAABAgr/BABOAG8AdABlAAAABQABAAwABf8AAP//zP8GAA4ABf8AALKysv8BAAcADgAF/wAAsrKy/wEACAAOAAX/AACysrL/AQAJAA4ABf8AALKysv8BAJIIdwCSCAAAAAAAAAAAAAABAhX/BgBPAHUAdABwAHUAdAAAAAcAAQAMAAX/AADy8vL/BQAMAAX/AAA/Pz//JQAFAAIGAA4ABf8AAD8/P/8BAAcADgAF/wAAPz8//wEACAAOAAX/AAA/Pz//AQAJAA4ABf8AAD8/P/8BAJIIJACSCAAAAAAAAAAAAAABBQX/BwBQAGUAcgBjAGUAbgB0AAAAAACSCDEAkggAAAAAAAAAAAAAAQMP/wUAVABpAHQAbABlAAAAAgAFAAwABwMAAB9Jff8lAAUAAZIITQCSCAAAAAAAAAAAAAABAxn/BQBUAG8AdABhAGwAAAAEAAUADAAHAQAAAAAA/yUABQACBgAOAAcEAABPgb3/AQAHAA4ABwQAAE+Bvf8GAJIIPwCSCAAAAAAAAAAAAAABAgv/DABXAGEAcgBuAGkAbgBnACAAVABlAHgAdAAAAAIABQAMAAX/AAD/AAD/JQAFAAKOCFgAjggAAAAAAAAAAAAAkAAAABEAEQBUAGEAYgBsAGUAUwB0AHkAbABlAE0AZQBkAGkAdQBtADkAUABpAHYAbwB0AFMAdAB5AGwAZQBMAGkAZwBoAHQAMQA2AJoIGACaCAAAAAAAAAAAAAABAAAAAAAAAAEAAACjCBAAowgAAAAAAAAAAAAAAAAAAJYIEACWCAAAAAAAAAAAAABC5QEAmwgQAJsIAAAAAAAAAAAAAAEAAACMCBAAjAgAAAAAAAAAAAAAAAAAAAoAAAAJCBAAAAYQAOwVzQfJAAEABgMAAAsCFAAAAAAAAAAAAAEAAACRKwAA9ysAAA0AAgABAAwAAgBkAA8AAgABABEAAgAAABAACAD8qfHSTWJQP18AAgABACoAAgAAACsAAgAAAIIAAgABAIAACAAAAAAAAAAAACUCBAAAAB0BgQACAMEEFAAAABUAAACDAAIAAACEAAIAAAAmAAgAZmZmZmZm5j8nAAgAZmZmZmZm5j8oAAgAAAAAAAAA6D8pAAgAAAAAAAAA6D+hACIAAAAdAQEAAQABAAQAAAAAADMzMzMzM9M/MzMzMzMz0z8AAFUAAgAIAH0ADAAAAAABIAkPAAIABAAAAg4AAAAAAAEAAAAAAAMAAAAIAhAAAAAAAAMAHQEAAAAAAAEPAP0ACgAAAAAADwAAAAAA/QAKAAAAAQAPAAEAAAD9AAoAAAACAA8AAgAAANcABgA+AAAAAAA+AhIAtgYAAAAAQAAAAAAAAAAAAAAAHQAPAAMAAAAAAAABAAAAAAAAAO8ABgAAADcAAABnCBcAZwgAAAAAAAAAAAAAAgAB/////wNEAACcCCYAnAgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAADwzAAAAAAAAAACLCBAAiwgAAAAAAAAAAAAAAAACAAoAAAAJCBAAAAYQAOwVzQfJAAEABgMAAAsCEAAAAAAAAAAAAAAAAAB5LQAADQACAAEADAACAGQADwACAAEAEQACAAAAEAAIAPyp8dJNYlA/XwACAAEAKgACAAAAKwACAAAAggACAAEAgAAIAAAAAAAAAAAAJQIEAAAAHQGBAAIAwQQUAAAAFQAAAIMAAgAAAIQAAgAAACYACABmZmZmZmbmPycACABmZmZmZmbmPygACAAAAAAAAADoPykACAAAAAAAAADoP6EAIgAAAB0BAQABAAEABAAAAAIAMzMzMzMz0z8zMzMzMzPTPwAAVQACAAgAAAIOAAAAAAAAAAAAAAAAAAAAPgISALYAAAAAAEAAAAAAAAAAAAAAAB0ADwADAAAAAAAAAQAAAAAAAADvAAYAAAA3AAAAZwgXAGcIAAAAAAAAAAAAAAIAAf////8DRAAAnAgmAJwIAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA8MwAAAAAAAAAAiwgQAIsIAAAAAAAAAAAAAAAAAgAKAAAACQgQAAAGEADsFc0HyQABAAYDAAALAhAAAAAAAAAAAAAAAAAACS8AAA0AAgABAAwAAgBkAA8AAgABABEAAgAAABAACAD8qfHSTWJQP18AAgABACoAAgAAACsAAgAAAIIAAgABAIAACAAAAAAAAAAAACUCBAAAAB0BgQACAMEEFAAAABUAAACDAAIAAACEAAIAAAAmAAgAZmZmZmZm5j8nAAgAZmZmZmZm5j8oAAgAAAAAAAAA6D8pAAgAAAAAAAAA6D+hACIAAAAdAQEAAQABAAQAAAACADMzMzMzM9M/MzMzMzMz0z8AAFUAAgAIAAACDgAAAAAAAAAAAAAAAAAAAD4CEgC2AAAAAABAAAAAAAAAAAAAAAAdAA8AAwAAAAAAAAEAAAAAAAAA7wAGAAAANwAAAGcIFwBnCAAAAAAAAAAAAAACAAH/////A0QAAJwIJgCcCAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAPDMAAAAAAAAAAIsIEACLCAAAAAAAAAAAAAAAAAIACgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAD+/wAABQECAAAAAAAAAAAAAAAAAAAAAAABAAAA4IWf8vlPaBCrkQgAKyez2TAAAACEAAAABgAAAAEAAAA4AAAABAAAAEAAAAASAAAATAAAAAwAAABkAAAADQAAAHAAAAATAAAAfAAAAAIAAADkBAAAHgAAAAQAAAAAAAAAHgAAABAAAABNaWNyb3NvZnQgRXhjZWwAQAAAAADAfA0j2cYBQAAAAICMRRII+skBAwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA/v8AAAUBAgAAAAAAAAAAAAAAAAAAAAAAAQAAAALVzdWcLhsQk5cIACss+a4wAAAA2AAAAAkAAAABAAAAUAAAAA8AAABYAAAAFwAAAGQAAAALAAAAbAAAABAAAAB0AAAAEwAAAHwAAAAWAAAAhAAAAA0AAACMAAAADAAAALUAAAACAAAA5AQAAB4AAAAEAAAAAAAAAAMAAADmFQsACwAAAAAAAAALAAAAAAAAAAsAAAAAAAAACwAAAAAAAAAeEAAAAwAAAAcAAABTaGVldDEABwAAAFNoZWV0MgAHAAAAU2hlZXQzAAwQAAACAAAAHgAAAAsAAABXb3Jrc2hlZXRzAAMAAAADAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAEAAAACAAAAAwAAAAQAAAAFAAAABgAAAAcAAAAIAAAACQAAAAoAAAALAAAADAAAAA0AAAAOAAAADwAAABAAAAARAAAAEgAAABMAAAAUAAAAFQAAABYAAAAXAAAA/v///xkAAAAaAAAAGwAAABwAAAAdAAAAHgAAAB8AAAD+////IQAAACIAAAAjAAAAJAAAACUAAAAmAAAAJwAAAP7////9/////v//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////UgBvAG8AdAAgAEUAbgB0AHIAeQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABYABQH//////////wIAAAAgCAIAAAAAAMAAAAAAAABGAAAAAAAAAAAAAAAAAAAAAAAAAAD+////AAAAAAAAAABXAG8AcgBrAGIAbwBvAGsAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAEgACAf///////////////wAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACxLwAAAAAAAAUAUwB1AG0AbQBhAHIAeQBJAG4AZgBvAHIAbQBhAHQAaQBvAG4AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAoAAIBAQAAAAMAAAD/////AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAGAAAAAAQAAAAAAAABQBEAG8AYwB1AG0AZQBuAHQAUwB1AG0AbQBhAHIAeQBJAG4AZgBvAHIAbQBhAHQAaQBvAG4AAAAAAAAAAAAAADgAAgH///////////////8AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAgAAAAABAAAAAAAAA=
Base64>file2,decode,file2
WriteLn>%desktop_dir%\test2.xls,wres,file2
EndIf


Show>Dialog1,res1
GoSub>GetData
GoSub>PutData
Let>Dialog1.mslabel1=Data has been transfered from test1.xls%crlf%to test2.xls
ResetDialogAction>Dialog1
Show>Dialog1,res1


SRT>GetData
  Let>connStr1=Provider=Microsoft.Jet.OLEDB.4.0;Data Source=%desktop_dir%\test1.xls;Extended Properties=Excel 8.0;
  DBConnect>connStr1,dbH1
  Let>SQL1=select * from [Sheet1$]
  DBQuery>dbH1,SQL1,rsSheet1,nR,nF
END>GetData

SRT>PutData
  Let>connStr2=Provider=Microsoft.Jet.OLEDB.4.0;Data Source=%desktop_dir%\test2.xls;Extended Properties=Excel 8.0;
  DBConnect>connStr2,dbH2
  Let>SQL2=INSERT INTO [Sheet1$](A,B,C) VALUES('%rsSheet1_2_1%','%rsSheet1_2_2%','%rsSheet1_2_3%')
  DBExec>dbH2,SQL2,result
END>PutData

migro · Post by **migro** » Sun Jul 05, 2009 9:53 pm

Dear JRL,

thanks for the sample.

Because I didn't got DBQuery to work with my Access-DB, I have done it in VB with my friend Google who assists me over the nights searching for code pieces to put them together ....

The following code is only a little part from the whole script showing how the databasequery with direct excel export can be done. Maybe its helpfull for somebody who have similar needs. I'm not an expert in VB so my code may look a little bit free-spirited

Code: Select all

Label>DateConfig
   Day>the_day
   Month>the_month
   Year>the_year
   Let>today=%the_day%.%the_month%.%the_year%


Label>Init
   Let>strRKB=C:\my.mdb
   Let>strDateAnf=01.01.1997
   Let>strDateEnd=%today%
   // Or anything other You like to query the database
   Let>strSQL=SELECT * FROM TmyDB WHERE TmyDBTs BETWEEN #%strDateAnf%# AND #%strDateEnd%#
   Let>WritePath=DESKTOP_DIR\sample.xls

    // Progress is at 80%
   let>Dialog1.msProgressBar1=80
   ResetDialogAction>Dialog1

Label>Action
Vbstart
   'Option explicit
   Function GetXvalue(strRKB,strSQL,WritePath)
   Dim Sqlstring
   Dim RS
   Dim I

   On Error Resume Next
   Set Mydb = Createobject("Adodb.Connection")
   Set RS = CreateObject("ADODB.recordset")
   Mydb.Provider = "Microsoft.Jet.Oledb.4.0"
   Mydb.Connectionstring = "Data Source=" & strRKB & ";"
   Mydb.Open
      Sqlstring = "" & strSQL & ""
      Set RS = Mydb.Execute(Sqlstring)
      If Not RS.Eof Then
         GetXvalue = RS.Fields("TmyDBCulIntIDPk")&";"&RS.Fields("TmyDBTs")&";"&RS.Fields("TmyDBSName")&";"&RS.Fields("TmyDBSFirstname")&";"&RS.Fields("TmyDBDBirthday")&";"&RS.Fields("TmyDBSSex")&";"&RS.Fields("TmyDBSPreg")&";"&RS.Fields("TmyDBSType")&";"&RS.Fields("TmyDBSRegio")&";"&RS.Fields("TmyDBSRadDur")&";"&RS.Fields("TmyDBSVolt")&";"&RS.Fields("TmyDBSCur")&";"&RS.Fields("TmyDBSDr")&";"&RS.Fields("TmyDBSComment")

         'Create a new workbook in Excel
         Set oExcel = CreateObject("Excel.Application")
         Set oBook = oExcel.Workbooks.Add
         Set oSheet = oBook.Worksheets(1)
         With oSheet.Range("A1", "N1")
         .Orientation = 0
         .Font.Bold = True
         .Font.Color = RGB(255,255,255)
         .Borders.Color = RGB(150, 150, 150)
         .interior.Color = RGB(5, 72, 115)
         .HorizontalAlignment = -4108
         End With

         'Transfer the Header to Excel
         oSheet.Cells(1, 1).Value = "Nr."
         oSheet.Cells(1, 2).Value = "   Aufnahmedatum   "
         oSheet.Cells(1, 3).Value = "Name"
         oSheet.Cells(1, 4).Value = "Vorname"
         oSheet.Cells(1, 5).Value = "Geb. Datum"
         oSheet.Cells(1, 6).Value = "Geschlecht"
         oSheet.Cells(1, 7).Value = "Schwanger"
         oSheet.Cells(1, 8).Value = "Typ"
         oSheet.Cells(1, 9).Value = "Zahn/Prog."
         oSheet.Cells(1, 10).Value = "ms"
         oSheet.Cells(1, 11).Value = "kV"
         oSheet.Cells(1, 12).Value = "mA"
         oSheet.Cells(1, 13).Value = "Verantwortlicher"
         oSheet.Cells(1, 14).Value = "Bemerkung"

         'Transfer the data to Excel
         oSheet.Range("A2").CopyFromRecordset RS

         ' Make some formatting of the cells
         With oSheet.Range("B2:B65536")
         .NumberFormat = "DD.MM.YYYY hh:mm:ss"
         End With
         With oSheet.Range("E2:E65536")
         .NumberFormat = "DD.MM.YYYY"
         End With
         With oSheet.Range("A1", "N1")
         .EntireColumn.Autofit
         End With
         With oSheet.Range("A2").CurrentRegion
         .Borders.Color = RGB(200, 200, 200)
         End With
         With oSheet.Range("A2:B65536")
         .HorizontalAlignment = -4108
         End With
         With oSheet.Range("E2:M65536")
         .HorizontalAlignment = -4108
         End With
         With oSheet.Range("A2").CurrentRegion
            For I = 3 To .Rows.Count Step 2
               With .Rows(I).Interior
               .ColorIndex = 19
               '.Pattern = xlSolid
            End With
            Next
         End With

         oExcel.ErrorCheckingOptions.BackgroundChecking = False
         oExcel.DisplayAlerts = False
         oBook.SaveAs (WritePath)
         oExcel.Quit
         Set oExcel = Nothing
         Set oBook = Nothing
         Set oSheet = Nothing
      Else
         GetXvalue = "Not Found"
      End If
   RS.Close
   Mydb.Close
   End Function
Vbend

Vbeval>GetXvalue("%strRKB%","%strSQL%","%WritePath%"),strValue
   IF>%strValue%=Not Found
      Goto>Abbruch
   ENDIF

   // Progress is at 100%
   let>Dialog1.msProgressBar1=100
   ResetDialogAction>Dialog1

   ExecuteFile>%WritePath%
   Goto>MacroEnde

Label>MacroEnde
   // Do some things ...
   Goto>Exit


Label>Abbruch
   // Do some other things


Label>Exit

JRL · Post by **JRL** » Wed Aug 04, 2010 5:17 pm

The sample that I posted above does not seem to work in version 12. It works fine in version 11. The script is supposed to create two excel files on the desktop (and it does that). Then the script uses DBQuery> to extract some data from one of the files, and DBExec> to insert that data into the other.

Even though it appears to function properly, two bad things happen when you run the script in 12. First, the data does not get inserted into "test2.xls". Second, Macro Scheduler locks both files from being opened or deleted. You have to exit from Macro Scheduler before being allowed to work with the files.

almedajohnson · Post by **almedajohnson** » Thu Sep 16, 2010 10:22 am

Hi
thanks for the source code. I was looking for the same. IT was really helpful to me..

Storing the Output of DBQuery directly in Excel?

Storing the Output of DBQuery directly in Excel?

Using DBQuery to Read from and Write to excel files