Total C++ 2

home *** CD-ROM | disk | FTP | other *** search
/ Total C++ 2 / TOTALCTWO.iso / vfp5.0 / vfp / samples / solution / ole / olexl.sct < prev next >
Unknown | 1996-10-22 | 10.0 KB
open in:
MacOS 8.1 |
Win98 |
DOS
view JSON data |
view as text

This file was not able to be converted.
This format is not currently supported by dexvert.
Confidence	Program	Detection	Match Type	Support
`66%`	dexvert	Sound Control Module `(music/soundControl)`	ext	Supported
`100%`	file	data	default
`59%`	TrID	Form Memo MS Visual FoxPro 7	default (weak)
`40%`	TrID	MacBinary 1	default (weak)
`100%`	siegfried	x-fmt/342 Microsoft FoxPro Memo	default (weak)
hex view
+--------+-------------------------+-------------------------+--------+--------+
|00000000| 00 00 28 13 00 00 00 01 | 00 00 00 00 00 00 00 00 |..(.....|........|
|00000010| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000020| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000030| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000040| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000050| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000060| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000070| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000080| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000090| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000100| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000110| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000120| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000130| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000140| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000150| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000160| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000170| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000180| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000190| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000001a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000001b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000001c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000001d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000001e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000001f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000200| 00 00 00 01 00 00 00 10 | 56 45 52 53 49 4f 4e 20 |........|VERSION |
|00000210| 3d 20 20 20 33 2e 30 30 | 00 00 00 01 00 00 00 0f |=   3.00|........|
|00000220| 64 61 74 61 65 6e 76 69 | 72 6f 6e 6d 65 6e 74 00 |dataenvi|ronment.|
|00000230| 00 00 01 00 00 00 0f 64 | 61 74 61 65 6e 76 69 72 |.......d|ataenvir|
|00000240| 6f 6e 6d 65 6e 74 00 00 | 00 01 00 00 00 0e 44 61 |onment..|......Da|
|00000250| 74 61 6e 61 76 69 67 61 | 74 69 6f 6e 00 00 00 01 |tanaviga|tion....|
|00000260| 00 00 00 19 4e 61 6d 65 | 20 3d 20 22 44 61 74 61 |....Name| = "Data|
|00000270| 6e 61 76 69 67 61 74 69 | 6f 6e 22 0d 0a 00 00 00 |navigati|on".....|
|00000280| 01 00 00 00 01 31 00 00 | 00 01 00 00 00 01 32 00 |.....1..|......2.|
|00000290| 00 00 01 00 00 00 04 66 | 6f 72 6d 00 00 00 01 00 |.......f|orm.....|
|000002a0| 00 00 04 66 6f 72 6d 00 | 00 00 01 00 00 00 05 46 |...form.|.......F|
|000002b0| 6f 72 6d 31 00 00 00 01 | 00 00 00 c9 44 61 74 61 |orm1....|....Data|
|000002c0| 53 65 73 73 69 6f 6e 20 | 3d 20 32 0d 0a 48 65 69 |Session |= 2..Hei|
|000002d0| 67 68 74 20 3d 20 32 33 | 32 0d 0a 57 69 64 74 68 |ght = 23|2..Width|
|000002e0| 20 3d 20 33 38 33 0d 0a | 44 6f 43 72 65 61 74 65 | = 383..|DoCreate|
|000002f0| 20 3d 20 2e 54 2e 0d 0a | 41 75 74 6f 43 65 6e 74 | = .T...|AutoCent|
|00000300| 65 72 20 3d 20 2e 54 2e | 0d 0a 43 61 70 74 69 6f |er = .T.|..Captio|
|00000310| 6e 20 3d 20 22 41 75 74 | 6f 6d 61 74 65 20 61 20 |n = "Aut|omate a |
|00000320| 4d 69 63 72 6f 73 6f 66 | 74 20 45 78 63 65 6c 20 |Microsof|t Excel |
|00000330| 53 70 72 65 61 64 73 68 | 65 65 74 22 0d 0a 4d 61 |Spreadsh|eet"..Ma|
|00000340| 78 42 75 74 74 6f 6e 20 | 3d 20 2e 46 2e 0d 0a 4d |xButton |= .F...M|
|00000350| 69 6e 42 75 74 74 6f 6e | 20 3d 20 2e 54 2e 0d 0a |inButton| = .T...|
|00000360| 48 65 6c 70 43 6f 6e 74 | 65 78 74 49 44 20 3d 20 |HelpCont|extID = |
|00000370| 31 31 34 0d 0a 4e 61 6d | 65 20 3d 20 22 46 6f 72 |114..Nam|e = "For|
|00000380| 6d 31 22 0d 0a 00 00 00 | 01 00 00 01 18 50 52 4f |m1".....|.....PRO|
|00000390| 43 45 44 55 52 45 20 44 | 65 61 63 74 69 76 61 74 |CEDURE D|eactivat|
|000003a0| 65 0d 0a 49 46 20 54 59 | 50 45 28 22 54 48 49 53 |e..IF TY|PE("THIS|
|000003b0| 2e 63 5f 73 6f 6c 75 74 | 69 6f 6e 73 31 22 29 20 |.c_solut|ions1") |
|000003c0| 3d 20 22 4f 22 20 54 48 | 45 4e 0d 0a 09 54 48 49 |= "O" TH|EN...THI|
|000003d0| 53 2e 63 5f 73 6f 6c 75 | 74 69 6f 6e 73 31 2e 72 |S.c_solu|tions1.r|
|000003e0| 65 73 74 6f 72 65 48 65 | 6c 70 0d 0a 45 4e 44 49 |estoreHe|lp..ENDI|
|000003f0| 46 0d 0a 45 4e 44 50 52 | 4f 43 0d 0a 50 52 4f 43 |F..ENDPR|OC..PROC|
|00000400| 45 44 55 52 45 20 41 63 | 74 69 76 61 74 65 0d 0a |EDURE Ac|tivate..|
|00000410| 54 48 49 53 2e 63 5f 73 | 6f 6c 75 74 69 6f 6e 73 |THIS.c_s|olutions|
|00000420| 31 2e 73 61 76 65 48 65 | 6c 70 0d 0a 45 4e 44 50 |1.saveHe|lp..ENDP|
|00000430| 52 4f 43 0d 0a 50 52 4f | 43 45 44 55 52 45 20 44 |ROC..PRO|CEDURE D|
|00000440| 65 73 74 72 6f 79 0d 0a | 52 45 4c 45 41 53 45 20 |estroy..|RELEASE |
|00000450| 6f 58 4c 43 68 61 72 74 | 31 0d 0a 0d 0a 45 4e 44 |oXLChart|1....END|
|00000460| 50 52 4f 43 0d 0a 50 52 | 4f 43 45 44 55 52 45 20 |PROC..PR|OCEDURE |
|00000470| 45 72 72 6f 72 0d 0a 50 | 61 72 61 6d 65 74 65 72 |Error..P|arameter|
|00000480| 73 20 6e 45 72 72 6f 72 | 2c 20 63 4d 65 74 68 6f |s nError|, cMetho|
|00000490| 64 2c 20 6e 4c 69 6e 65 | 0d 0a 0d 0a 45 4e 44 50 |d, nLine|....ENDP|
|000004a0| 52 4f 43 0d 0a 00 00 00 | 01 00 00 01 f1 fe f2 ff |ROC.....|........|
|000004b0| 1f 02 01 00 00 00 d8 01 | 00 00 d8 01 00 00 00 00 |........|........|
|000004c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000004d0| 00 00 00 00 c8 b4 04 00 | 00 00 25 00 00 00 03 01 |........|..%.....|
|000004e0| 00 00 00 00 00 00 5f 01 | 00 00 0b 00 00 00 49 01 |......_.|......I.|
|000004f0| 00 00 00 00 00 00 00 00 | 00 00 fc 03 00 03 00 55 |........|.......U|
|00000500| 00 00 39 00 25 00 25 fc | 43 d9 11 00 54 48 49 53 |..9.%.%.|C...THIS|
|00000510| 2e 63 5f 73 6f 6c 75 74 | 69 6f 6e 73 31 62 d9 01 |.c_solut|ions1b..|
|00000520| 00 4f 10 fd f9 05 32 00 | fe 0d 00 99 f4 00 00 f4 |.O....2.|........|
|00000530| 01 00 f7 02 00 fe 04 00 | 1e fe 03 00 55 03 00 04 |........|....U...|
|00000540| 00 54 48 49 53 0c 00 43 | 5f 53 4f 4c 55 54 49 4f |.THIS..C|_SOLUTIO|
|00000550| 4e 53 31 0b 00 52 45 53 | 54 4f 52 45 48 45 4c 50 |NS1..RES|TOREHELP|
|00000560| 10 00 0d 00 99 f4 00 00 | f4 01 00 f7 02 00 fe 03 |........|........|
|00000570| 00 55 03 00 04 00 54 48 | 49 53 0c 00 43 5f 53 4f |.U....TH|IS..C_SO|
|00000580| 4c 55 54 49 4f 4e 53 31 | 08 00 53 41 56 45 48 45 |LUTIONS1|..SAVEHE|
|00000590| 4c 50 0a 00 07 00 3c f7 | 00 00 fe 03 00 55 01 00 |LP....<.|.....U..|
|000005a0| 09 00 4f 58 4c 43 48 41 | 52 54 31 12 00 0f 00 34 |..OXLCHA|RT1....4|
|000005b0| f7 00 00 07 f7 01 00 07 | f7 02 00 fe 03 00 55 03 |........|......U.|
|000005c0| 00 06 00 4e 45 52 52 4f | 52 07 00 43 4d 45 54 48 |...NERRO|R..CMETH|
|000005d0| 4f 44 05 00 4e 4c 49 4e | 45 0a 00 44 65 61 63 74 |OD..NLIN|E..Deact|
|000005e0| 69 76 61 74 65 2c 00 00 | 00 00 00 ff ff 08 00 41 |ivate,..|.......A|
|000005f0| 63 74 69 76 61 74 65 8a | 00 00 00 00 00 ff ff 07 |ctivate.|........|
|00000600| 00 44 65 73 74 72 6f 79 | bc 00 00 00 00 00 ff ff |.Destroy|........|
|00000610| 05 00 45 72 72 6f 72 d5 | 00 00 00 00 00 ff ff 31 |..Error.|.......1|
|00000620| 00 51 02 d1 00 41 00 32 | 00 d1 00 32 00 71 00 33 |.Q...A.2|...2.q.3|
|00000630| 00 f1 00 32 00 00 00 00 | 00 00 00 00 00 00 00 00 |...2....|........|
|00000640| 00 00 00 00 00 01 00 00 | 00 16 00 00 00 64 00 00 |........|.....d..|
|00000650| 00 01 00 00 00 05 00 00 | 00 83 00 00 00 9d 00 00 |........|........|
|00000660| 00 06 00 00 00 07 00 00 | 00 bb 00 00 00 ce 00 00 |........|........|
|00000670| 00 09 00 00 00 09 00 00 | 00 ea 00 00 00 0d 01 00 |........|........|
|00000680| 00 0d 00 00 00 00 29 00 | 00 00 d8 01 00 00 00 00 |......).|........|
|00000690| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000006a0| 00 01 00 00 00 05 73 68 | 61 70 65 00 00 00 01 00 |......sh|ape.....|
|000006b0| 00 00 05 73 68 61 70 65 | 00 00 00 01 00 00 00 06 |...shape|........|
|000006c0| 53 68 61 70 65 34 00 00 | 00 01 00 00 00 05 46 6f |Shape4..|......Fo|
|000006d0| 72 6d 31 00 00 00 01 00 | 00 00 63 54 6f 70 20 3d |rm1.....|..cTop =|
|000006e0| 20 31 35 34 0d 0a 4c 65 | 66 74 20 3d 20 31 31 0d | 154..Le|ft = 11.|
|000006f0| 0a 48 65 69 67 68 74 20 | 3d 20 34 32 0d 0a 57 69 |.Height |= 42..Wi|
|00000700| 64 74 68 20 3d 20 33 36 | 33 0d 0a 42 61 63 6b 53 |dth = 36|3..BackS|
|00000710| 74 79 6c 65 20 3d 20 30 | 0d 0a 53 70 65 63 69 61 |tyle = 0|..Specia|
|00000720| 6c 45 66 66 65 63 74 20 | 3d 20 30 0d 0a 4e 61 6d |lEffect |= 0..Nam|
|00000730| 65 20 3d 20 22 53 68 61 | 70 65 34 22 0d 0a 00 00 |e = "Sha|pe4"....|
|00000740| 00 01 00 00 00 05 6c 61 | 62 65 6c 00 00 00 01 00 |......la|bel.....|
|00000750| 00 00 05 6c 61 62 65 6c | 00 00 00 01 00 00 00 06 |...label|........|
|00000760| 4c 61 62 65 6c 33 00 00 | 00 01 00 00 00 05 46 6f |Label3..|......Fo|
|00000770| 72 6d 31 00 00 00 01 00 | 00 00 a8 41 75 74 6f 53 |rm1.....|...AutoS|
|00000780| 69 7a 65 20 3d 20 2e 54 | 2e 0d 0a 46 6f 6e 74 4e |ize = .T|...FontN|
|00000790| 61 6d 65 20 3d 20 22 4d | 53 20 53 61 6e 73 20 53 |ame = "M|S Sans S|
|000007a0| 65 72 69 66 22 0d 0a 46 | 6f 6e 74 53 69 7a 65 20 |erif"..F|ontSize |
|000007b0| 3d 20 38 0d 0a 43 61 70 | 74 69 6f 6e 20 3d 20 22 |= 8..Cap|tion = "|
|000007c0| 20 45 78 61 6d 70 6c 65 | 20 32 3a 20 43 68 61 72 | Example| 2: Char|
|000007d0| 74 20 22 0d 0a 48 65 69 | 67 68 74 20 3d 20 31 35 |t "..Hei|ght = 15|
|000007e0| 0d 0a 4c 65 66 74 20 3d | 20 31 39 0d 0a 54 6f 70 |..Left =| 19..Top|
|000007f0| 20 3d 20 31 34 38 0d 0a | 57 69 64 74 68 20 3d 20 | = 148..|Width = |
|00000800| 38 38 0d 0a 54 61 62 49 | 6e 64 65 78 20 3d 20 30 |88..TabI|ndex = 0|
|00000810| 0d 0a 4e 61 6d 65 20 3d | 20 22 4c 61 62 65 6c 33 |..Name =| "Label3|
|00000820| 22 0d 0a 00 00 00 01 00 | 00 00 05 6c 61 62 65 6c |".......|...label|
|00000830| 00 00 00 01 00 00 00 05 | 6c 61 62 65 6c 00 00 00 |........|label...|
|00000840| 01 00 00 00 06 4c 61 62 | 65 6c 34 00 00 00 01 00 |.....Lab|el4.....|
|00000850| 00 00 05 46 6f 72 6d 31 | 00 00 00 01 00 00 00 f2 |...Form1|........|
|00000860| 46 6f 6e 74 4e 61 6d 65 | 20 3d 20 22 4d 53 20 53 |FontName| = "MS S|
|00000870| 61 6e 73 20 53 65 72 69 | 66 22 0d 0a 46 6f 6e 74 |ans Seri|f"..Font|
|00000880| 53 69 7a 65 20 3d 20 38 | 0d 0a 57 6f 72 64 57 72 |Size = 8|..WordWr|
|00000890| 61 70 20 3d 20 2e 54 2e | 0d 0a 43 61 70 74 69 6f |ap = .T.|..Captio|
|000008a0| 6e 20 3d 20 22 54 68 69 | 73 20 65 78 61 6d 70 6c |n = "Thi|s exampl|
|000008b0| 65 20 73 65 6e 64 73 20 | 73 6f 6d 65 20 73 61 6d |e sends |some sam|
|000008c0| 70 6c 65 20 64 61 74 61 | 20 74 6f 20 4d 69 63 72 |ple data| to Micr|
|000008d0| 6f 73 6f 66 74 20 45 78 | 63 65 6c 20 61 6e 64 20 |osoft Ex|cel and |
|000008e0| 63 72 65 61 74 65 73 20 | 61 20 62 61 72 20 63 68 |creates |a bar ch|
|000008f0| 61 72 74 20 6f 66 20 74 | 68 65 20 64 61 74 61 2e |art of t|he data.|
|00000900| 22 0d 0a 48 65 69 67 68 | 74 20 3d 20 32 36 0d 0a |"..Heigh|t = 26..|
|00000910| 4c 65 66 74 20 3d 20 32 | 30 0d 0a 54 6f 70 20 3d |Left = 2|0..Top =|
|00000920| 20 31 36 34 0d 0a 57 69 | 64 74 68 20 3d 20 32 36 | 164..Wi|dth = 26|
|00000930| 31 0d 0a 54 61 62 49 6e | 64 65 78 20 3d 20 30 0d |1..TabIn|dex = 0.|
|00000940| 0a 4e 61 6d 65 20 3d 20 | 22 4c 61 62 65 6c 34 22 |.Name = |"Label4"|
|00000950| 0d 0a 00 00 00 01 00 00 | 00 05 73 68 61 70 65 00 |........|..shape.|
|00000960| 00 00 01 00 00 00 05 73 | 68 61 70 65 00 00 00 01 |.......s|hape....|
|00000970| 00 00 00 06 53 68 61 70 | 65 33 00 00 00 01 00 00 |....Shap|e3......|
|00000980| 00 05 46 6f 72 6d 31 00 | 00 00 01 00 00 00 62 54 |..Form1.|......bT|
|00000990| 6f 70 20 3d 20 37 30 0d | 0a 4c 65 66 74 20 3d 20 |op = 70.|.Left = |
|000009a0| 31 31 0d 0a 48 65 69 67 | 68 74 20 3d 20 37 31 0d |11..Heig|ht = 71.|
|000009b0| 0a 57 69 64 74 68 20 3d | 20 33 36 33 0d 0a 42 61 |.Width =| 363..Ba|
|000009c0| 63 6b 53 74 79 6c 65 20 | 3d 20 30 0d 0a 53 70 65 |ckStyle |= 0..Spe|
|000009d0| 63 69 61 6c 45 66 66 65 | 63 74 20 3d 20 30 0d 0a |cialEffe|ct = 0..|
|000009e0| 4e 61 6d 65 20 3d 20 22 | 53 68 61 70 65 33 22 0d |Name = "|Shape3".|
|000009f0| 0a 00 00 00 01 00 00 00 | 05 6c 61 62 65 6c 00 00 |........|.label..|
|00000a00| 00 01 00 00 00 05 6c 61 | 62 65 6c 00 00 00 01 00 |......la|bel.....|
|00000a10| 00 00 06 4c 61 62 65 6c | 31 00 00 00 01 00 00 00 |...Label|1.......|
|00000a20| 05 46 6f 72 6d 31 00 00 | 00 01 00 00 00 a7 41 75 |.Form1..|......Au|
|00000a30| 74 6f 53 69 7a 65 20 3d | 20 2e 54 2e 0d 0a 46 6f |toSize =| .T...Fo|
|00000a40| 6e 74 4e 61 6d 65 20 3d | 20 22 4d 53 20 53 61 6e |ntName =| "MS San|
|00000a50| 73 20 53 65 72 69 66 22 | 0d 0a 46 6f 6e 74 53 69 |s Serif"|..FontSi|
|00000a60| 7a 65 20 3d 20 38 0d 0a | 43 61 70 74 69 6f 6e 20 |ze = 8..|Caption |
|00000a70| 3d 20 22 20 45 78 61 6d | 70 6c 65 20 31 3a 20 54 |= " Exam|ple 1: T|
|00000a80| 72 65 6e 64 20 22 0d 0a | 48 65 69 67 68 74 20 3d |rend "..|Height =|
|00000a90| 20 31 35 0d 0a 4c 65 66 | 74 20 3d 20 31 39 0d 0a | 15..Lef|t = 19..|
|00000aa0| 54 6f 70 20 3d 20 36 34 | 0d 0a 57 69 64 74 68 20 |Top = 64|..Width |
|00000ab0| 3d 20 39 31 0d 0a 54 61 | 62 49 6e 64 65 78 20 3d |= 91..Ta|bIndex =|
|00000ac0| 20 30 0d 0a 4e 61 6d 65 | 20 3d 20 22 4c 61 62 65 | 0..Name| = "Labe|
|00000ad0| 6c 31 22 0d 0a 00 00 00 | 01 00 00 00 05 6c 61 62 |l1".....|.....lab|
|00000ae0| 65 6c 00 00 00 01 00 00 | 00 05 6c 61 62 65 6c 00 |el......|..label.|
|00000af0| 00 00 01 00 00 00 06 4c | 61 62 65 6c 32 00 00 00 |.......L|abel2...|
|00000b00| 01 00 00 00 05 46 6f 72 | 6d 31 00 00 00 01 00 00 |.....For|m1......|
|00000b10| 01 4b 46 6f 6e 74 4e 61 | 6d 65 20 3d 20 22 4d 53 |.KFontNa|me = "MS|
|00000b20| 20 53 61 6e 73 20 53 65 | 72 69 66 22 0d 0a 46 6f | Sans Se|rif"..Fo|
|00000b30| 6e 74 53 69 7a 65 20 3d | 20 38 0d 0a 57 6f 72 64 |ntSize =| 8..Word|
|00000b40| 57 72 61 70 20 3d 20 2e | 54 2e 0d 0a 43 61 70 74 |Wrap = .|T...Capt|
|00000b50| 69 6f 6e 20 3d 20 22 54 | 68 69 73 20 65 78 61 6d |ion = "T|his exam|
|00000b60| 70 6c 65 20 73 65 6e 64 | 73 20 74 68 65 20 72 65 |ple send|s the re|
|00000b70| 73 75 6c 74 73 20 6f 66 | 20 61 20 63 72 6f 73 73 |sults of| a cross|
|00000b80| 74 61 62 20 71 75 65 72 | 79 20 74 6f 20 4d 69 63 |tab quer|y to Mic|
|00000b90| 72 6f 73 6f 66 74 20 45 | 78 63 65 6c 20 74 6f 20 |rosoft E|xcel to |
|00000ba0| 63 61 6c 63 75 6c 61 74 | 65 20 73 61 6c 65 73 20 |calculat|e sales |
|00000bb0| 74 72 65 6e 64 73 20 66 | 6f 72 20 70 72 6f 64 75 |trends f|or produ|
|00000bc0| 63 74 73 20 69 6e 20 74 | 68 65 20 54 45 53 54 44 |cts in t|he TESTD|
|00000bd0| 41 54 41 20 64 61 74 61 | 62 61 73 65 2e 20 54 68 |ATA data|base. Th|
|00000be0| 65 20 74 72 65 6e 64 20 | 69 6e 66 6f 72 6d 61 74 |e trend |informat|
|00000bf0| 69 6f 6e 20 69 73 20 72 | 65 74 72 69 65 76 65 64 |ion is r|etrieved|
|00000c00| 20 66 72 6f 6d 20 45 78 | 63 65 6c 2e 22 0d 0a 48 | from Ex|cel."..H|
|00000c10| 65 69 67 68 74 20 3d 20 | 35 36 0d 0a 4c 65 66 74 |eight = |56..Left|
|00000c20| 20 3d 20 32 30 0d 0a 54 | 6f 70 20 3d 20 38 30 0d | = 20..T|op = 80.|
|00000c30| 0a 57 69 64 74 68 20 3d | 20 32 36 32 0d 0a 54 61 |.Width =| 262..Ta|
|00000c40| 62 49 6e 64 65 78 20 3d | 20 30 0d 0a 4e 61 6d 65 |bIndex =| 0..Name|
|00000c50| 20 3d 20 22 4c 61 62 65 | 6c 32 22 0d 0a 00 00 00 | = "Labe|l2".....|
|00000c60| 01 00 00 00 0d 63 6f 6d | 6d 61 6e 64 62 75 74 74 |.....com|mandbutt|
|00000c70| 6f 6e 00 00 00 01 00 00 | 00 0d 63 6f 6d 6d 61 6e |on......|..comman|
|00000c80| 64 62 75 74 74 6f 6e 00 | 00 00 01 00 00 00 08 63 |dbutton.|.......c|
|00000c90| 6d 64 43 68 61 72 74 00 | 00 00 01 00 00 00 05 46 |mdChart.|.......F|
|00000ca0| 6f 72 6d 31 00 00 00 01 | 00 00 00 94 54 6f 70 20 |orm1....|....Top |
|00000cb0| 3d 20 31 36 35 0d 0a 4c | 65 66 74 20 3d 20 32 39 |= 165..L|eft = 29|
|00000cc0| 33 0d 0a 48 65 69 67 68 | 74 20 3d 20 32 33 0d 0a |3..Heigh|t = 23..|
|00000cd0| 57 69 64 74 68 20 3d 20 | 37 32 0d 0a 46 6f 6e 74 |Width = |72..Font|
|00000ce0| 4e 61 6d 65 20 3d 20 22 | 4d 53 20 53 61 6e 73 20 |Name = "|MS Sans |
|00000cf0| 53 65 72 69 66 22 0d 0a | 46 6f 6e 74 53 69 7a 65 |Serif"..|FontSize|
|00000d00| 20 3d 20 38 0d 0a 43 61 | 70 74 69 6f 6e 20 3d 20 | = 8..Ca|ption = |
|00000d10| 22 45 78 61 6d 70 6c 65 | 20 5c 3c 32 22 0d 0a 54 |"Example| \<2"..T|
|00000d20| 61 62 49 6e 64 65 78 20 | 3d 20 32 0d 0a 4e 61 6d |abIndex |= 2..Nam|
|00000d30| 65 20 3d 20 22 63 6d 64 | 43 68 61 72 74 22 0d 0a |e = "cmd|Chart"..|
|00000d40| 00 00 00 01 00 00 03 9d | 50 52 4f 43 45 44 55 52 |........|PROCEDUR|
|00000d50| 45 20 45 72 72 6f 72 0d | 0a 50 61 72 61 6d 65 74 |E Error.|.Paramet|
|00000d60| 65 72 73 20 6e 45 72 72 | 6f 72 2c 20 63 4d 65 74 |ers nErr|or, cMet|
|00000d70| 68 6f 64 2c 20 6e 4c 69 | 6e 65 0d 0a 3d 6d 65 73 |hod, nLi|ne..=mes|
|00000d80| 73 61 67 65 62 28 6d 65 | 73 73 61 67 65 28 29 29 |sageb(me|ssage())|
|00000d90| 0d 0a 63 61 6e 63 65 6c | 0d 0a 0d 0a 45 4e 44 50 |..cancel|....ENDP|
|00000da0| 52 4f 43 0d 0a 50 52 4f | 43 45 44 55 52 45 20 43 |ROC..PRO|CEDURE C|
|00000db0| 6c 69 63 6b 0d 0a 23 44 | 45 46 49 4e 45 20 54 41 |lick..#D|EFINE TA|
|00000dc0| 42 09 43 48 52 28 39 29 | 0d 0a 23 44 45 46 49 4e |B.CHR(9)|..#DEFIN|
|00000dd0| 20 43 52 4c 46 09 43 48 | 52 28 31 33 29 2b 43 48 | CRLF.CH|R(13)+CH|
|00000de0| 52 28 31 30 29 0d 0a 0d | 0a 4c 4f 43 41 4c 20 6e |R(10)...|.LOCAL n|
|00000df0| 54 6f 74 53 65 72 69 65 | 73 2c 69 0d 0a 70 75 62 |TotSerie|s,i..pub|
|00000e00| 6c 69 63 20 6f 58 4c 43 | 68 61 72 74 31 0d 0a 6f |lic oXLC|hart1..o|
|00000e10| 58 4c 43 68 61 72 74 31 | 20 3d 20 47 65 74 4f 62 |XLChart1| = GetOb|
|00000e20| 6a 65 63 74 28 27 27 2c | 27 65 78 63 65 6c 2e 63 |ject('',|'excel.c|
|00000e30| 68 61 72 74 27 29 0d 0a | 6f 58 4c 43 68 61 72 74 |hart')..|oXLChart|
|00000e40| 31 2e 61 70 70 6c 69 63 | 61 74 69 6f 6e 2e 63 68 |1.applic|ation.ch|
|00000e50| 61 72 74 73 5b 31 5d 2e | 68 61 73 6c 65 67 65 6e |arts[1].|haslegen|
|00000e60| 64 20 3d 20 2e 46 2e 0d | 0a 6f 58 4c 43 68 61 72 |d = .F..|.oXLChar|
|00000e70| 74 31 2e 61 70 70 6c 69 | 63 61 74 69 6f 6e 2e 76 |t1.appli|cation.v|
|00000e80| 69 73 69 62 6c 65 20 3d | 20 2e 74 2e 0d 0a 6f 58 |isible =| .t...oX|
|00000e90| 4c 43 68 61 72 74 31 2e | 61 70 70 6c 69 63 61 74 |LChart1.|applicat|
|00000ea0| 69 6f 6e 2e 77 6f 72 6b | 73 68 65 65 74 73 28 31 |ion.work|sheets(1|
|00000eb0| 29 2e 63 65 6c 6c 73 28 | 29 2e 63 6c 65 61 72 0d |).cells(|).clear.|
|00000ec0| 0a 0d 0a 5f 63 6c 69 70 | 74 65 78 74 20 3d 20 22 |..._clip|text = "|
|00000ed0| 22 2b 54 41 42 2b 22 43 | 61 74 73 22 2b 54 41 42 |"+TAB+"C|ats"+TAB|
|00000ee0| 2b 22 44 6f 67 73 22 2b | 43 52 4c 46 2b 3b 0d 0a |+"Dogs"+|CRLF+;..|
|00000ef0| 09 09 20 22 31 39 39 34 | 22 2b 54 41 42 2b 22 31 |.. "1994|"+TAB+"1|
|00000f00| 31 22 2b 54 41 42 2b 22 | 32 32 22 2b 43 52 4c 46 |1"+TAB+"|22"+CRLF|
|00000f10| 2b 3b 0d 0a 09 09 20 22 | 31 39 39 35 22 2b 54 41 |+;.... "|1995"+TA|
|00000f20| 42 2b 22 33 33 22 2b 54 | 41 42 2b 22 34 34 22 2b |B+"33"+T|AB+"44"+|
|00000f30| 43 52 4c 46 2b 3b 0d 0a | 09 09 20 22 31 39 39 36 |CRLF+;..|.. "1996|
|00000f40| 22 2b 54 41 42 2b 22 35 | 35 22 2b 54 41 42 2b 22 |"+TAB+"5|5"+TAB+"|
|00000f50| 35 35 22 2b 43 52 4c 46 | 0d 0a 0d 0a 6f 58 4c 43 |55"+CRLF|....oXLC|
|00000f60| 68 61 72 74 31 2e 61 70 | 70 6c 69 63 61 74 69 6f |hart1.ap|plicatio|
|00000f70| 6e 2e 77 6f 72 6b 73 68 | 65 65 74 73 28 31 29 2e |n.worksh|eets(1).|
|00000f80| 63 65 6c 6c 73 28 31 2c | 31 29 2e 70 61 73 74 65 |cells(1,|1).paste|
|00000f90| 73 70 65 63 69 61 6c 0d | 0a 6f 58 4c 43 68 61 72 |special.|.oXLChar|
|00000fa0| 74 31 2e 61 70 70 6c 69 | 63 61 74 69 6f 6e 2e 63 |t1.appli|cation.c|
|00000fb0| 68 61 72 74 73 5b 31 5d | 2e 61 75 74 6f 66 6f 72 |harts[1]|.autofor|
|00000fc0| 6d 61 74 28 2d 34 31 30 | 30 2c 31 29 0d 0a 0d 0a |mat(-410|0,1)....|
|00000fd0| 2a 20 52 65 6d 6f 76 65 | 20 65 78 74 72 61 20 73 |* Remove| extra s|
|00000fe0| 65 72 69 65 73 20 61 64 | 64 65 64 20 62 79 20 45 |eries ad|ded by E|
|00000ff0| 78 63 65 6c 0d 0a 6e 54 | 6f 74 53 65 72 69 65 73 |xcel..nT|otSeries|
|00001000| 20 3d 20 6f 58 4c 43 68 | 61 72 74 31 2e 61 70 70 | = oXLCh|art1.app|
|00001010| 6c 69 63 61 74 69 6f 6e | 2e 63 68 61 72 74 73 5b |lication|.charts[|
|00001020| 31 5d 2e 53 65 72 69 65 | 73 43 6f 6c 6c 65 63 74 |1].Serie|sCollect|
|00001030| 69 6f 6e 28 29 2e 63 6f | 75 6e 74 0d 0a 46 4f 52 |ion().co|unt..FOR|
|00001040| 20 69 20 3d 20 6d 2e 6e | 54 6f 74 53 65 72 69 65 | i = m.n|TotSerie|
|00001050| 73 20 74 6f 20 34 20 53 | 54 45 50 20 2d 31 0d 0a |s to 4 S|TEP -1..|
|00001060| 09 6f 58 4c 43 68 61 72 | 74 31 2e 61 70 70 6c 69 |.oXLChar|t1.appli|
|00001070| 63 61 74 69 6f 6e 2e 63 | 68 61 72 74 73 5b 31 5d |cation.c|harts[1]|
|00001080| 2e 53 65 72 69 65 73 43 | 6f 6c 6c 65 63 74 69 6f |.SeriesC|ollectio|
|00001090| 6e 28 6d 2e 69 29 2e 64 | 65 6c 65 74 65 0d 0a 45 |n(m.i).d|elete..E|
|000010a0| 4e 44 46 4f 52 0d 0a 6f | 58 4c 43 68 61 72 74 31 |NDFOR..o|XLChart1|
|000010b0| 2e 61 70 70 6c 69 63 61 | 74 69 6f 6e 2e 63 68 61 |.applica|tion.cha|
|000010c0| 72 74 73 5b 31 5d 2e 68 | 61 73 6c 65 67 65 6e 64 |rts[1].h|aslegend|
|000010d0| 20 3d 20 2e 54 2e 0d 0a | 0d 0a 0d 0a 45 4e 44 50 | = .T...|....ENDP|
|000010e0| 52 4f 43 0d 0a 00 00 00 | 01 00 00 03 b2 fe f2 ff |ROC.....|........|
|000010f0| 1f 02 01 00 00 00 99 03 | 00 00 99 03 00 00 00 00 |........|........|
|00001100| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001110| 00 00 00 00 c1 e2 02 00 | 00 00 25 00 00 00 fa 02 |........|..%.....|
|00001120| 00 00 00 00 00 00 40 03 | 00 00 14 00 00 00 18 03 |......@.|........|
|00001130| 00 00 00 00 00 00 00 00 | 00 00 fc 03 00 03 00 55 |........|.......U|
|00001140| 00 00 21 00 0f 00 34 f7 | 00 00 07 f7 01 00 07 f7 |..!...4.|........|
|00001150| 02 00 fe 0b 00 86 fc 43 | 43 45 ea 78 fd fe 04 00 |.......C|CE.x....|
|00001160| 0b fe 03 00 55 03 00 06 | 00 4e 45 52 52 4f 52 07 |....U...|.NERROR.|
|00001170| 00 43 4d 45 54 48 4f 44 | 05 00 4e 4c 49 4e 45 f5 |.CMETHOD|..NLINE.|
|00001180| 01 0b 00 ae f7 00 00 07 | f7 01 00 fe 07 00 37 f7 |........|......7.|
|00001190| 02 00 fe 1e 00 54 f7 02 | 00 10 fc 43 fb 00 00 fb |.....T..|...C....|
|000011a0| 0b 00 65 78 63 65 6c 2e | 63 68 61 72 74 ea 5c fd |..excel.|chart.\.|
|000011b0| fe 1a 00 54 f4 02 00 f4 | 03 00 e5 04 00 fc f8 01 |...T....|........|
|000011c0| 01 fd 16 f7 05 00 10 fc | 2d fd fe 11 00 54 f4 02 |........|-....T..|
|000011d0| 00 f4 03 00 f7 06 00 10 | fc 61 fd fe 1a 00 99 fc |........|.a......|
|000011e0| 43 43 f8 01 01 f4 02 00 | f4 03 00 e5 07 00 e5 08 |CC......|........|
|000011f0| 00 f7 09 00 fd fe b8 00 | 54 ed 1d 10 fc d9 00 00 |........|T.......|
|00001200| 43 f8 01 09 20 06 d9 04 | 00 43 61 74 73 06 43 f8 |C... ...|.Cats.C.|
|00001210| 01 09 20 06 d9 04 00 44 | 6f 67 73 06 43 f8 02 0d |.. ....D|ogs.C...|
|00001220| 20 06 43 f8 02 0a 20 06 | d9 04 00 31 39 39 34 06 | .C... .|...1994.|
|00001230| 43 f8 01 09 20 06 d9 02 | 00 31 31 06 43 f8 01 09 |C... ...|.11.C...|
|00001240| 20 06 d9 02 00 32 32 06 | 43 f8 02 0d 20 06 43 f8 | ....22.|C... .C.|
|00001250| 02 0a 20 06 d9 04 00 31 | 39 39 35 06 43 f8 01 09 |.. ....1|995.C...|
|00001260| 20 06 d9 02 00 33 33 06 | 43 f8 01 09 20 06 d9 02 | ....33.|C... ...|
|00001270| 00 34 34 06 43 f8 02 0d | 20 06 43 f8 02 0a 20 06 |.44.C...| .C... .|
|00001280| d9 04 00 31 39 39 36 06 | 43 f8 01 09 20 06 d9 02 |...1996.|C... ...|
|00001290| 00 35 35 06 43 f8 01 09 | 20 06 d9 02 00 35 35 06 |.55.C...| ....55.|
|000012a0| 43 f8 02 0d 20 06 43 f8 | 02 0a 20 06 fd fe 25 00 |C... .C.|.. ...%.|
|000012b0| 99 f4 02 00 f4 03 00 e5 | 07 00 fc f8 01 01 fd 03 |........|........|
|000012c0| e5 08 00 fc f8 01 01 fd | 07 fc f8 01 01 fd 03 f7 |........|........|
|000012d0| 0a 00 fe 23 00 99 f4 02 | 00 f4 03 00 e5 04 00 fc |...#....|........|
|000012e0| f8 01 01 fd 16 f6 0b 00 | fc f9 05 fc ef fd 07 fc |........|........|
|000012f0| f8 01 01 fd 03 fe 1e 00 | 54 f7 00 00 10 fc 43 43 |........|T.....CC|
|00001300| f8 01 01 f4 02 00 f4 03 | 00 e5 04 00 e5 0c 00 f7 |........|........|
|00001310| 0d 00 fd fe 20 00 84 f7 | 01 00 10 fc f5 0d f7 00 |.... ...|........|
|00001320| 00 fd 28 fc f8 01 04 fd | c7 fc f9 02 ff ff fd f9 |..(.....|........|
|00001330| 05 d4 01 fe 21 00 99 f4 | 02 00 f4 03 00 e5 04 00 |....!...|........|
|00001340| fc f8 01 01 fd 16 e5 0c | 00 fc f5 0d f7 01 00 fd |........|........|
|00001350| 03 f7 0e 00 fe 04 00 85 | fe 1a 00 54 f4 02 00 f4 |........|...T....|
|00001360| 03 00 e5 04 00 fc f8 01 | 01 fd 16 f7 05 00 10 fc |........|........|
|00001370| 61 fd fe 03 00 55 0f 00 | 0a 00 4e 54 4f 54 53 45 |a....U..|..NTOTSE|
|00001380| 52 49 45 53 01 00 49 09 | 00 4f 58 4c 43 48 41 52 |RIES..I.|.OXLCHAR|
|00001390| 54 31 0b 00 41 50 50 4c | 49 43 41 54 49 4f 4e 06 |T1..APPL|ICATION.|
|000013a0| 00 43 48 41 52 54 53 09 | 00 48 41 53 4c 45 47 45 |.CHARTS.|.HASLEGE|
|000013b0| 4e 44 07 00 56 49 53 49 | 42 4c 45 0a 00 57 4f 52 |ND..VISI|BLE..WOR|
|000013c0| 4b 53 48 45 45 54 53 05 | 00 43 45 4c 4c 53 05 00 |KSHEETS.|.CELLS..|
|000013d0| 43 4c 45 41 52 0c 00 50 | 41 53 54 45 53 50 45 43 |CLEAR..P|ASTESPEC|
|000013e0| 49 41 4c 0a 00 41 55 54 | 4f 46 4f 52 4d 41 54 10 |IAL..AUT|OFORMAT.|
|000013f0| 00 53 45 52 49 45 53 43 | 4f 4c 4c 45 43 54 49 4f |.SERIESC|OLLECTIO|
|00001400| 4e 05 00 43 4f 55 4e 54 | 06 00 44 45 4c 45 54 45 |N..COUNT|..DELETE|
|00001410| 05 00 45 72 72 6f 72 2c | 00 00 00 00 00 ff ff 05 |..Error,|........|
|00001420| 00 43 6c 69 63 6b 69 00 | 00 00 00 00 ff ff 31 00 |.Clicki.|......1.|
|00001430| f1 00 b1 00 41 00 33 00 | b4 00 71 00 e1 01 a1 01 |....A.3.|..q.....|
|00001440| 11 01 a1 01 85 0b 52 02 | 31 02 e3 01 01 02 11 02 |......R.|1.......|
|00001450| 41 00 a1 01 33 00 00 00 | 00 00 00 00 00 00 00 00 |A...3...|........|
|00001460| 00 00 00 00 00 00 01 00 | 00 00 11 00 00 00 52 00 |........|......R.|
|00001470| 00 00 01 00 00 00 05 00 | 00 00 6e 00 00 00 92 03 |........|..n.....|
|00001480| 00 00 07 00 00 00 00 29 | 00 00 00 99 03 00 00 00 |.......)|........|
|00001490| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000014a0| 00 00 01 00 00 00 0c 62 | 65 68 69 6e 64 73 63 65 |.......b|ehindsce|
|000014b0| 6e 65 73 00 00 00 01 00 | 00 00 0f 2e 2e 5c 73 6f |nes.....|.....\so|
|000014c0| 6c 75 74 69 6f 6e 2e 76 | 63 78 00 00 00 01 00 00 |lution.v|cx......|
|000014d0| 00 0d 63 6f 6d 6d 61 6e | 64 62 75 74 74 6f 6e 00 |..comman|dbutton.|
|000014e0| 00 00 01 00 00 00 0d 42 | 65 68 69 6e 64 73 63 65 |.......B|ehindsce|
|000014f0| 6e 65 73 31 00 00 00 01 | 00 00 00 05 46 6f 72 6d |nes1....|....Form|
|00001500| 31 00 00 00 01 00 00 00 | 3c 54 6f 70 20 3d 20 32 |1.......|<Top = 2|
|00001510| 30 33 0d 0a 4c 65 66 74 | 20 3d 20 31 32 0d 0a 54 |03..Left| = 12..T|
|00001520| 61 62 49 6e 64 65 78 20 | 3d 20 33 0d 0a 4e 61 6d |abIndex |= 3..Nam|
|00001530| 65 20 3d 20 22 42 65 68 | 69 6e 64 73 63 65 6e 65 |e = "Beh|indscene|
|00001540| 73 31 22 0d 0a 00 00 00 | 01 00 00 00 0b 63 5f 73 |s1".....|.....c_s|
|00001550| 6f 6c 75 74 69 6f 6e 73 | 00 00 00 01 00 00 00 0f |olutions|........|
|00001560| 2e 2e 5c 73 6f 6c 75 74 | 69 6f 6e 2e 76 63 78 00 |..\solut|ion.vcx.|
|00001570| 00 00 01 00 00 00 06 63 | 75 73 74 6f 6d 00 00 00 |.......c|ustom...|
|00001580| 01 00 00 00 0c 43 5f 73 | 6f 6c 75 74 69 6f 6e 73 |.....C_s|olutions|
|00001590| 31 00 00 00 01 00 00 00 | 05 46 6f 72 6d 31 00 00 |1.......|.Form1..|
|000015a0| 00 01 00 00 00 46 54 6f | 70 20 3d 20 32 30 35 0d |.....FTo|p = 205.|
|000015b0| 0a 4c 65 66 74 20 3d 20 | 36 32 0d 0a 48 65 69 67 |.Left = |62..Heig|
|000015c0| 68 74 20 3d 20 31 38 0d | 0a 57 69 64 74 68 20 3d |ht = 18.|.Width =|
|000015d0| 20 32 35 0d 0a 4e 61 6d | 65 20 3d 20 22 43 5f 73 | 25..Nam|e = "C_s|
|000015e0| 6f 6c 75 74 69 6f 6e 73 | 31 22 0d 0a 00 00 00 01 |olutions|1"......|
|000015f0| 00 00 00 0d 63 6f 6d 6d | 61 6e 64 62 75 74 74 6f |....comm|andbutto|
|00001600| 6e 00 00 00 01 00 00 00 | 0d 63 6f 6d 6d 61 6e 64 |n.......|.command|
|00001610| 62 75 74 74 6f 6e 00 00 | 00 01 00 00 00 08 63 6d |button..|......cm|
|00001620| 64 53 68 65 65 74 00 00 | 00 01 00 00 00 05 46 6f |dSheet..|......Fo|
|00001630| 72 6d 31 00 00 00 01 00 | 00 00 93 54 6f 70 20 3d |rm1.....|...Top =|
|00001640| 20 38 30 0d 0a 4c 65 66 | 74 20 3d 20 32 39 33 0d | 80..Lef|t = 293.|
|00001650| 0a 48 65 69 67 68 74 20 | 3d 20 32 33 0d 0a 57 69 |.Height |= 23..Wi|
|00001660| 64 74 68 20 3d 20 37 32 | 0d 0a 46 6f 6e 74 4e 61 |dth = 72|..FontNa|
|00001670| 6d 65 20 3d 20 22 4d 53 | 20 53 61 6e 73 20 53 65 |me = "MS| Sans Se|
|00001680| 72 69 66 22 0d 0a 46 6f | 6e 74 53 69 7a 65 20 3d |rif"..Fo|ntSize =|
|00001690| 20 38 0d 0a 43 61 70 74 | 69 6f 6e 20 3d 20 22 45 | 8..Capt|ion = "E|
|000016a0| 78 61 6d 70 6c 65 20 5c | 3c 31 22 0d 0a 54 61 62 |xample \|<1"..Tab|
|000016b0| 49 6e 64 65 78 20 3d 20 | 31 0d 0a 4e 61 6d 65 20 |Index = |1..Name |
|000016c0| 3d 20 22 63 6d 64 53 68 | 65 65 74 22 0d 0a 00 00 |= "cmdSh|eet"....|
|000016d0| 00 01 00 00 07 1e 50 52 | 4f 43 45 44 55 52 45 20 |......PR|OCEDURE |
|000016e0| 43 6c 69 63 6b 0d 0a 2a | 20 54 68 69 73 20 70 72 |Click..*| This pr|
|000016f0| 6f 67 72 61 6d 20 73 65 | 6e 64 73 20 74 68 65 20 |ogram se|nds the |
|00001700| 72 65 73 75 6c 74 73 20 | 6f 66 20 61 20 63 72 6f |results |of a cro|
|00001710| 73 73 74 61 62 20 71 75 | 65 72 79 20 74 6f 20 0d |sstab qu|ery to .|
|00001720| 0a 2a 20 4d 69 63 72 6f | 73 6f 66 74 20 45 78 63 |.* Micro|soft Exc|
|00001730| 65 6c 20 74 6f 20 63 61 | 6c 63 75 6c 61 74 65 20 |el to ca|lculate |
|00001740| 53 61 6c 65 73 20 74 72 | 65 6e 64 73 20 66 6f 72 |Sales tr|ends for|
|00001750| 20 70 72 6f 64 75 63 74 | 73 0d 0a 2a 20 69 6e 20 | product|s..* in |
|00001760| 74 68 65 20 54 45 53 54 | 44 41 54 41 20 64 61 74 |the TEST|DATA dat|
|00001770| 61 62 61 73 65 2e 20 54 | 68 65 20 74 72 65 6e 64 |abase. T|he trend|
|00001780| 20 69 6e 66 6f 72 6d 61 | 74 69 6f 6e 20 69 73 20 | informa|tion is |
|00001790| 0d 0a 2a 20 72 65 74 72 | 69 65 76 65 64 20 66 72 |..* retr|ieved fr|
|000017a0| 6f 6d 20 45 78 63 65 6c | 2e 0d 0a 0d 0a 4c 4f 43 |om Excel|.....LOC|
|000017b0| 41 4c 20 69 2c 6a 2c 54 | 72 65 6e 64 46 75 6e 63 |AL i,j,T|rendFunc|
|000017c0| 2c 78 6c 73 68 65 65 74 | 2c 58 4c 41 70 70 2c 74 |,xlsheet|,XLApp,t|
|000017d0| 6d 70 73 68 65 65 74 0d | 0a 0d 0a 57 41 49 54 20 |mpsheet.|...WAIT |
|000017e0| 57 49 4e 44 4f 57 20 22 | 51 75 65 72 79 69 6e 67 |WINDOW "|Querying|
|000017f0| 20 73 61 6c 65 73 20 64 | 61 74 61 2e 2e 2e 22 20 | sales d|ata..." |
|00001800| 4e 4f 57 41 49 54 20 0d | 0a 0d 0a 6f 70 65 6e 20 |NOWAIT .|...open |
|00001810| 64 61 74 61 20 28 48 4f | 4d 45 28 29 2b 22 73 61 |data (HO|ME()+"sa|
|00001820| 6d 70 6c 65 73 5c 64 61 | 74 61 5c 74 65 73 74 64 |mples\da|ta\testd|
|00001830| 61 74 61 2e 64 62 63 22 | 29 0d 0a 0d 0a 53 45 4c |ata.dbc"|)....SEL|
|00001840| 45 43 54 20 50 72 6f 64 | 75 63 74 73 2e 70 72 6f |ECT Prod|ucts.pro|
|00001850| 64 5f 6e 61 6d 65 2c 20 | 4d 4f 4e 54 48 28 4f 72 |d_name, |MONTH(Or|
|00001860| 64 65 72 73 2e 6f 72 64 | 65 72 5f 64 61 74 65 29 |ders.ord|er_date)|
|00001870| 2c 3b 0d 0a 20 20 53 55 | 4d 28 4f 72 64 69 74 65 |,;..  SU|M(Ordite|
|00001880| 6d 73 2e 71 75 61 6e 74 | 69 74 79 29 3b 0d 0a 20 |ms.quant|ity);.. |
|00001890| 46 52 4f 4d 20 74 65 73 | 74 64 61 74 61 21 6f 72 |FROM tes|tdata!or|
|000018a0| 64 65 72 73 2c 20 74 65 | 73 74 64 61 74 61 21 6f |ders, te|stdata!o|
|000018b0| 72 64 69 74 65 6d 73 2c | 20 74 65 73 74 64 61 74 |rditems,| testdat|
|000018c0| 61 21 70 72 6f 64 75 63 | 74 73 3b 0d 0a 20 57 48 |a!produc|ts;.. WH|
|000018d0| 45 52 45 20 4f 72 64 65 | 72 73 2e 6f 72 64 65 72 |ERE Orde|rs.order|
|000018e0| 5f 69 64 20 3d 20 4f 72 | 64 69 74 65 6d 73 2e 6f |_id = Or|ditems.o|
|000018f0| 72 64 65 72 5f 69 64 3b | 0d 0a 20 20 20 41 4e 44 |rder_id;|..   AND|
|00001900| 20 50 72 6f 64 75 63 74 | 73 2e 70 72 6f 64 75 63 | Product|s.produc|
|00001910| 74 5f 69 64 20 3d 20 4f | 72 64 69 74 65 6d 73 2e |t_id = O|rditems.|
|00001920| 70 72 6f 64 75 63 74 5f | 69 64 3b 0d 0a 20 20 20 |product_|id;..   |
|00001930| 41 4e 44 20 4f 72 64 65 | 72 73 2e 6f 72 64 65 72 |AND Orde|rs.order|
|00001940| 5f 64 61 74 65 20 3e 20 | 43 54 4f 44 28 22 31 32 |_date > |CTOD("12|
|00001950| 2f 33 31 2f 39 34 22 29 | 3b 0d 0a 20 47 52 4f 55 |/31/94")|;.. GROU|
|00001960| 50 20 42 59 20 4f 72 64 | 69 74 65 6d 73 2e 70 72 |P BY Ord|items.pr|
|00001970| 6f 64 75 63 74 5f 69 64 | 2c 20 32 2c 20 50 72 6f |oduct_id|, 2, Pro|
|00001980| 64 75 63 74 73 2e 70 72 | 6f 64 5f 6e 61 6d 65 3b |ducts.pr|od_name;|
|00001990| 0d 0a 20 4f 52 44 45 52 | 20 42 59 20 50 72 6f 64 |.. ORDER| BY Prod|
|000019a0| 75 63 74 73 2e 70 72 6f | 64 5f 6e 61 6d 65 2c 20 |ucts.pro|d_name, |
|000019b0| 32 3b 0d 0a 20 49 4e 54 | 4f 20 43 55 52 53 4f 52 |2;.. INT|O CURSOR|
|000019c0| 20 63 75 72 53 61 6c 65 | 73 44 61 74 61 0d 0a 20 | curSale|sData.. |
|000019d0| 0d 0a 20 44 4f 20 28 5f | 47 45 4e 58 54 41 42 29 |.. DO (_|GENXTAB)|
|000019e0| 20 57 49 54 48 20 27 63 | 74 61 62 53 61 6c 65 73 | WITH 'c|tabSales|
|000019f0| 44 61 74 61 27 0d 0a 0d | 0a 53 45 4c 45 43 54 20 |Data'...|.SELECT |
|00001a00| 2a 2c 20 4e 5f 31 20 66 | 72 6f 6d 20 63 74 61 62 |*, N_1 f|rom ctab|
|00001a10| 53 61 6c 65 73 44 61 74 | 61 20 49 4e 54 4f 20 41 |SalesDat|a INTO A|
|00001a20| 52 52 41 59 20 61 72 72 | 53 61 6c 65 73 44 61 74 |RRAY arr|SalesDat|
|00001a30| 61 0d 0a 0d 0a 57 41 49 | 54 20 57 49 4e 44 4f 57 |a....WAI|T WINDOW|
|00001a40| 20 22 53 74 61 72 74 69 | 6e 67 20 45 78 63 65 6c | "Starti|ng Excel|
|00001a50| 2e 2e 2e 22 20 4e 4f 57 | 41 49 54 20 0d 0a 0d 0a |..." NOW|AIT ....|
|00001a60| 74 6d 70 73 68 65 65 74 | 20 3d 20 47 65 74 4f 62 |tmpsheet| = GetOb|
|00001a70| 6a 65 63 74 28 27 27 2c | 27 65 78 63 65 6c 2e 73 |ject('',|'excel.s|
|00001a80| 68 65 65 74 27 29 0d 0a | 0d 0a 58 4c 41 70 70 20 |heet')..|..XLApp |
|00001a90| 3d 20 74 6d 70 73 68 65 | 65 74 2e 61 70 70 6c 69 |= tmpshe|et.appli|
|00001aa0| 63 61 74 69 6f 6e 0d 0a | 0d 0a 58 4c 41 70 70 2e |cation..|..XLApp.|
|00001ab0| 56 69 73 69 62 6c 65 20 | 3d 20 2e 74 2e 0d 0a 58 |Visible |= .t...X|
|00001ac0| 4c 41 70 70 2e 57 6f 72 | 6b 42 6f 6f 6b 73 2e 41 |LApp.Wor|kBooks.A|
|00001ad0| 64 64 28 29 0d 0a 58 4c | 53 68 65 65 74 20 3d 20 |dd()..XL|Sheet = |
|00001ae0| 58 4c 41 70 70 2e 41 63 | 74 69 76 65 53 68 65 65 |XLApp.Ac|tiveShee|
|00001af0| 74 0d 0a 0d 0a 58 4c 53 | 68 65 65 74 2e 43 65 6c |t....XLS|heet.Cel|
|00001b00| 6c 73 28 31 2c 31 29 2e | 56 61 6c 75 65 20 3d 20 |ls(1,1).|Value = |
|00001b10| 22 50 72 6f 64 75 63 74 | 22 0d 0a 58 4c 53 68 65 |"Product|"..XLShe|
|00001b20| 65 74 2e 43 65 6c 6c 73 | 28 31 2c 32 29 2e 56 61 |et.Cells|(1,2).Va|
|00001b30| 6c 75 65 20 3d 20 22 53 | 61 6c 65 73 20 2d 20 4a |lue = "S|ales - J|
|00001b40| 61 6e 22 0d 0a 58 4c 53 | 68 65 65 74 2e 43 65 6c |an"..XLS|heet.Cel|
|00001b50| 6c 73 28 31 2c 33 29 2e | 56 61 6c 75 65 20 3d 20 |ls(1,3).|Value = |
|00001b60| 22 53 61 6c 65 73 20 2d | 20 46 65 62 22 0d 0a 58 |"Sales -| Feb"..X|
|00001b70| 4c 53 68 65 65 74 2e 43 | 65 6c 6c 73 28 31 2c 34 |LSheet.C|ells(1,4|
|00001b80| 29 2e 56 61 6c 75 65 20 | 3d 20 22 53 61 6c 65 73 |).Value |= "Sales|
|00001b90| 20 2d 20 4d 61 72 22 0d | 0a 58 4c 53 68 65 65 74 | - Mar".|.XLSheet|
|00001ba0| 2e 43 65 6c 6c 73 28 31 | 2c 35 29 2e 56 61 6c 75 |.Cells(1|,5).Valu|
|00001bb0| 65 20 3d 20 22 54 72 65 | 6e 64 22 0d 0a 0d 0a 46 |e = "Tre|nd"....F|
|00001bc0| 4f 52 20 69 20 3d 20 31 | 20 74 6f 20 31 30 0d 0a |OR i = 1| to 10..|
|00001bd0| 09 46 4f 52 20 6a 20 3d | 20 31 20 74 6f 20 34 0d |.FOR j =| 1 to 4.|
|00001be0| 0a 09 09 49 46 20 49 53 | 4e 55 4c 4c 20 28 61 72 |...IF IS|NULL (ar|
|00001bf0| 72 53 61 6c 65 73 44 61 | 74 61 28 69 2c 6a 29 29 |rSalesDa|ta(i,j))|
|00001c00| 20 54 48 45 4e 0d 0a 09 | 09 09 58 4c 53 68 65 65 | THEN...|..XLShee|
|00001c10| 74 2e 43 65 6c 6c 73 28 | 69 2b 31 2c 6a 29 2e 56 |t.Cells(|i+1,j).V|
|00001c20| 61 6c 75 65 20 3d 20 30 | 0d 0a 09 09 45 4c 53 45 |alue = 0|....ELSE|
|00001c30| 0d 0a 09 09 09 58 4c 53 | 68 65 65 74 2e 43 65 6c |.....XLS|heet.Cel|
|00001c40| 6c 73 28 69 2b 31 2c 6a | 29 2e 56 61 6c 75 65 20 |ls(i+1,j|).Value |
|00001c50| 3d 20 61 72 72 53 61 6c | 65 73 44 61 74 61 28 69 |= arrSal|esData(i|
|00001c60| 2c 6a 29 0d 0a 09 09 45 | 4e 44 49 46 0d 0a 09 45 |,j)....E|NDIF...E|
|00001c70| 4e 44 46 4f 52 0d 0a 09 | 54 72 65 6e 64 46 75 6e |NDFOR...|TrendFun|
|00001c80| 63 20 3d 20 22 3d 54 52 | 45 4e 44 28 42 22 20 2b |c = "=TR|END(B" +|
|00001c90| 20 4c 54 52 49 4d 28 53 | 54 52 28 69 2b 31 29 29 | LTRIM(S|TR(i+1))|
|00001ca0| 20 2b 20 22 3a 44 22 20 | 2b 20 4c 54 52 49 4d 28 | + ":D" |+ LTRIM(|
|00001cb0| 53 54 52 28 69 2b 31 29 | 29 20 2b 20 22 2c 2c 34 |STR(i+1)|) + ",,4|
|00001cc0| 29 22 0d 0a 09 58 4c 53 | 68 65 65 74 2e 43 65 6c |)"...XLS|heet.Cel|
|00001cd0| 6c 73 28 69 2b 31 2c 35 | 29 2e 56 61 6c 75 65 20 |ls(i+1,5|).Value |
|00001ce0| 3d 20 54 72 65 6e 64 46 | 75 6e 63 0d 0a 45 4e 44 |= TrendF|unc..END|
|00001cf0| 46 4f 52 0d 0a 0d 0a 46 | 4f 52 20 69 20 3d 20 31 |FOR....F|OR i = 1|
|00001d00| 20 74 6f 20 31 30 0d 0a | 09 49 46 20 58 4c 53 68 | to 10..|.IF XLSh|
|00001d10| 65 65 74 2e 43 65 6c 6c | 73 28 69 2b 31 2c 35 29 |eet.Cell|s(i+1,5)|
|00001d20| 2e 56 61 6c 75 65 20 3c | 20 30 20 54 48 45 4e 0d |.Value <| 0 THEN.|
|00001d30| 0a 09 09 58 4c 53 68 65 | 65 74 2e 43 65 6c 6c 73 |...XLShe|et.Cells|
|00001d40| 28 69 2b 31 2c 35 29 2e | 56 61 6c 75 65 20 3d 20 |(i+1,5).|Value = |
|00001d50| 30 0d 0a 09 45 4c 53 45 | 20 0d 0a 09 09 58 4c 53 |0...ELSE| ....XLS|
|00001d60| 68 65 65 74 2e 43 65 6c | 6c 73 28 69 2b 31 2c 35 |heet.Cel|ls(i+1,5|
|00001d70| 29 2e 56 61 6c 75 65 20 | 3d 20 49 4e 54 28 58 4c |).Value |= INT(XL|
|00001d80| 53 68 65 65 74 2e 43 65 | 6c 6c 73 28 69 2b 31 2c |Sheet.Ce|lls(i+1,|
|00001d90| 35 29 2e 56 61 6c 75 65 | 29 0d 0a 09 45 4e 44 49 |5).Value|)...ENDI|
|00001da0| 46 0d 0a 45 4e 44 46 4f | 52 0d 0a 0d 0a 57 41 49 |F..ENDFO|R....WAI|
|00001db0| 54 20 57 49 4e 44 4f 57 | 20 22 54 72 65 6e 64 20 |T WINDOW| "Trend |
|00001dc0| 44 61 74 61 20 52 65 74 | 72 69 65 76 65 64 22 20 |Data Ret|rieved" |
|00001dd0| 54 49 4d 45 4f 55 54 20 | 32 0d 0a 43 4c 4f 53 45 |TIMEOUT |2..CLOSE|
|00001de0| 20 44 41 54 41 0d 0a 0d | 0a 0d 0a 45 4e 44 50 52 | DATA...|...ENDPR|
|00001df0| 4f 43 0d 0a 00 00 00 01 | 00 00 06 6f fe f2 ff 1f |OC......|...o....|
|00001e00| 02 01 00 00 00 56 06 00 | 00 56 06 00 00 00 00 00 |.....V..|.V......|
|00001e10| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001e20| 00 00 00 89 5a 01 00 00 | 00 25 00 00 00 b0 05 00 |....Z...|.%......|
|00001e30| 00 00 00 00 00 0d 06 00 | 00 27 00 00 00 bf 05 00 |........|.'......|
|00001e40| 00 00 00 00 00 00 00 00 | 00 fc 03 00 03 00 55 00 |........|......U.|
|00001e50| 00 87 04 1b 00 ae f7 00 | 00 07 f7 01 00 07 f7 02 |........|........|
|00001e60| 00 07 f7 03 00 07 f7 04 | 00 07 f7 05 00 fe 21 00 |........|......!.|
|00001e70| 52 2c 3a fc d9 16 00 51 | 75 65 72 79 69 6e 67 20 |R,:....Q|uerying |
|00001e80| 73 61 6c 65 73 20 64 61 | 74 61 2e 2e 2e fd fe 28 |sales da|ta.....(|
|00001e90| 00 95 c2 fc 43 ea 51 d9 | 19 00 73 61 6d 70 6c 65 |....C.Q.|..sample|
|00001ea0| 73 5c 64 61 74 61 5c 74 | 65 73 74 64 61 74 61 2e |s\data\t|estdata.|
|00001eb0| 64 62 63 06 03 fd fe d1 | 00 6f 15 fb 0f 00 74 65 |dbc.....|.o....te|
|00001ec0| 73 74 64 61 74 61 21 6f | 72 64 65 72 73 07 fb 11 |stdata!o|rders...|
|00001ed0| 00 74 65 73 74 64 61 74 | 61 21 6f 72 64 69 74 65 |.testdat|a!ordite|
|00001ee0| 6d 73 07 fb 11 00 74 65 | 73 74 64 61 74 61 21 70 |ms....te|stdata!p|
|00001ef0| 72 6f 64 75 63 74 73 fc | f4 06 00 f7 07 00 fd 07 |roducts.|........|
|00001f00| fc 43 f4 08 00 f7 09 00 | 48 fd 07 fc 43 f4 0a 00 |.C......|H...C...|
|00001f10| f7 0b 00 ea fa fd c6 fc | f4 08 00 f7 0d 00 f4 0a |........|........|
|00001f20| 00 f7 0d 00 10 f0 0e 00 | f4 06 00 f7 0e 00 f4 0a |........|........|
|00001f30| 00 f7 0e 00 10 09 f0 15 | 00 f4 08 00 f7 09 00 43 |........|.......C|
|00001f40| d9 08 00 31 32 2f 33 31 | 2f 39 34 23 11 09 fd bf |...12/31|/94#....|
|00001f50| fc f4 0a 00 f7 0e 00 fd | 07 fc f8 01 02 fd 07 fc |........|........|
|00001f60| f4 06 00 f7 07 00 fd c3 | fc f4 06 00 f7 07 00 fd |........|........|
|00001f70| 07 fc f8 01 02 fd bc bd | fb 0c 00 63 75 72 53 61 |........|...curSa|
|00001f80| 6c 65 73 44 61 74 61 fe | 1c 00 18 fc ed 29 03 fd |lesData.|.....)..|
|00001f90| d1 fc fb 0d 00 63 74 61 | 62 53 61 6c 65 73 44 61 |.....cta|bSalesDa|
|00001fa0| 74 61 fd fe 21 00 6f 15 | fb 0d 00 63 74 61 62 53 |ta..!.o.|...ctabS|
|00001fb0| 61 6c 65 73 44 61 74 61 | c7 07 fc f7 10 00 fd bc |alesData|........|
|00001fc0| 04 f7 12 00 fe 1c 00 52 | 2c 3a fc d9 11 00 53 74 |.......R|,:....St|
|00001fd0| 61 72 74 69 6e 67 20 45 | 78 63 65 6c 2e 2e 2e fd |arting E|xcel....|
|00001fe0| fe 1e 00 54 f7 05 00 10 | fc 43 fb 00 00 fb 0b 00 |...T....|.C......|
|00001ff0| 65 78 63 65 6c 2e 73 68 | 65 65 74 ea 5c fd fe 10 |excel.sh|eet.\...|
|00002000| 00 54 f7 04 00 10 fc f4 | 05 00 f7 13 00 fd fe 0e |.T......|........|
|00002010| 00 54 f4 04 00 f7 14 00 | 10 fc 61 fd fe 10 00 99 |.T......|..a.....|
|00002020| fc 43 f4 04 00 f4 15 00 | f6 16 00 fd fe 10 00 54 |.C......|.......T|
|00002030| f7 03 00 10 fc f4 04 00 | f7 17 00 fd fe 26 00 54 |........|.....&.T|
|00002040| f4 03 00 e5 18 00 fc f8 | 01 01 fd 07 fc f8 01 01 |........|........|
|00002050| fd 03 f7 19 00 10 fc d9 | 07 00 50 72 6f 64 75 63 |........|..Produc|
|00002060| 74 fd fe 2a 00 54 f4 03 | 00 e5 18 00 fc f8 01 01 |t..*.T..|........|
|00002070| fd 07 fc f8 01 02 fd 03 | f7 19 00 10 fc d9 0b 00 |........|........|
|00002080| 53 61 6c 65 73 20 2d 20 | 4a 61 6e fd fe 2a 00 54 |Sales - |Jan..*.T|
|00002090| f4 03 00 e5 18 00 fc f8 | 01 01 fd 07 fc f8 01 03 |........|........|
|000020a0| fd 03 f7 19 00 10 fc d9 | 0b 00 53 61 6c 65 73 20 |........|..Sales |
|000020b0| 2d 20 46 65 62 fd fe 2a | 00 54 f4 03 00 e5 18 00 |- Feb..*|.T......|
|000020c0| fc f8 01 01 fd 07 fc f8 | 01 04 fd 03 f7 19 00 10 |........|........|
|000020d0| fc d9 0b 00 53 61 6c 65 | 73 20 2d 20 4d 61 72 fd |....Sale|s - Mar.|
|000020e0| fe 24 00 54 f4 03 00 e5 | 18 00 fc f8 01 01 fd 07 |.$.T....|........|
|000020f0| fc f8 01 05 fd 03 f7 19 | 00 10 fc d9 05 00 54 72 |........|......Tr|
|00002100| 65 6e 64 fd fe 17 00 84 | f7 00 00 10 fc f8 01 01 |end.....|........|
|00002110| fd 28 fc f8 02 0a fd f9 | 05 b5 03 fe 17 00 84 f7 |.(......|........|
|00002120| 01 00 10 fc f8 01 01 fd | 28 fc f8 01 04 fd f9 05 |........|(.......|
|00002130| 53 03 fe 18 00 25 fc 43 | 43 00 f7 00 00 00 f7 01 |S....%.C|C.......|
|00002140| 00 f6 12 00 d1 fd f9 05 | 1b 03 fe 23 00 54 f4 03 |........|...#.T..|
|00002150| 00 e5 18 00 fc f7 00 00 | f8 01 01 06 fd 07 fc f7 |........|........|
|00002160| 01 00 fd 03 f7 19 00 10 | fc f8 01 00 fd fe 08 00 |........|........|
|00002170| 1b f9 05 4f 03 fe 2c 00 | 54 f4 03 00 e5 18 00 fc |...O..,.|T.......|
|00002180| f7 00 00 f8 01 01 06 fd | 07 fc f7 01 00 fd 03 f7 |........|........|
|00002190| 19 00 10 fc 43 00 f7 00 | 00 00 f7 01 00 f6 12 00 |....C...|........|
|000021a0| fd fe 04 00 1e fe 04 00 | 85 fe 3b 00 54 f7 02 00 |........|..;.T...|
|000021b0| 10 fc d9 08 00 3d 54 52 | 45 4e 44 28 42 43 43 f7 |.....=TR|END(BCC.|
|000021c0| 00 00 f8 01 01 06 5a 41 | 06 d9 02 00 3a 44 06 43 |......ZA|....:D.C|
|000021d0| 43 f7 00 00 f8 01 01 06 | 5a 41 06 d9 04 00 2c 2c |C.......|ZA....,,|
|000021e0| 34 29 06 fd fe 23 00 54 | f4 03 00 e5 18 00 fc f7 |4)...#.T|........|
|000021f0| 00 00 f8 01 01 06 fd 07 | fc f8 01 05 fd 03 f7 19 |........|........|
|00002200| 00 10 fc f7 02 00 fd fe | 04 00 85 fe 17 00 84 f7 |........|........|
|00002210| 00 00 10 fc f8 01 01 fd | 28 fc f8 02 0a fd f9 05 |........|(.......|
|00002220| 57 04 fe 22 00 25 fc 43 | f7 00 00 f8 01 01 06 f8 |W..".%.C|........|
|00002230| 01 05 f4 03 00 e5 18 00 | f7 19 00 f8 01 00 0d fd |........|........|
|00002240| f9 05 15 04 fe 23 00 54 | f4 03 00 e5 18 00 fc f7 |.....#.T|........|
|00002250| 00 00 f8 01 01 06 fd 07 | fc f8 01 05 fd 03 f7 19 |........|........|
|00002260| 00 10 fc f8 01 00 fd fe | 08 00 1b f9 05 53 04 fe |........|.....S..|
|00002270| 36 00 54 f4 03 00 e5 18 | 00 fc f7 00 00 f8 01 01 |6.T.....|........|
|00002280| 06 fd 07 fc f8 01 05 fd | 03 f7 19 00 10 fc 43 43 |........|......CC|
|00002290| f7 00 00 f8 01 01 06 f8 | 01 05 f4 03 00 e5 18 00 |........|........|
|000022a0| f7 19 00 38 fd fe 04 00 | 1e fe 04 00 85 fe 24 00 |...8....|......$.|
|000022b0| 52 2c ce fc f8 01 02 fd | fc d9 14 00 54 72 65 6e |R,......|....Tren|
|000022c0| 64 20 44 61 74 61 20 52 | 65 74 72 69 65 76 65 64 |d Data R|etrieved|
|000022d0| fd fe 05 00 0f c2 fe 03 | 00 55 1a 00 01 00 49 01 |........|.U....I.|
|000022e0| 00 4a 09 00 54 52 45 4e | 44 46 55 4e 43 07 00 58 |.J..TREN|DFUNC..X|
|000022f0| 4c 53 48 45 45 54 05 00 | 58 4c 41 50 50 08 00 54 |LSHEET..|XLAPP..T|
|00002300| 4d 50 53 48 45 45 54 08 | 00 50 52 4f 44 55 43 54 |MPSHEET.|.PRODUCT|
|00002310| 53 09 00 50 52 4f 44 5f | 4e 41 4d 45 06 00 4f 52 |S..PROD_|NAME..OR|
|00002320| 44 45 52 53 0a 00 4f 52 | 44 45 52 5f 44 41 54 45 |DERS..OR|DER_DATE|
|00002330| 08 00 4f 52 44 49 54 45 | 4d 53 08 00 51 55 41 4e |..ORDITE|MS..QUAN|
|00002340| 54 49 54 59 08 00 54 45 | 53 54 44 41 54 41 08 00 |TITY..TE|STDATA..|
|00002350| 4f 52 44 45 52 5f 49 44 | 0a 00 50 52 4f 44 55 43 |ORDER_ID|..PRODUC|
|00002360| 54 5f 49 44 0c 00 43 55 | 52 53 41 4c 45 53 44 41 |T_ID..CU|RSALESDA|
|00002370| 54 41 03 00 4e 5f 31 0d | 00 43 54 41 42 53 41 4c |TA..N_1.|.CTABSAL|
|00002380| 45 53 44 41 54 41 0c 00 | 41 52 52 53 41 4c 45 53 |ESDATA..|ARRSALES|
|00002390| 44 41 54 41 0b 00 41 50 | 50 4c 49 43 41 54 49 4f |DATA..AP|PLICATIO|
|000023a0| 4e 07 00 56 49 53 49 42 | 4c 45 09 00 57 4f 52 4b |N..VISIB|LE..WORK|
|000023b0| 42 4f 4f 4b 53 03 00 41 | 44 44 0b 00 41 43 54 49 |BOOKS..A|DD..ACTI|
|000023c0| 56 45 53 48 45 45 54 05 | 00 43 45 4c 4c 53 05 00 |VESHEET.|.CELLS..|
|000023d0| 56 41 4c 55 45 05 00 43 | 6c 69 63 6b 2c 00 00 00 |VALUE..C|lick,...|
|000023e0| 00 00 ff ff 31 00 b6 01 | 12 02 82 02 1a 0d c2 01 |....1...|........|
|000023f0| 12 02 c2 01 e2 01 02 01 | e2 00 01 01 01 01 62 02 |........|......b.|
|00002400| a1 02 a1 02 a1 02 41 02 | 72 01 71 01 81 01 31 02 |......A.|r.q...1.|
|00002410| 81 00 c1 02 41 00 41 00 | b1 03 31 02 41 00 72 01 |....A.A.|..1.A.r.|
|00002420| 21 02 31 02 81 00 61 03 | 41 00 41 00 42 02 51 00 |!.1...a.|A.A.B.Q.|
|00002430| 33 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |3.......|........|
|00002440| 00 00 01 00 00 00 11 00 | 00 00 13 07 00 00 01 00 |........|........|
|00002450| 00 00 00 29 00 00 00 56 | 06 00 00 00 00 00 00 00 |...)...V|........|
|00002460| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 01 00 |........|........|
|00002470| 00 00 08 63 6d 64 63 6c | 6f 73 65 00 00 00 01 00 |...cmdcl|ose.....|
|00002480| 00 00 0f 2e 2e 5c 73 6f | 6c 75 74 69 6f 6e 2e 76 |.....\so|lution.v|
|00002490| 63 78 00 00 00 01 00 00 | 00 0d 63 6f 6d 6d 61 6e |cx......|..comman|
|000024a0| 64 62 75 74 74 6f 6e 00 | 00 00 01 00 00 00 09 43 |dbutton.|.......C|
|000024b0| 6d 64 63 6c 6f 73 65 31 | 00 00 00 01 00 00 00 05 |mdclose1|........|
|000024c0| 46 6f 72 6d 31 00 00 00 | 01 00 00 00 52 54 6f 70 |Form1...|....RTop|
|000024d0| 20 3d 20 32 30 33 0d 0a | 4c 65 66 74 20 3d 20 33 | = 203..|Left = 3|
|000024e0| 30 31 0d 0a 48 65 69 67 | 68 74 20 3d 20 32 33 0d |01..Heig|ht = 23.|
|000024f0| 0a 57 69 64 74 68 20 3d | 20 37 32 0d 0a 54 61 62 |.Width =| 72..Tab|
|00002500| 49 6e 64 65 78 20 3d 20 | 34 0d 0a 4e 61 6d 65 20 |Index = |4..Name |
|00002510| 3d 20 22 43 6d 64 63 6c | 6f 73 65 31 22 0d 0a 00 |= "Cmdcl|ose1"...|
|00002520| 00 00 01 00 00 00 05 73 | 68 61 70 65 00 00 00 01 |.......s|hape....|
|00002530| 00 00 00 05 73 68 61 70 | 65 00 00 00 01 00 00 00 |....shap|e.......|
|00002540| 06 53 68 61 70 65 32 00 | 00 00 01 00 00 00 05 46 |.Shape2.|.......F|
|00002550| 6f 72 6d 31 00 00 00 01 | 00 00 00 62 54 6f 70 20 |orm1....|...bTop |
|00002560| 3d 20 31 33 0d 0a 4c 65 | 66 74 20 3d 20 31 31 0d |= 13..Le|ft = 11.|
|00002570| 0a 48 65 69 67 68 74 20 | 3d 20 34 34 0d 0a 57 69 |.Height |= 44..Wi|
|00002580| 64 74 68 20 3d 20 33 36 | 33 0d 0a 42 61 63 6b 53 |dth = 36|3..BackS|
|00002590| 74 79 6c 65 20 3d 20 30 | 0d 0a 53 70 65 63 69 61 |tyle = 0|..Specia|
|000025a0| 6c 45 66 66 65 63 74 20 | 3d 20 30 0d 0a 4e 61 6d |lEffect |= 0..Nam|
|000025b0| 65 20 3d 20 22 53 68 61 | 70 65 32 22 0d 0a 00 00 |e = "Sha|pe2"....|
|000025c0| 00 01 00 00 00 05 6c 61 | 62 65 6c 00 00 00 01 00 |......la|bel.....|
|000025d0| 00 00 05 6c 61 62 65 6c | 00 00 00 01 00 00 00 06 |...label|........|
|000025e0| 4c 61 62 65 6c 35 00 00 | 00 01 00 00 00 05 46 6f |Label5..|......Fo|
|000025f0| 72 6d 31 00 00 00 01 00 | 00 00 e7 46 6f 6e 74 4e |rm1.....|...FontN|
|00002600| 61 6d 65 20 3d 20 22 4d | 53 20 53 61 6e 73 20 53 |ame = "M|S Sans S|
|00002610| 65 72 69 66 22 0d 0a 46 | 6f 6e 74 53 69 7a 65 20 |erif"..F|ontSize |
|00002620| 3d 20 38 0d 0a 57 6f 72 | 64 57 72 61 70 20 3d 20 |= 8..Wor|dWrap = |
|00002630| 2e 54 2e 0d 0a 43 61 70 | 74 69 6f 6e 20 3d 20 22 |.T...Cap|tion = "|
|00002640| 59 6f 75 20 63 61 6e 20 | 63 6f 6e 74 72 6f 6c 20 |You can |control |
|00002650| 6f 74 68 65 72 20 61 70 | 70 6c 69 63 61 74 69 6f |other ap|plicatio|
|00002660| 6e 73 2c 20 73 75 63 68 | 20 61 73 20 4d 69 63 72 |ns, such| as Micr|
|00002670| 6f 73 6f 66 74 20 45 78 | 63 65 6c 2c 20 77 69 74 |osoft Ex|cel, wit|
|00002680| 68 20 4f 4c 45 20 41 75 | 74 6f 6d 61 74 69 6f 6e |h OLE Au|tomation|
|00002690| 2e 22 0d 0a 48 65 69 67 | 68 74 20 3d 20 32 36 0d |."..Heig|ht = 26.|
|000026a0| 0a 4c 65 66 74 20 3d 20 | 32 30 0d 0a 54 6f 70 20 |.Left = |20..Top |
|000026b0| 3d 20 32 33 0d 0a 57 69 | 64 74 68 20 3d 20 33 34 |= 23..Wi|dth = 34|
|000026c0| 33 0d 0a 54 61 62 49 6e | 64 65 78 20 3d 20 30 0d |3..TabIn|dex = 0.|
|000026d0| 0a 4e 61 6d 65 20 3d 20 | 22 4c 61 62 65 6c 35 22 |.Name = |"Label5"|
|000026e0| 0d 0a 00 00 00 01 00 00 | 00 05 6c 61 62 65 6c 00 |........|..label.|
|000026f0| 00 00 01 00 00 00 05 6c | 61 62 65 6c 00 00 00 01 |.......l|abel....|
|00002700| 00 00 00 06 4c 61 62 65 | 6c 36 00 00 00 01 00 00 |....Labe|l6......|
|00002710| 00 05 46 6f 72 6d 31 00 | 00 00 01 00 00 00 a2 41 |..Form1.|.......A|
|00002720| 75 74 6f 53 69 7a 65 20 | 3d 20 2e 54 2e 0d 0a 46 |utoSize |= .T...F|
|00002730| 6f 6e 74 4e 61 6d 65 20 | 3d 20 22 4d 53 20 53 61 |ontName |= "MS Sa|
|00002740| 6e 73 20 53 65 72 69 66 | 22 0d 0a 46 6f 6e 74 53 |ns Serif|"..FontS|
|00002750| 69 7a 65 20 3d 20 38 0d | 0a 43 61 70 74 69 6f 6e |ize = 8.|.Caption|
|00002760| 20 3d 20 22 20 49 6e 73 | 74 72 75 63 74 69 6f 6e | = " Ins|truction|
|00002770| 73 20 22 0d 0a 48 65 69 | 67 68 74 20 3d 20 31 35 |s "..Hei|ght = 15|
|00002780| 0d 0a 4c 65 66 74 20 3d | 20 31 39 0d 0a 54 6f 70 |..Left =| 19..Top|
|00002790| 20 3d 20 37 0d 0a 57 69 | 64 74 68 20 3d 20 36 32 | = 7..Wi|dth = 62|
|000027a0| 0d 0a 54 61 62 49 6e 64 | 65 78 20 3d 20 30 0d 0a |..TabInd|ex = 0..|
|000027b0| 4e 61 6d 65 20 3d 20 22 | 4c 61 62 65 6c 36 22 0d |Name = "|Label6".|
|000027c0| 0a 00 00 00 01 00 00 00 | 4a 41 72 69 61 6c 2c 20 |........|JArial, |
|000027d0| 30 2c 20 39 2c 20 35 2c | 20 31 35 2c 20 31 32 2c |0, 9, 5,| 15, 12,|
|000027e0| 20 31 33 2c 20 33 2c 20 | 30 0a 4d 53 20 53 61 6e | 13, 3, |0.MS San|
|000027f0| 73 20 53 65 72 69 66 2c | 20 30 2c 20 38 2c 20 35 |s Serif,| 0, 8, 5|
|00002800| 2c 20 31 33 2c 20 31 31 | 2c 20 31 31 2c 20 32 2c |, 13, 11|, 11, 2,|
|00002810| 20 30 0a                |                         | 0.     |        |
+--------+-------------------------+-------------------------+--------+--------+