Sheet: (2, 1) FileControl (3, 1) (4, 1) CopyRight (c) 1993 (5, 1) (6, 1) Macro Systems (7, 1) (8, 1) All rights reserved. (10, 1) (13, 0) (13, 1) MACROS (13, 2) COMMENTS (14, 0) (14, 1) (14, 2) (15, 0) (15, 1) ResetFileControl (15, 2) run before giving to a new user (16, 0) (16, 1) TRUE (16, 2) (17, 0) (17, 1) TRUE (17, 2) (18, 0) (18, 1) FALSE (18, 2) (19, 0) (19, 1) TRUE (19, 2) (20, 0) (20, 1) TRUE (20, 2) (21, 0) (21, 1) FALSE (21, 2) (22, 0) (22, 1) TRUE (22, 2) (23, 0) (23, 1) (23, 2) (24, 0) (24, 1) TRUE (24, 2) (25, 0) (25, 1) TRUE (25, 2) (26, 0) (26, 1) TRUE (26, 2) (27, 0) (27, 1) TRUE (27, 2) (28, 0) (28, 1) TRUE (28, 2) (29, 0) (29, 1) TRUE (29, 2) (30, 0) (30, 1) TRUE (30, 2) (31, 0) (31, 1) TRUE (31, 2) (32, 0) (32, 1) TRUE (32, 2) (33, 0) (33, 1) TRUE (33, 2) (34, 0) (34, 1) TRUE (34, 2) (35, 0) (35, 1) TRUE (35, 2) (36, 0) (36, 1) TRUE (36, 2) (37, 0) (37, 1) TRUE (37, 2) (38, 0) (38, 1) TRUE (38, 2) (39, 0) (39, 1) TRUE (39, 2) (40, 0) (40, 1) TRUE (40, 2) (41, 0) (41, 1) TRUE (41, 2) (42, 0) (42, 1) TRUE (42, 2) (43, 0) (43, 1) TRUE (43, 2) (44, 0) (44, 1) TRUE (44, 2) (45, 0) (45, 1) TRUE (45, 2) (46, 0) (46, 1) TRUE (46, 2) (47, 0) (47, 1) TRUE (47, 2) (48, 0) (48, 1) TRUE (48, 2) (49, 0) (49, 1) TRUE (49, 2) (50, 0) (50, 1) TRUE (50, 2) (51, 0) (51, 1) TRUE (51, 2) (52, 0) (52, 1) TRUE (52, 2) (53, 0) (53, 1) TRUE (53, 2) (54, 0) (54, 1) TRUE (54, 2) (55, 0) (55, 1) TRUE (55, 2) (56, 0) (56, 1) TRUE (56, 2) (57, 0) (57, 1) TRUE (57, 2) (58, 0) (58, 1) TRUE (58, 2) (59, 0) (59, 1) TRUE (59, 2) (60, 0) (60, 1) TRUE (60, 2) (61, 0) (61, 1) TRUE (61, 2) (62, 0) (62, 1) TRUE (62, 2) (63, 0) (63, 1) TRUE (63, 2) (64, 0) (64, 1) TRUE (64, 2) (65, 0) (65, 1) TRUE (65, 2) (66, 0) (66, 1) TRUE (66, 2) (67, 0) (67, 1) TRUE (67, 2) (68, 0) (68, 1) TRUE (68, 2) (69, 0) (69, 1) TRUE (69, 2) (70, 0) (70, 1) TRUE (70, 2) (71, 0) (71, 1) TRUE (71, 2) (72, 0) (72, 1) TRUE (72, 2) (73, 0) (73, 1) TRUE (73, 2) (74, 0) (74, 1) TRUE (74, 2) (75, 0) (75, 1) TRUE (75, 2) (76, 0) (76, 1) TRUE (76, 2) (77, 0) (77, 1) TRUE (77, 2) (78, 0) (78, 1) TRUE (78, 2) (79, 0) (79, 1) TRUE (79, 2) (80, 0) (80, 1) TRUE (80, 2) (81, 0) (81, 1) TRUE (81, 2) (82, 0) (82, 1) TRUE (82, 2) (83, 0) (83, 1) TRUE (83, 2) (84, 0) (84, 1) TRUE (84, 2) (85, 0) (85, 1) TRUE (85, 2) (86, 0) (86, 1) TRUE (86, 2) (87, 0) (87, 1) TRUE (87, 2) (88, 0) (88, 1) TRUE (88, 2) (89, 0) (89, 1) TRUE (89, 2) (90, 0) (90, 1) TRUE (90, 2) (91, 0) (91, 1) TRUE (91, 2) (92, 0) (92, 1) TRUE (92, 2) (93, 0) (93, 1) TRUE (93, 2) (94, 0) (94, 1) TRUE (94, 2) (95, 0) (95, 1) TRUE (95, 2) (96, 0) (96, 1) TRUE (96, 2) (97, 0) (97, 1) TRUE (97, 2) (98, 0) (98, 1) TRUE (98, 2) (99, 0) (99, 1) TRUE (99, 2) (100, 0) (100, 1) TRUE (100, 2) (101, 0) (101, 1) TRUE (101, 2) (102, 0) (102, 1) TRUE (102, 2) (103, 0) (103, 1) TRUE (103, 2) (104, 0) (104, 1) TRUE (104, 2) (105, 0) (105, 1) TRUE (105, 2) (106, 0) (106, 1) TRUE (106, 2) (107, 0) (107, 1) (107, 2) (108, 0) (108, 1) PassWord (108, 2) (109, 0) (109, 1) xxxxx (109, 2) (110, 0) (110, 1) (110, 2) (111, 0) (111, 1) Register (111, 2) (112, 0) (112, 1) TRUE (112, 2) (113, 0) (113, 1) 3 (113, 2) (114, 0) (114, 1) FALSE (114, 2) (115, 0) (115, 1) FALSE (115, 2) (116, 0) (116, 1) FALSE (116, 2) (117, 0) (117, 1) TRUE (117, 2) (118, 0) (118, 1) TRUE (118, 2) (119, 0) (119, 1) (119, 2) (120, 0) (120, 1) RegisterBox (120, 2) (121, 0) (121, 1) (121, 2) (121, 3) (121, 4) 320 (121, 5) 144 (121, 6) (121, 7) 2 (122, 0) (122, 1) 5 (122, 2) 10 (122, 3) 6 (122, 4) (122, 5) (122, 6) Please enter your Registration Code (122, 7) (123, 0) (123, 1) 6 (123, 2) 26 (123, 3) 42 (123, 4) 264 (123, 5) (123, 6) (123, 7) j4inguf3 (123, 8) RegNum (124, 0) (124, 1) 1 (124, 2) 50 (124, 3) 93 (124, 4) 88 (124, 5) (124, 6) OK (124, 7) (125, 0) (125, 1) 2 (125, 2) 174 (125, 3) 92 (125, 4) 88 (125, 5) (125, 6) Cancel (125, 7) (126, 0) (126, 1) (126, 2) (127, 0) (127, 1) Auto_Open (127, 2) (128, 0) (128, 1) 4 (128, 2) (129, 0) (129, 1) FALSE (129, 2) (130, 0) (130, 1) TRUE (130, 2) referenced by exeproblem routine (131, 0) (131, 1) #N/A! (131, 2) (132, 0) (132, 1) (132, 2) (133, 0) (133, 1) TRUE (133, 2) (134, 0) (134, 1) TRUE (134, 2) (135, 0) (135, 1) TRUE (135, 2) (136, 0) (136, 1) TRUE (136, 2) (137, 0) (137, 1) TRUE (137, 2) (138, 0) (138, 1) TRUE (138, 2) (139, 0) (139, 1) TRUE (139, 2) (140, 0) (140, 1) (140, 2) (141, 0) (141, 1) TRUE (141, 2) (142, 0) (142, 1) TRUE (142, 2) (143, 0) (143, 1) TRUE (143, 2) (144, 0) (144, 1) FALSE (144, 2) (145, 0) (145, 1) #N/A! (145, 2) (146, 0) (146, 1) TRUE (146, 2) (147, 0) (147, 1) TRUE (147, 2) (148, 0) (148, 1) TRUE (148, 2) (149, 0) (149, 1) (149, 2) (150, 0) (150, 1) SetTempDir (150, 2) (151, 0) (151, 1) TRUE (151, 2) (152, 0) (152, 1) TRUE (152, 2) (153, 0) (153, 1) TRUE (153, 2) (154, 0) (154, 1) TRUE (154, 2) (155, 0) (155, 1) FALSE (155, 2) (156, 0) (156, 1) #VALUE! (156, 2) (157, 0) (157, 1) TRUE (157, 2) (158, 0) (158, 1) (158, 2) (159, 0) (159, 1) DefaultProblem (159, 2) (160, 0) (160, 1) TRUE (160, 2) (161, 0) (161, 1) TRUE (161, 2) (162, 0) (162, 1) TRUE (162, 2) (163, 0) (163, 1) FALSE (163, 2) (164, 0) (164, 1) (164, 2) (165, 0) (165, 1) (165, 2) (166, 0) (166, 1) CopyRightBox (166, 2) (167, 0) (167, 1) (167, 2) (167, 3) (167, 4) 169 (167, 5) 152 (167, 6) (167, 7) (168, 0) (168, 1) 5 (168, 2) 10 (168, 3) 28 (168, 4) (168, 5) (168, 6) Copyright (c) 1993 (168, 7) (169, 0) (169, 1) 5 (169, 2) 11 (169, 3) 48 (169, 4) (169, 5) (169, 6) All rights reserved. (169, 7) (170, 0) (170, 1) 5 (170, 2) 22 (170, 3) 69 (170, 4) (170, 5) (170, 6) Macro Systems (170, 7) (171, 0) (171, 1) 1 (171, 2) 34 (171, 3) 125 (171, 4) 88 (171, 5) (171, 6) OK (171, 7) (172, 0) (172, 1) 5 (172, 2) 30 (172, 3) 90 (172, 4) (172, 5) (172, 6) Release 1.0 (172, 7) (173, 0) (173, 1) 5 (173, 2) 41 (173, 3) 6 (173, 4) (173, 5) (173, 6) FileControl (173, 7) (174, 0) (174, 1) (174, 2) (175, 0) (175, 1) (175, 2) (176, 0) (176, 1) LibOption (176, 2) (177, 0) (177, 1) 0 (177, 2) (178, 0) (178, 1) (178, 2) (179, 0) (179, 1) ActivateFileControl (179, 2) (180, 0) (180, 1) TRUE (180, 2) (181, 0) (181, 1) TRUE (181, 2) (182, 0) (182, 1) FILECTRL.XL (182, 2) (183, 0) (183, 1) FALSE (183, 2) (184, 0) (184, 1) TRUE (184, 2) (185, 0) (185, 1) TRUE (185, 2) (186, 0) (186, 1) FALSE (186, 2) (187, 0) (187, 1) TRUE (187, 2) (188, 0) (188, 1) TRUE (188, 2) (189, 0) (189, 1) TRUE (189, 2) (190, 0) (190, 1) TRUE (190, 2) (191, 0) (191, 1) TRUE (191, 2) (192, 0) (192, 1) (192, 2) (193, 0) (193, 1) FileControlNotLoaded (193, 2) (194, 0) (194, 1) FALSE (194, 2) (195, 0) (195, 1) TRUE (195, 2) (196, 0) (196, 1) (196, 2) (197, 0) (197, 1) (197, 2) (198, 0) (198, 1) RecordSelections (198, 2) (199, 0) (199, 1) TRUE (199, 2) (200, 0) (200, 1) TRUE (200, 2) (201, 0) (201, 1) TRUE (201, 2) (202, 0) (202, 1) TRUE (202, 2) (203, 0) (203, 1) TRUE (203, 2) (204, 0) (204, 1) FALSE (204, 2) (205, 0) (205, 1) FALSE (205, 2) (206, 0) (206, 1) FALSE (206, 2) (207, 0) (207, 1) FALSE (207, 2) (208, 0) (208, 1) FALSE (208, 2) (209, 0) (209, 1) FALSE (209, 2) (210, 0) (210, 1) FALSE (210, 2) (211, 0) (211, 1) FALSE (211, 2) (212, 0) (212, 1) TRUE (212, 2) (213, 0) (213, 1) FALSE (213, 2) (214, 0) (214, 1) FALSE (214, 2) (215, 0) (215, 1) FALSE (215, 2) (216, 0) (216, 1) FALSE (216, 2) (217, 0) (217, 1) FALSE (217, 2) (218, 0) (218, 1) FALSE (218, 2) (219, 0) (219, 1) FALSE (219, 2) (220, 0) (220, 1) FALSE (220, 2) (221, 0) (221, 1) FALSE (221, 2) (222, 0) (222, 1) FALSE (222, 2) (223, 0) (223, 1) FALSE (223, 2) (224, 0) (224, 1) FALSE (224, 2) (225, 0) (225, 1) FALSE (225, 2) (226, 0) (226, 1) FALSE (226, 2) (227, 0) (227, 1) FALSE (227, 2) (228, 0) (228, 1) FALSE (228, 2) (229, 0) (229, 1) FALSE (229, 2) (230, 0) (230, 1) FALSE (230, 2) (231, 0) (231, 1) FALSE (231, 2) (232, 0) (232, 1) FALSE (232, 2) (233, 0) (233, 1) FALSE (233, 2) (234, 0) (234, 1) FALSE (234, 2) (235, 0) (235, 1) FALSE (235, 2) (236, 0) (236, 1) TRUE (236, 2) (237, 0) (237, 1) TRUE (237, 2) (238, 0) (238, 1) TRUE (238, 2) (239, 0) (239, 1) (239, 2) (240, 0) (240, 1) TRUE (240, 2) (241, 0) (241, 1) TRUE (241, 2) (242, 0) (242, 1) TRUE (242, 2) (243, 0) (243, 1) (243, 2) (244, 0) (244, 1) TRUE (244, 2) (245, 0) (245, 1) TRUE (245, 2) (246, 0) (246, 1) TRUE (246, 2) (247, 0) (247, 1) FALSE (247, 2) (248, 0) (248, 1) TRUE (248, 2) (249, 0) (249, 1) FALSE (249, 2) (250, 0) (250, 1) (250, 2) (251, 0) (251, 1) TRUE (251, 2) (252, 0) (252, 1) TRUE (252, 2) (253, 0) (253, 1) (253, 2) (254, 0) (254, 1) GoToNext (254, 2) (255, 0) (255, 1) TRUE (255, 2) (256, 0) (256, 1) TRUE (256, 2) (257, 0) (257, 1) TRUE (257, 2) (258, 0) (258, 1) FALSE (258, 2) (259, 0) (259, 1) FALSE (259, 2) (260, 0) (260, 1) FALSE (260, 2) (261, 0) (261, 1) FALSE (261, 2) (262, 0) (262, 1) FALSE (262, 2) (263, 0) (263, 1) FALSE (263, 2) (264, 0) (264, 1) FALSE (264, 2) (265, 0) (265, 1) FALSE (265, 2) (266, 0) (266, 1) TRUE (266, 2) (267, 0) (267, 1) FALSE (267, 2) (268, 0) (268, 1) FALSE (268, 2) (269, 0) (269, 1) FALSE (269, 2) (270, 0) (270, 1) FALSE (270, 2) (271, 0) (271, 1) FALSE (271, 2) (272, 0) (272, 1) FALSE (272, 2) (273, 0) (273, 1) FALSE (273, 2) (274, 0) (274, 1) FALSE (274, 2) (275, 0) (275, 1) FALSE (275, 2) (276, 0) (276, 1) FALSE (276, 2) (277, 0) (277, 1) FALSE (277, 2) (278, 0) (278, 1) FALSE (278, 2) (279, 0) (279, 1) FALSE (279, 2) (280, 0) (280, 1) FALSE (280, 2) (281, 0) (281, 1) FALSE (281, 2) (282, 0) (282, 1) FALSE (282, 2) (283, 0) (283, 1) FALSE (283, 2) (284, 0) (284, 1) FALSE (284, 2) (285, 0) (285, 1) FALSE (285, 2) (286, 0) (286, 1) FALSE (286, 2) (287, 0) (287, 1) FALSE (287, 2) (288, 0) (288, 1) TRUE (288, 2) (289, 0) (289, 1) (289, 2) (290, 0) MAIN (290, 1) Main_Menu (290, 2) (291, 0) (291, 1) TRUE (291, 2) (292, 0) (292, 1) TRUE (292, 2) (293, 0) (293, 1) TRUE (293, 2) (294, 0) (294, 1) TRUE (294, 2) (295, 0) (295, 1) TRUE (295, 2) (296, 0) (296, 1) TRUE (296, 2) (297, 0) (297, 1) TRUE (297, 2) (298, 0) (298, 1) TRUE (298, 2) (299, 0) (299, 1) FALSE (299, 2) (300, 0) (300, 1) #N/A! (300, 2) (301, 0) (301, 1) 20 (301, 2) GET OPTION (302, 0) (302, 1) FALSE (302, 2) (303, 0) (303, 1) TRUE (303, 2) (304, 0) (304, 1) (304, 2) (305, 0) (305, 1) LOOP THROUGH SELECTED CELLS (305, 2) (306, 1) TRUE (306, 2) (307, 1) TRUE (307, 2) (308, 1) #N/A! (308, 2) (309, 0) (309, 1) (309, 2) (310, 0) (310, 1) TRUE (310, 2) (311, 0) (311, 1) FALSE (311, 2) (312, 0) (312, 1) TRUE (312, 2) (313, 0) (313, 1) TRUE (313, 2) (314, 0) (314, 1) TRUE (314, 2) (315, 0) (315, 1) FALSE (315, 2) (316, 0) (316, 1) (316, 2) (317, 0) (317, 1) FALSE (317, 2) (318, 0) (318, 1) FALSE (318, 2) (319, 0) (319, 1) FALSE (319, 2) (320, 0) (320, 1) FALSE (320, 2) (321, 0) (321, 1) FALSE (321, 2) (322, 0) (322, 1) FALSE (322, 2) (323, 0) (323, 1) FALSE (323, 2) (324, 0) (324, 1) FALSE (324, 2) (325, 0) (325, 1) FALSE (325, 2) (326, 0) (326, 1) FALSE (326, 2) (327, 0) (327, 1) FALSE (327, 2) (328, 0) (328, 1) #N/A! (328, 2) (329, 0) (329, 1) FALSE (329, 2) (330, 0) (330, 1) TRUE (330, 2) (331, 0) (331, 1) TRUE (331, 2) (332, 0) (332, 1) (332, 2) (333, 0) (333, 1) (333, 2) (334, 0) (334, 1) MAIN_MENU_BOX (334, 2) (335, 0) MAIN_MENU (335, 1) (335, 2) 205 (335, 3) 93 (335, 4) 314 (335, 5) 350 (335, 6) (335, 7) (336, 0) (336, 1) 14 (336, 2) 13 (336, 3) 14 (336, 4) 285 (336, 5) 306 (336, 6) (336, 7) (337, 0) (337, 1) 11 (337, 2) (337, 3) (337, 4) (337, 5) (337, 6) (337, 7) 1 (337, 8) main_option (338, 0) (338, 1) 12 (338, 2) (338, 3) (338, 4) (338, 5) (338, 6) FILE OPTIONS (338, 7) (338, 8) 1 (339, 0) (339, 1) 12 (339, 2) (339, 3) (339, 4) (339, 5) (339, 6) Rename a File (339, 7) (339, 8) 2 (339, 9) (340, 0) (340, 1) 12 (340, 2) (340, 3) (340, 4) (340, 5) (340, 6) Copy a File (340, 7) (340, 8) 3 (340, 9) (341, 0) (341, 1) 12 (341, 2) (341, 3) (341, 4) (341, 5) (341, 6) Move a File (341, 7) (341, 8) 4 (341, 9) (342, 0) (342, 1) 12 (342, 2) (342, 3) (342, 4) (342, 5) (342, 6) Duplicate a File (342, 7) (342, 8) 5 (342, 9) (343, 0) (343, 1) 12 (343, 2) (343, 3) (343, 4) (343, 5) (343, 6) Erase a File (343, 7) (343, 8) 6 (343, 9) (344, 0) (344, 1) 12 (344, 2) (344, 3) (344, 4) (344, 5) (344, 6) (344, 7) (344, 8) 7 (344, 9) (345, 0) (345, 1) 12 (345, 2) (345, 3) (345, 4) (345, 5) (345, 6) DIRECTORY OPTIONS (345, 7) (345, 8) 8 (345, 9) (346, 0) (346, 1) 12 (346, 2) (346, 3) (346, 4) (346, 5) (346, 6) Update a Directory or Section (346, 7) (346, 8) 9 (346, 9) (347, 0) (347, 1) 12 (347, 2) (347, 3) (347, 4) (347, 5) (347, 6) Create a Directory (347, 7) (347, 8) 10 (347, 9) (348, 0) (348, 1) 12 (348, 2) (348, 3) (348, 4) (348, 5) (348, 6) Copy a Directory or Disk (348, 7) (348, 8) 11 (349, 0) (349, 1) 12 (349, 2) (349, 3) (349, 4) (349, 5) (349, 6) Erase a Directory or Disk (349, 7) (349, 8) 12 (349, 9) (350, 0) (350, 1) 12 (350, 2) (350, 3) (350, 4) (350, 5) (350, 6) (350, 7) (350, 8) 13 (350, 9) (351, 0) (351, 1) 12 (351, 2) (351, 3) (351, 4) (351, 5) (351, 6) OTHER OPTIONS (351, 7) (351, 8) 14 (351, 9) (352, 0) (352, 1) 12 (352, 2) (352, 3) (352, 4) (352, 5) (352, 6) Add a Section (352, 7) (352, 8) 15 (353, 0) (353, 1) 12 (353, 2) (353, 3) (353, 4) (353, 5) (353, 6) Setup Options (353, 7) (353, 8) 16 (354, 0) (354, 1) 12 (354, 2) (354, 3) (354, 4) (354, 5) (354, 6) About FileControl (354, 7) (354, 8) 17 (355, 0) (355, 1) 1 (355, 2) 46 (355, 3) 326 (355, 4) 88 (355, 5) (355, 6) OK (355, 7) (356, 0) (356, 1) 2 (356, 2) 166 (356, 3) 326 (356, 4) 88 (356, 5) (356, 6) Cancel (356, 7) (357, 0) (357, 1) 5 (357, 2) 17 (357, 3) 226 (357, 4) (357, 5) (357, 6) (357, 7) (358, 0) (358, 1) 5 (358, 2) 19 (358, 3) 245 (358, 4) (358, 5) (358, 6) (358, 7) (359, 0) (359, 1) 5 (359, 2) 18 (359, 3) 147 (359, 4) (359, 5) (359, 6) (359, 7) (360, 0) (360, 1) 5 (360, 2) 18 (360, 3) 143 (360, 4) (360, 5) (360, 6) (360, 7) (361, 0) (361, 1) 5 (361, 2) 19 (361, 3) 236 (361, 4) (361, 5) (361, 6) (361, 7) (362, 0) (362, 1) 5 (362, 2) 20 (362, 3) 225 (362, 4) (362, 5) (362, 6) (362, 7) (363, 0) (363, 1) 5 (363, 2) 22 (363, 3) 134 (363, 4) (363, 5) (363, 6) (363, 7) (364, 0) (364, 1) 5 (364, 2) 21 (364, 3) 128 (364, 4) (364, 5) (364, 6) (364, 7) (365, 0) (365, 1) 5 (365, 2) 18 (365, 3) 25 (365, 4) (365, 5) (365, 6) (365, 7) (366, 0) (366, 1) 5 (366, 2) 18 (366, 3) 30 (366, 4) (366, 5) (366, 6) (366, 7) (367, 0) (367, 1) 5 (367, 2) 74 (367, 3) 3 (367, 4) (367, 5) (367, 6) M A I N M E N U (367, 7) (368, 0) (368, 1) (368, 2) (369, 0) (369, 1) Syscommand (369, 2) (370, 0) (370, 1) xxxx (370, 2) (371, 0) (371, 1) TRUE (371, 2) (372, 0) (372, 1) (372, 2) (373, 0) (373, 1) AboutFileMgr (373, 2) (374, 0) (374, 1) TRUE (374, 2) (375, 0) (375, 1) 4 (375, 2) (376, 0) (376, 1) TRUE (376, 2) (377, 0) (377, 1) TRUE (377, 2) (378, 0) (378, 1) TRUE (378, 2) (379, 0) (379, 1) #N/A! (379, 2) (380, 0) (380, 1) TRUE (380, 2) (381, 0) (381, 1) TRUE (381, 2) (382, 0) (382, 1) TRUE (382, 2) (383, 0) (383, 1) TRUE (383, 2) (384, 0) (384, 1) TRUE (384, 2) (385, 0) (385, 1) TRUE (385, 2) (386, 0) (386, 1) (386, 2) (387, 0) (387, 1) TRUE (387, 2) (388, 0) (388, 1) TRUE (388, 2) (389, 0) (389, 1) TRUE (389, 2) (390, 0) (390, 1) (390, 2) (391, 0) (391, 1) TRUE (391, 2) (392, 0) (392, 1) FALSE (392, 2) (393, 0) (393, 1) FALSE (393, 2) (394, 0) (394, 1) TRUE (394, 2) (395, 0) (395, 1) FALSE (395, 2) (396, 0) (396, 1) TRUE (396, 2) (397, 0) (397, 1) TRUE (397, 2) (398, 0) (398, 1) TRUE (398, 2) (399, 0) (399, 1) (399, 2) (400, 0) (400, 1) AltDefaultDirBox (400, 2) (401, 0) (401, 1) (401, 2) (401, 3) (401, 4) 516 (401, 5) 302 (401, 6) (401, 7) 8 (402, 0) (402, 1) 5 (402, 2) 10 (402, 3) 6 (402, 4) (402, 5) (402, 6) FileControl normally uses the root directory as a (402, 7) (403, 0) (403, 1) 5 (403, 2) 10 (403, 3) 24 (403, 4) (403, 5) (403, 6) working directory to create temporary files. These (403, 7) (404, 0) (404, 1) 5 (404, 2) 10 (404, 3) 42 (404, 4) (404, 5) (404, 6) temporary files are erased automatically. For example, if Excel (404, 7) (405, 0) (405, 1) 5 (405, 2) 10 (405, 3) 60 (405, 4) (405, 5) (405, 6) is installed in C:\EXCEL, FileControl will use C:\ as the (405, 7) (406, 0) (406, 1) 5 (406, 2) 10 (406, 3) 78 (406, 4) (406, 5) (406, 6) default directory. Only change this if temporary files can not be (406, 7) (407, 0) (407, 1) 5 (407, 2) 10 (407, 3) 96 (407, 4) (407, 5) (407, 6) created in the root directory. (407, 7) (408, 0) (408, 1) 5 (408, 2) 9 (408, 3) 134 (408, 4) (408, 5) (408, 6) Enter an alternative directory below: (408, 7) (409, 0) (409, 1) 6 (409, 2) 12 (409, 3) 156 (409, 4) 397 (409, 5) (409, 6) (409, 7) (409, 8) AltDirName (410, 0) (410, 1) 14 (410, 2) 96 (410, 3) 190 (410, 4) 249 (410, 5) 51 (410, 6) (410, 7) (411, 0) (411, 1) 11 (411, 2) (411, 3) (411, 4) (411, 5) (411, 6) (411, 7) 1 (411, 8) AltDirOption (412, 0) (412, 1) 12 (412, 2) (412, 3) (412, 4) (412, 5) (412, 6) Use Default Directory (412, 7) (413, 0) (413, 1) 12 (413, 2) (413, 3) (413, 4) (413, 5) (413, 6) Use Alternative Directory (413, 7) (414, 0) (414, 1) 1 (414, 2) 171 (414, 3) 261 (414, 4) 88 (414, 5) (414, 6) OK (414, 7) (415, 0) (415, 1) (415, 2) (416, 0) (416, 1) (416, 2) (417, 0) (417, 1) FileMgrSetup (417, 2) (418, 0) (418, 1) 6 (418, 2) (419, 0) (419, 1) TRUE (419, 2) (420, 0) (420, 1) TRUE (420, 2) (421, 0) (421, 1) TRUE (421, 2) (422, 0) (422, 1) (422, 2) (423, 0) (423, 1) 13 (423, 2) (424, 0) (424, 1) FALSE (424, 2) (425, 0) (425, 1) TRUE (425, 2) sets the alternative directory up (426, 0) (426, 1) TRUE (426, 2) (427, 0) (427, 1) TRUE (427, 2) (428, 0) (428, 1) (428, 2) (429, 0) (429, 1) TRUE (429, 2) (430, 0) (430, 1) TRUE (430, 2) (431, 0) (431, 1) TRUE (431, 2) (432, 0) (432, 1) TRUE (432, 2) (433, 0) (433, 1) TRUE (433, 2) (434, 0) (434, 1) TRUE (434, 2) (435, 0) (435, 1) FALSE (435, 2) (436, 0) (436, 1) TRUE (436, 2) (437, 0) (437, 1) FALSE (437, 2) (438, 0) (438, 1) TRUE (438, 2) (439, 0) (439, 1) TRUE (439, 2) (440, 0) (440, 1) TRUE (440, 2) (441, 0) (441, 1) TRUE (441, 2) (442, 0) (442, 1) TRUE (442, 2) (443, 0) (443, 1) FALSE (443, 2) (444, 0) (444, 1) TRUE (444, 2) #NAME? (445, 0) (445, 1) TRUE (445, 2) end of blank entry if (446, 0) (446, 1) TRUE (446, 2) end of altdiroption = 2 if (447, 0) (447, 1) TRUE (447, 2) end of show box if (448, 0) (448, 1) (448, 2) (449, 0) (449, 1) SpecifyLibLocation (449, 2) note - above macro continues into this one (450, 0) (450, 1) 1 (450, 2) (451, 0) (451, 1) TRUE (451, 2) (452, 0) (452, 1) TRUE (452, 2) (453, 0) (453, 1) #VALUE! (453, 2) (454, 0) (454, 1) TRUE (454, 2) (455, 0) (455, 1) TRUE (455, 2) (456, 0) (456, 1) TRUE (456, 2) (457, 0) (457, 1) TRUE (457, 2) (458, 0) (458, 1) TRUE (458, 2) (459, 0) (459, 1) TRUE (459, 2) (460, 0) (460, 1) TRUE (460, 2) (461, 0) (461, 1) TRUE (461, 2) (462, 0) (462, 1) TRUE (462, 2) (463, 0) (463, 1) TRUE (463, 2) (464, 0) (464, 1) TRUE (464, 2) (465, 0) (465, 1) TRUE (465, 2) (466, 0) (466, 1) TRUE (466, 2) (467, 0) (467, 1) TRUE (467, 2) (468, 0) (468, 1) FALSE (468, 2) (469, 0) (469, 1) TRUE (469, 2) (470, 0) (470, 1) (470, 2) (471, 0) (471, 1) TRUE (471, 2) CONFIRM FILEFNS LOCATION (472, 0) (472, 1) TRUE (472, 2) (473, 0) (473, 1) TRUE (473, 2) (474, 0) (474, 1) TRUE (474, 2) (475, 0) (475, 1) (475, 2) (476, 0) (476, 1) TRUE (476, 2) (477, 0) (477, 1) (477, 2) (478, 0) (478, 1) TRUE (478, 2) (479, 0) (479, 1) #N/A! (479, 2) (480, 0) (480, 1) (480, 2) (481, 0) (481, 1) TestExe - continued from above (481, 2) (482, 0) (482, 1) TRUE (482, 2) (483, 0) (483, 1) TRUE (483, 2) (484, 0) (484, 1) TRUE (484, 2) (485, 0) (485, 1) TRUE (485, 2) (486, 0) (486, 1) #N/A! (486, 2) (487, 0) (487, 1) TRUE (487, 2) (488, 0) (488, 1) (488, 2) (489, 0) (489, 1) TRUE (489, 2) (490, 0) (490, 1) TRUE (490, 2) (491, 0) (491, 1) TRUE (491, 2) (492, 0) (492, 1) TRUE (492, 2) (493, 0) (493, 1) TRUE (493, 2) (494, 0) (494, 1) (494, 2) (495, 0) (495, 1) TRUE (495, 2) (496, 0) (496, 1) TRUE (496, 2) (497, 0) (497, 1) TRUE (497, 2) (498, 0) (498, 1) (498, 2) (499, 0) (499, 1) TRUE (499, 2) (500, 0) (500, 1) 10 (500, 2) (501, 0) (501, 1) FALSE (501, 2) (502, 0) (502, 1) TRUE (502, 2) (503, 0) (503, 1) FALSE (503, 2) (504, 0) (504, 1) TRUE (504, 2) (505, 0) (505, 1) TRUE (505, 2) (506, 0) (506, 1) TRUE (506, 2) (507, 0) (507, 1) TRUE (507, 2) (508, 0) (508, 1) TRUE (508, 2) (509, 0) (509, 1) TRUE (509, 2) (510, 0) (510, 1) TRUE (510, 2) (511, 0) (511, 1) (511, 2) (512, 0) (512, 1) ExeProblemBox (512, 2) (513, 0) (513, 1) (513, 2) (513, 3) (513, 4) 616 (513, 5) 206 (513, 6) (513, 7) (514, 0) (514, 1) 5 (514, 2) 10 (514, 3) 6 (514, 4) (514, 5) (514, 6) Confirmation was not received that CTRLEXCL.EXE was accessed (514, 7) (515, 0) (515, 1) 5 (515, 2) 10 (515, 3) 24 (515, 4) (515, 5) (515, 6) and could create the necessary confirmation file. (515, 7) (516, 0) (516, 1) 5 (516, 2) 10 (516, 3) 42 (516, 4) (516, 5) (516, 6) If the screen did not shift and display the FileControl Support Window, (516, 7) (517, 0) (517, 1) 5 (517, 2) 10 (517, 3) 60 (517, 4) (517, 5) (517, 6) then CTRLEXCL.EXE is not installed in a directory that is in your path. (517, 7) (518, 0) (518, 1) 5 (518, 2) 10 (518, 3) 78 (518, 4) (518, 5) (518, 6) Re-run the install program and specify a different directory for CTRLEXCL.EXE. (518, 7) (519, 0) (519, 1) 5 (519, 2) 10 (519, 3) 96 (519, 4) (519, 5) (519, 6) If you did see the info about FileControl, then you need to specify a (519, 7) (520, 0) (520, 1) 5 (520, 2) 10 (520, 3) 114 (520, 4) (520, 5) (520, 6) different working directory for temporary files by running setup from the (520, 7) (521, 0) (521, 1) 5 (521, 2) 10 (521, 3) 132 (521, 4) (521, 5) (521, 6) main menu. (521, 7) (522, 0) (522, 1) 5 (522, 2) 10 (522, 3) 150 (522, 4) (522, 5) (522, 6) Until this problem is resolved, FileControl will not work properly. (522, 7) (523, 0) (523, 1) 1 (523, 2) 238 (523, 3) 175 (523, 4) 88 (523, 5) (523, 6) OK (523, 7) (524, 0) (524, 1) (524, 2) (525, 0) (525, 1) (525, 2) (526, 0) (526, 1) LoadFileFns (526, 2) (527, 0) (527, 1) TRUE (527, 2) (528, 0) (528, 1) TRUE (528, 2) (529, 0) (529, 1) TRUE (529, 2) (530, 0) (530, 1) TRUE (530, 2) (531, 0) (531, 1) TRUE (531, 2) (532, 0) (532, 1) (532, 2) (533, 0) (533, 1) ExeError (533, 2) (534, 0) (534, 1) 10 (534, 2) (535, 0) (535, 1) TRUE (535, 2) (536, 0) (536, 1) TRUE (536, 2) (537, 0) (537, 1) TRUE (537, 2) (538, 0) (538, 1) TRUE (538, 2) (539, 0) (539, 1) (539, 2) (540, 0) (540, 1) ExeProblem (540, 2) (541, 0) (541, 1) 1 (541, 2) (542, 0) (542, 1) (542, 2) (543, 0) (543, 1) LibProblem (543, 2) (544, 0) (544, 1) TRUE (544, 2) (545, 0) (545, 1) TRUE (545, 2) (546, 0) (546, 1) FALSE (546, 2) (547, 0) (547, 1) TRUE (547, 2) (548, 0) (548, 1) TRUE (548, 2) (549, 0) (549, 1) FALSE (549, 2) (550, 0) (550, 1) TRUE (550, 2) (551, 0) (551, 1) TRUE (551, 2) (552, 0) (552, 1) (552, 2) (553, 0) (553, 1) SetupBox (553, 2) (554, 0) (554, 1) (554, 2) (554, 3) (554, 4) 508 (554, 5) 294 (554, 6) (554, 7) (555, 0) (555, 1) 5 (555, 2) 99 (555, 3) 6 (555, 4) (555, 5) (555, 6) FileControl SETUP PANEL (555, 7) (556, 0) (556, 1) 14 (556, 2) 16 (556, 3) 36 (556, 4) 409 (556, 5) 51 (556, 6) MAXIMIZE OPTION (556, 7) (557, 0) (557, 1) 11 (557, 2) (557, 3) (557, 4) (557, 5) (557, 6) (557, 7) 2 (557, 8) MaxOption (558, 0) (558, 1) 12 (558, 2) (558, 3) (558, 4) (558, 5) (558, 6) Maximize when activated or main menu pressed (558, 7) (559, 0) (559, 1) 12 (559, 2) (559, 3) (559, 4) (559, 5) (559, 6) Do not maximize. (559, 7) (560, 0) (560, 1) 1 (560, 2) 205 (560, 3) 267 (560, 4) 88 (560, 5) (560, 6) OK (560, 7) (561, 0) (561, 1) 14 (561, 2) 11 (561, 3) 115 (561, 4) 486 (561, 5) 51 (561, 6) MINIMIZE OPTION (561, 7) (562, 0) (562, 1) 11 (562, 2) (562, 3) (562, 4) (562, 5) (562, 6) (562, 7) 1 (562, 8) MinOption (563, 0) (563, 1) 12 (563, 2) (563, 3) (563, 4) (563, 5) (563, 6) Minimize FILECTRL.XLS after a file is created or opened (563, 7) (564, 0) (564, 1) 12 (564, 2) (564, 3) (564, 4) (564, 5) (564, 6) Do not change size of FILECTRL.XLS (564, 7) (565, 0) (565, 1) 14 (565, 2) 10 (565, 3) 198 (565, 4) 403 (565, 5) 51 (565, 6) DIRECTORY FOR TEMPORARY WORKING FILES (565, 7) (566, 0) (566, 1) 11 (566, 2) (566, 3) (566, 4) (566, 5) (566, 6) (566, 7) 1 (566, 8) ShowAltDirBox (567, 0) (567, 1) 12 (567, 2) (567, 3) (567, 4) (567, 5) (567, 6) Use default directory (567, 7) (568, 0) (568, 1) 12 (568, 2) (568, 3) (568, 4) (568, 5) (568, 6) Specify the directory to use (568, 7) (569, 0) (569, 1) (569, 2) (570, 0) (570, 1) (570, 2) (571, 0) (571, 1) LibLocationBox (571, 2) (572, 0) (572, 1) (572, 2) (572, 3) (572, 4) 564 (572, 5) 294 (572, 6) (572, 7) 2 (573, 0) (573, 1) 1 (573, 2) 230 (573, 3) 267 (573, 4) 88 (573, 5) (573, 6) OK (573, 7) (574, 0) (574, 1) 6 (574, 2) 105 (574, 3) 235 (574, 4) 370 (574, 5) (574, 6) (574, 7) (574, 8) Userliblocation (575, 0) (575, 1) 5 (575, 2) 67 (575, 3) 6 (575, 4) (575, 5) (575, 6) E X C E L L I B R A R Y L O C A T I O N P A N E L (575, 7) (576, 0) (576, 1) 5 (576, 2) 69 (576, 3) 40 (576, 4) (576, 5) (576, 6) Please specify where the Excel Add-Ins are located: (576, 7) (577, 0) (577, 1) 14 (577, 2) 154 (577, 3) 60 (577, 4) 243 (577, 5) 102 (577, 6) (577, 7) (578, 0) (578, 1) 11 (578, 2) (578, 3) (578, 4) (578, 5) (578, 6) (578, 7) 1 (578, 8) libboxoption (579, 0) (579, 1) 12 (579, 2) (579, 3) (579, 4) (579, 5) (579, 6) C:\EXCEL\LIBRARY (579, 7) (580, 0) (580, 1) 12 (580, 2) (580, 3) (580, 4) (580, 5) (580, 6) D:\EXCEL\LIBRARY (580, 7) (581, 0) (581, 1) 12 (581, 2) (581, 3) (581, 4) (581, 5) (581, 6) E:\EXCEL\LIBRARY (581, 7) (582, 0) (582, 1) 12 (582, 2) (582, 3) (582, 4) (582, 5) (582, 6) F:\EXCEL\LIBRARY (582, 7) (583, 0) (583, 1) 12 (583, 2) (583, 3) (583, 4) (583, 5) (583, 6) User Specified Directory (583, 7) (584, 0) (584, 1) 5 (584, 2) 11 (584, 3) 191 (584, 4) (584, 5) (584, 6) If the user specified directory is selected, specify the full path (584, 7) (585, 0) (585, 1) 5 (585, 2) 10 (585, 3) 209 (585, 4) (585, 5) (585, 6) and directory where the Excel Add-Ins are located in the edit box below. (585, 7) (586, 0) (586, 1) (586, 2) (587, 0) (587, 1) (587, 2) (588, 0) (588, 1) LibLocation (588, 2) (589, 0) (589, 1) (589, 2) (590, 0) (590, 1) (590, 2) (591, 0) (591, 1) LibProblemBox (591, 2) (592, 0) (592, 1) (592, 2) (592, 3) (592, 4) 578 (592, 5) 252 (592, 6) (592, 7) (593, 0) (593, 1) 5 (593, 2) 10 (593, 3) 6 (593, 4) (593, 5) (593, 6) The directory specified for the Excel Add-in Library either does not (593, 7) (594, 0) (594, 1) 5 (594, 2) 10 (594, 3) 24 (594, 4) (594, 5) (594, 6) exist or the Excel add-in FILEFNS.XLA is not in the directory specified. (594, 7) (595, 0) (595, 1) 5 (595, 2) 11 (595, 3) 60 (595, 4) (595, 5) (595, 6) To install this add-in, run the Excel setup program found on the Excel (595, 7) (596, 0) (596, 1) 5 (596, 2) 11 (596, 3) 78 (596, 4) (596, 5) (596, 6) program disks. The custom install option will allow you to just install (596, 7) (597, 0) (597, 1) 5 (597, 2) 11 (597, 3) 96 (597, 4) (597, 5) (597, 6) selected add-ins. (597, 7) (598, 0) (598, 1) 5 (598, 2) 16 (598, 3) 127 (598, 4) (598, 5) (598, 6) Until this add-in is installed and its location is specified, most of (598, 7) (599, 0) (599, 1) 5 (599, 2) 17 (599, 3) 145 (599, 4) (599, 5) (599, 6) FileControl's functions will not work. (599, 7) (600, 0) (600, 1) 5 (600, 2) 14 (600, 3) 181 (600, 4) (600, 5) (600, 6) Select OK to go to the panel that allows you to specify the location (600, 7) (601, 0) (601, 1) 5 (601, 2) 16 (601, 3) 199 (601, 4) (601, 5) (601, 6) of the Excel Add-in Library and FILEFNS.XLS. (601, 7) (602, 0) (602, 1) 1 (602, 2) 132 (602, 3) 225 (602, 4) 88 (602, 5) (602, 6) OK (602, 7) (603, 0) (603, 1) 2 (603, 2) 314 (603, 3) 225 (603, 4) 88 (603, 5) (603, 6) Cancel (603, 7) (604, 0) (604, 1) (604, 2) (605, 0) (605, 1) DuplAFile (605, 2) (606, 0) (606, 1) TRUE (606, 2) (607, 0) (607, 1) #N/A! (607, 2) (608, 0) (608, 1) #N/A! (608, 2) confirm file selected (609, 0) (609, 1) TRUE (609, 2) store name of file (610, 0) (610, 1) TRUE (610, 2) (611, 0) (611, 1) TRUE (611, 2) (612, 0) (612, 1) TRUE (612, 2) (613, 0) (613, 1) TRUE (613, 2) (614, 0) (614, 1) FALSE (614, 2) (615, 0) (615, 1) #N/A! (615, 2) execute routine to get directory name (616, 0) (616, 1) TRUE (616, 2) store directory name (617, 0) (617, 1) #N/A! (617, 2) (618, 0) (618, 1) TRUE (618, 2) (619, 0) (619, 1) TRUE (619, 2) (620, 0) (620, 1) TRUE (620, 2) (621, 0) (621, 1) FALSE (621, 2) (622, 0) (622, 1) TRUE (622, 2) (623, 0) (623, 1) FALSE (623, 2) (624, 0) (624, 1) TRUE (624, 2) (625, 0) (625, 1) TRUE (625, 2) (626, 0) (626, 1) TRUE (626, 2) (627, 0) (627, 1) TRUE (627, 2) (628, 0) (628, 1) TRUE (628, 2) (629, 0) (629, 1) TRUE (629, 2) (630, 0) (630, 1) TRUE (630, 2) (631, 0) (631, 1) TRUE (631, 2) (632, 0) (632, 1) (632, 2) (633, 0) (633, 1) 11 (633, 2) (634, 0) (634, 1) FALSE (634, 2) (635, 0) (635, 1) TRUE (635, 2) (636, 0) (636, 1) TRUE (636, 2) (637, 0) (637, 1) TRUE (637, 2) (638, 0) (638, 1) FALSE (638, 2) (639, 0) (639, 1) TRUE (639, 2) (640, 0) (640, 1) TRUE (640, 2) (641, 0) (641, 1) TRUE (641, 2) (642, 0) (642, 1) TRUE (642, 2) (643, 0) (643, 1) TRUE (643, 2) (644, 0) (644, 1) TRUE (644, 2) (645, 0) (645, 1) TRUE (645, 2) (646, 0) (646, 1) FALSE (646, 2) (647, 0) (647, 1) TRUE (647, 2) (648, 0) (648, 1) (648, 2) (649, 0) (649, 1) TRUE (649, 2) (650, 0) (650, 1) TRUE (650, 2) (651, 0) (651, 1) TRUE (651, 2) (652, 0) (652, 1) TRUE (652, 2) (653, 0) (653, 1) TRUE (653, 2) (654, 0) (654, 1) FALSE (654, 2) (655, 0) (655, 1) (655, 2) (656, 0) (656, 1) TRUE (656, 2) check and see if file already exists (657, 0) (657, 1) TRUE (657, 2) (658, 0) (658, 1) TRUE (658, 2) (659, 0) (659, 1) FALSE (659, 2) (660, 0) (660, 1) TRUE (660, 2) (661, 0) (661, 1) #N/A! (661, 2) (662, 0) (662, 1) #N/A! (662, 2) (663, 0) (663, 1) (663, 2) (664, 0) (664, 1) TRUE (664, 2) (665, 0) (665, 1) FALSE (665, 2) (666, 0) (666, 1) TRUE (666, 2) (667, 0) (667, 1) (667, 2) (668, 0) (668, 1) TRUE (668, 2) (669, 0) (669, 1) FALSE (669, 2) (670, 0) (670, 1) TRUE (670, 2) (671, 0) (671, 1) (671, 2) (672, 1) TRUE (672, 2) (673, 0) (673, 1) TRUE (673, 2) (674, 0) (674, 1) TRUE (674, 2) (675, 0) (675, 1) #N/A! (675, 2) (676, 0) (676, 1) TRUE (676, 2) (677, 0) (677, 1) TRUE (677, 2) (678, 0) (678, 1) TRUE (678, 2) (679, 0) (679, 1) TRUE (679, 2) (680, 0) (680, 1) TRUE (680, 2) (681, 0) (681, 1) TRUE (681, 2) (682, 0) (682, 1) (682, 2) (683, 0) (683, 1) TRUE (683, 2) (684, 0) (684, 1) TRUE (684, 2) (685, 0) (685, 1) TRUE (685, 2) (686, 0) (686, 1) (686, 2) (687, 0) (687, 1) TRUE (687, 2) (688, 0) (688, 1) TRUE (688, 2) (689, 0) (689, 1) TRUE (689, 2) (690, 0) (690, 1) (690, 2) (691, 0) (691, 1) TRUE (691, 2) (692, 0) (692, 1) TRUE (692, 2) (693, 0) (693, 1) TRUE (693, 2) (694, 0) (694, 1) FALSE (694, 2) (695, 0) (695, 1) TRUE (695, 2) (696, 0) (696, 1) (696, 2) (697, 0) (697, 1) TRUE (697, 2) (698, 0) (698, 1) (698, 2) (699, 0) (699, 1) TRUE (699, 2) (700, 0) (700, 1) TRUE (700, 2) (701, 0) (701, 1) TRUE (701, 2) (702, 0) (702, 1) TRUE (702, 2) (703, 0) (703, 1) FALSE (703, 2) (704, 0) (704, 1) TRUE (704, 2) (705, 0) (705, 1) TRUE (705, 2) (706, 0) (706, 1) TRUE (706, 2) (707, 0) (707, 1) TRUE (707, 2) (708, 0) (708, 1) TRUE (708, 2) (709, 0) (709, 1) #N/A! (709, 2) (710, 0) (710, 1) TRUE (710, 2) (711, 0) (711, 1) TRUE (711, 2) (712, 0) (712, 1) TRUE (712, 2) (713, 0) (713, 1) TRUE (713, 2) (714, 0) (714, 1) TRUE (714, 2) (715, 0) (715, 1) TRUE (715, 2) (716, 0) (716, 1) TRUE (716, 2) (717, 0) (717, 1) TRUE (717, 2) (718, 0) (718, 1) TRUE (718, 2) (719, 0) (719, 1) TRUE (719, 2) (720, 0) (720, 1) TRUE (720, 2) (721, 0) (721, 1) TRUE (721, 2) (722, 0) (722, 1) TRUE (722, 2) (723, 0) (723, 1) TRUE (723, 2) (724, 0) (724, 1) TRUE (724, 2) (725, 0) (725, 1) (725, 2) (726, 0) (726, 1) ClearRow (726, 2) (727, 0) (727, 1) TRUE (727, 2) (728, 0) (728, 1) TRUE (728, 2) (729, 0) (729, 1) TRUE (729, 2) (730, 0) (730, 1) TRUE (730, 2) (731, 0) (731, 1) TRUE (731, 2) (732, 0) (732, 1) (732, 2) (733, 0) (733, 1) (733, 2) (734, 0) (734, 1) (734, 2) (735, 0) (735, 1) DuplicateBox (735, 2) (736, 0) (736, 1) (736, 2) (736, 3) (736, 4) 538 (736, 5) 276 (736, 6) (736, 7) 4 (737, 0) (737, 1) 5 (737, 2) 27 (737, 3) 7 (737, 4) (737, 5) (737, 6) To create a duplicate copy of the following file (737, 7) (738, 0) (738, 1) 5 (738, 2) 27 (738, 3) 80 (738, 4) (738, 5) (738, 6) Enter a new filename in the box below. (738, 7) (739, 0) (739, 1) 5 (739, 2) 27 (739, 3) 98 (739, 4) (739, 5) (739, 6) Do not enter a period or the filetype. (739, 7) (739, 8) dupName (740, 0) (740, 1) 6 (740, 2) 53 (740, 3) 118 (740, 4) 216 (740, 5) (740, 6) C:\ACTIVE (740, 7) QQQ.XLS (740, 8) DupSrceFile (741, 0) (741, 1) 5 (741, 2) 78 (741, 3) 43 (741, 4) (741, 5) (741, 6) C:\XLSFILES (741, 7) (741, 8) DupSrceDoc (742, 0) (742, 1) 5 (742, 2) 78 (742, 3) 59 (742, 4) (742, 5) (742, 6) sfsdf (742, 7) (742, 8) DupSrceDir (743, 0) (743, 1) 5 (743, 2) 79 (743, 3) 25 (743, 4) (743, 5) (743, 6) BBB.XLS (743, 7) (744, 0) (744, 1) 5 (744, 2) 23 (744, 3) 155 (744, 4) (744, 5) (744, 6) Documentation for new file: (744, 7) (744, 8) DupDoc (745, 0) (745, 1) 6 (745, 2) 52 (745, 3) 174 (745, 4) 384 (745, 5) (745, 6) (745, 7) sfsdfqqq (746, 0) (746, 1) 5 (746, 2) 27 (746, 3) 213 (746, 4) (746, 5) (746, 6) The duplicate will be located in the same directory. (746, 7) (747, 0) (747, 1) 1 (747, 2) 99 (747, 3) 243 (747, 4) 88 (747, 5) (747, 6) OK (747, 7) (748, 0) (748, 1) 2 (748, 2) 245 (748, 3) 242 (748, 4) 88 (748, 5) (748, 6) Cancel (748, 7) (749, 0) (749, 1) (749, 2) (750, 0) (750, 1) (750, 2) (751, 0) (751, 1) ChkFNS (751, 2) (752, 0) (752, 1) TRUE (752, 2) (753, 0) (753, 1) TRUE (753, 2) (754, 0) (754, 1) TRUE (754, 2) (755, 0) (755, 1) TRUE (755, 2) (756, 0) (756, 1) (756, 2) (757, 0) (757, 1) FnsError (757, 2) (758, 0) (758, 1) TRUE (758, 2) (759, 0) (759, 1) TRUE (759, 2) (760, 0) (760, 1) TRUE (760, 2) (761, 0) (761, 1) TRUE (761, 2) (762, 0) (762, 1) TRUE (762, 2) (763, 0) (763, 1) (763, 2) (764, 0) (764, 1) TRUE (764, 2) (765, 0) (765, 1) TRUE (765, 2) (766, 0) (766, 1) TRUE (766, 2) (767, 0) (767, 1) (767, 2) (768, 0) (768, 1) CopyADir (768, 2) (769, 0) (769, 1) TRUE (769, 2) (770, 0) (770, 1) #N/A! (770, 2) (771, 0) (771, 1) TRUE (771, 2) (772, 0) (772, 1) TRUE (772, 2) confirm cell pointer is in a directory (773, 0) (773, 1) TRUE (773, 2) (774, 0) (774, 1) TRUE (774, 2) (775, 0) (775, 1) #N/A! (775, 2) get directory name (776, 0) (776, 1) TRUE (776, 2) (777, 0) (777, 1) TRUE (777, 2) (778, 0) (778, 1) TRUE (778, 2) (779, 0) (779, 1) TRUE (779, 2) (780, 0) (780, 1) (780, 2) (781, 0) (781, 1) TRUE (781, 2) (782, 0) (782, 1) 8 (782, 2) get source directory or disk of files to be copied (783, 0) (783, 1) FALSE (783, 2) (784, 0) (784, 1) TRUE (784, 2) (785, 0) (785, 1) TRUE (785, 2) (786, 0) (786, 1) FALSE (786, 2) (787, 0) (787, 1) TRUE (787, 2) (788, 0) (788, 1) FALSE (788, 2) (789, 0) (789, 1) TRUE (789, 2) (790, 0) (790, 1) TRUE (790, 2) (791, 0) (791, 1) TRUE (791, 2) (792, 0) (792, 1) FALSE (792, 2) (793, 0) (793, 1) TRUE (793, 2) (794, 0) (794, 1) FALSE (794, 2) (795, 0) (795, 1) (795, 2) (796, 0) (796, 1) TRUE (796, 2) mark corners of file list for future use (797, 0) (797, 1) TRUE (797, 2) (798, 0) (798, 1) TRUE (798, 2) (799, 0) (799, 1) TRUE (799, 2) (800, 0) (800, 1) TRUE (800, 2) (801, 0) (801, 1) TRUE (801, 2) (802, 0) (802, 1) TRUE (802, 2) (803, 0) (803, 1) TRUE (803, 2) (804, 0) (804, 1) TRUE (804, 2) (805, 0) (805, 1) TRUE (805, 2) (806, 0) (806, 1) FALSE (806, 2) (807, 0) (807, 1) FALSE (807, 2) (808, 0) (808, 1) TRUE (808, 2) (809, 0) (809, 1) TRUE (809, 2) (810, 0) (810, 1) 4 (810, 2) (811, 0) (811, 1) FALSE (811, 2) (812, 0) (812, 1) TRUE (812, 2) (813, 0) (813, 1) FALSE (813, 2) (814, 0) (814, 1) FALSE (814, 2) (815, 0) (815, 1) FALSE (815, 2) (816, 0) (816, 1) (816, 2) (817, 0) (817, 1) TRUE (817, 2) (818, 0) (818, 1) FALSE (818, 2) (819, 0) (819, 1) TRUE (819, 2) (820, 0) (820, 1) TRUE (820, 2) (821, 0) (821, 1) #N/A! (821, 2) (822, 0) (822, 1) TRUE (822, 2) get the destination of the files (823, 0) (823, 1) TRUE (823, 2) (824, 0) (824, 1) 8 (824, 2) (825, 0) (825, 1) FALSE (825, 2) (826, 0) (826, 1) (826, 2) (827, 0) (827, 1) TRUE (827, 2) if elsewhere, set keys and instruct user (828, 0) (828, 1) TRUE (828, 2) (829, 0) (829, 1) TRUE (829, 2) (830, 0) (830, 1) TRUE (830, 2) (831, 0) (831, 1) TRUE (831, 2) (832, 0) (832, 1) TRUE (832, 2) (833, 0) (833, 1) FALSE (833, 2) (834, 0) (834, 1) (834, 2) (835, 0) DirCopyContinue (835, 1) DirCopyContinue (835, 2) macro continues automatically if option not 1 (836, 0) (836, 1) (836, 2) (837, 0) (837, 1) TRUE (837, 2) reset keys if elsewhere in mgr (838, 0) (838, 1) TRUE (838, 2) confirm selection (839, 0) (839, 1) TRUE (839, 2) (840, 0) (840, 1) TRUE (840, 2) (841, 0) (841, 1) TRUE (841, 2) (842, 0) (842, 1) TRUE (842, 2) (843, 0) (843, 1) TRUE (843, 2) (844, 0) (844, 1) TRUE (844, 2) (845, 0) (845, 1) TRUE (845, 2) (846, 0) (846, 1) FALSE (846, 2) (847, 0) (847, 1) TRUE (847, 2) (848, 0) (848, 1) FALSE (848, 2) (849, 0) (849, 1) TRUE (849, 2) (850, 0) (850, 1) #N/A! (850, 2) (851, 0) (851, 1) TRUE (851, 2) (852, 0) (852, 1) TRUE (852, 2) (853, 0) (853, 1) TRUE (853, 2) (854, 0) (854, 1) TRUE (854, 2) (855, 0) (855, 1) FALSE (855, 2) set destdir if option 2 or 3 (856, 0) (856, 1) FALSE (856, 2) (857, 0) (857, 1) (857, 2) (858, 0) (858, 1) TRUE (858, 2) prompt user fo directory if option 4 (859, 0) (859, 1) TRUE (859, 2) (860, 0) (860, 1) 4 (860, 2) (861, 0) (861, 1) FALSE (861, 2) (862, 0) (862, 1) TRUE (862, 2) (863, 0) (863, 1) FALSE (863, 2) (864, 0) (864, 1) TRUE (864, 2) (865, 0) (865, 1) TRUE (865, 2) (866, 0) (866, 1) #N/A! (866, 2) (867, 0) (867, 1) TRUE (867, 2) clear files (868, 0) (868, 1) TRUE (868, 2) (869, 0) (869, 1) TRUE (869, 2) (870, 0) (870, 1) (870, 2) (871, 0) (871, 1) TRUE (871, 2) (872, 0) (872, 1) TRUE (872, 2) (873, 0) (873, 1) TRUE (873, 2) (874, 0) (874, 1) (874, 2) (875, 0) (875, 1) TRUE (875, 2) (876, 0) (876, 1) TRUE (876, 2) (877, 0) (877, 1) TRUE (877, 2) (878, 0) (878, 1) TRUE (878, 2) (879, 0) (879, 1) TRUE (879, 2) (880, 0) (880, 1) TRUE (880, 2) (881, 0) (881, 1) TRUE (881, 2) (882, 0) (882, 1) TRUE (882, 2) (883, 0) (883, 1) (883, 2) (884, 0) (884, 1) TRUE (884, 2) get file type (885, 0) (885, 1) TRUE (885, 2) (886, 0) (886, 1) TRUE (886, 2) (887, 0) (887, 1) TRUE (887, 2) (888, 0) (888, 1) (888, 2) (889, 0) (889, 1) TRUE (889, 2) (890, 0) (890, 1) (890, 2) (891, 0) (891, 1) (891, 2) (892, 0) (892, 1) TRUE (892, 2) (893, 0) (893, 1) TRUE (893, 2) (894, 0) (894, 1) TRUE (894, 2) (895, 0) (895, 1) #N/A! (895, 2) (896, 0) (896, 1) TRUE (896, 2) (897, 0) (897, 1) TRUE (897, 2) (898, 0) (898, 1) TRUE (898, 2) (899, 0) (899, 1) TRUE (899, 2) (900, 0) (900, 1) TRUE (900, 2) (901, 0) (901, 1) TRUE (901, 2) (902, 0) (902, 1) (902, 2) (903, 0) (903, 1) TRUE (903, 2) (904, 0) (904, 1) TRUE (904, 2) (905, 0) (905, 1) TRUE (905, 2) (906, 0) (906, 1) (906, 2) (907, 0) (907, 1) TRUE (907, 2) (908, 0) (908, 1) TRUE (908, 2) (909, 0) (909, 1) TRUE (909, 2) (910, 0) (910, 1) (910, 2) (911, 0) (911, 1) TRUE (911, 2) (912, 0) (912, 1) TRUE (912, 2) (913, 0) (913, 1) TRUE (913, 2) (914, 0) (914, 1) FALSE (914, 2) (915, 0) (915, 1) (915, 2) (916, 0) (916, 1) TRUE (916, 2) (917, 0) (917, 1) TRUE (917, 2) (918, 0) (918, 1) TRUE (918, 2) (919, 0) (919, 1) (919, 2) (920, 0) (920, 1) TRUE (920, 2) (921, 0) (921, 1) TRUE (921, 2) (922, 0) (922, 1) TRUE (922, 2) (923, 0) (923, 1) FALSE (923, 2) (924, 0) (924, 1) (924, 2) (925, 0) (925, 1) TRUE (925, 2) (926, 0) (926, 1) TRUE (926, 2) (927, 0) (927, 1) TRUE (927, 2) (928, 0) (928, 1) TRUE (928, 2) (929, 0) (929, 1) FALSE (929, 2) (930, 0) (930, 1) (930, 2) (931, 0) (931, 1) TRUE (931, 2) (932, 0) (932, 1) TRUE (932, 2) (933, 0) (933, 1) TRUE (933, 2) (934, 0) (934, 1) TRUE (934, 2) (935, 0) (935, 1) TRUE (935, 2) (936, 0) (936, 1) TRUE (936, 2) (937, 0) (937, 1) TRUE (937, 2) GO TO BOTTOM OF DATA (938, 0) (938, 1) TRUE (938, 2) (939, 0) (939, 1) TRUE (939, 2) (940, 0) (940, 1) TRUE (940, 2) (941, 0) (941, 1) TRUE (941, 2) (942, 0) (942, 1) TRUE (942, 2) (943, 0) (943, 1) (943, 2) (944, 0) (944, 1) TRUE (944, 2) (945, 0) (945, 1) (945, 2) (946, 0) (946, 1) TRUE (946, 2) copy dest or source to temp file depending (947, 0) (947, 1) TRUE (947, 2) on warnoption (948, 0) (948, 1) TRUE (948, 2) (949, 0) (949, 1) TRUE (949, 2) (950, 0) (950, 1) TRUE (950, 2) (951, 0) (951, 1) TRUE (951, 2) (952, 0) (952, 1) TRUE (952, 2) (953, 0) (953, 1) TRUE (953, 2) (954, 0) (954, 1) TRUE (954, 2) (955, 0) (955, 1) TRUE (955, 2) (956, 0) (956, 1) TRUE (956, 2) (957, 0) (957, 1) TRUE (957, 2) (958, 0) (958, 1) (958, 2) (959, 0) (959, 1) TRUE (959, 2) select data and sort (960, 0) (960, 1) TRUE (960, 2) (961, 0) (961, 1) TRUE (961, 2) (962, 0) (962, 1) TRUE (962, 2) (963, 0) (963, 1) TRUE (963, 2) (964, 0) (964, 1) TRUE (964, 2) (965, 0) (965, 1) TRUE (965, 2) (966, 0) (966, 1) TRUE (966, 2) (967, 0) (967, 1) (967, 2) (968, 0) (968, 1) TRUE (968, 2) were copied and keeps only those (969, 0) (969, 1) TRUE (969, 2) (970, 0) (970, 1) TRUE (970, 2) (971, 0) (971, 1) TRUE (971, 2) (972, 0) (972, 1) TRUE (972, 2) (973, 0) (973, 1) TRUE (973, 2) go to temp7 row (974, 0) (974, 1) TRUE (974, 2) (975, 0) (975, 1) TRUE (975, 2) (976, 0) (976, 1) TRUE (976, 2) (977, 0) (977, 1) TRUE (977, 2) (978, 0) (978, 1) TRUE (978, 2) (979, 0) (979, 1) TRUE (979, 2) (980, 0) (980, 1) TRUE (980, 2) (981, 0) (981, 1) TRUE (981, 2) (982, 0) (982, 1) TRUE (982, 2) (983, 0) (983, 1) TRUE (983, 2) remove if not copied (984, 0) (984, 1) TRUE (984, 2) (985, 0) (985, 1) TRUE (985, 2) (986, 0) (986, 1) TRUE (986, 2) (987, 0) (987, 1) TRUE (987, 2) (988, 0) (988, 1) TRUE (988, 2) (989, 0) (989, 1) TRUE (989, 2) remove temp7 row if not same as temp8 (990, 0) (990, 1) TRUE (990, 2) (991, 0) (991, 1) TRUE (991, 2) (992, 0) (992, 1) TRUE (992, 2) (993, 0) (993, 1) (993, 2) (994, 0) (994, 1) TRUE (994, 2) label rows for later sorting (995, 0) (995, 1) TRUE (995, 2) (996, 0) (996, 1) TRUE (996, 2) (997, 0) (997, 1) TRUE (997, 2) (998, 0) (998, 1) TRUE (998, 2) (999, 0) (999, 1) TRUE (999, 2) (1000, 0) (1000, 1) FALSE (1000, 2) (1001, 0) (1001, 1) TRUE (1001, 2) (1002, 0) (1002, 1) TRUE (1002, 2) (1003, 0) (1003, 1) TRUE (1003, 2) (1004, 0) (1004, 1) TRUE (1004, 2) (1005, 0) (1005, 1) TRUE (1005, 2) (1006, 0) (1006, 1) TRUE (1006, 2) (1007, 0) (1007, 1) TRUE (1007, 2) (1008, 0) (1008, 1) TRUE (1008, 2) (1009, 0) (1009, 1) TRUE (1009, 2) (1010, 0) (1010, 1) TRUE (1010, 2) (1011, 0) (1011, 1) TRUE (1011, 2) (1012, 0) (1012, 1) TRUE (1012, 2) (1013, 0) (1013, 1) TRUE (1013, 2) (1014, 0) (1014, 1) (1014, 2) (1015, 0) (1015, 1) (1015, 2) (1016, 0) (1016, 1) TRUE (1016, 2) get dest list and update (1017, 0) (1017, 1) TRUE (1017, 2) (1018, 0) (1018, 1) TRUE (1018, 2) (1019, 0) (1019, 1) TRUE (1019, 2) (1020, 0) (1020, 1) TRUE (1020, 2) (1021, 0) (1021, 1) TRUE (1021, 2) (1022, 0) (1022, 1) TRUE (1022, 2) (1023, 0) (1023, 1) TRUE (1023, 2) (1024, 0) (1024, 1) TRUE (1024, 2) (1025, 0) (1025, 1) TRUE (1025, 2) (1026, 0) (1026, 1) TRUE (1026, 2) (1027, 0) (1027, 1) TRUE (1027, 2) copy dest data to temp file (1028, 0) (1028, 1) TRUE (1028, 2) (1029, 0) (1029, 1) TRUE (1029, 2) (1030, 0) (1030, 1) TRUE (1030, 2) past at bottom of other data (1031, 0) (1031, 1) TRUE (1031, 2) (1032, 0) (1032, 1) (1032, 2) (1033, 0) (1033, 1) TRUE (1033, 2) (1034, 0) (1034, 1) TRUE (1034, 2) (1035, 0) (1035, 1) TRUE (1035, 2) (1036, 0) (1036, 1) TRUE (1036, 2) (1037, 0) (1037, 1) TRUE (1037, 2) (1038, 0) (1038, 1) TRUE (1038, 2) (1039, 0) (1039, 1) TRUE (1039, 2) (1040, 0) (1040, 1) TRUE (1040, 2) (1041, 0) (1041, 1) TRUE (1041, 2) (1042, 0) (1042, 1) (1042, 2) (1043, 0) (1043, 1) TRUE (1043, 2) erase duplicate names (1044, 0) (1044, 1) TRUE (1044, 2) leaving new info on copied files, and old info (1045, 0) (1045, 1) TRUE (1045, 2) on existing files (1046, 0) (1046, 1) TRUE (1046, 2) (1047, 0) (1047, 1) TRUE (1047, 2) (1048, 0) (1048, 1) TRUE (1048, 2) (1049, 0) (1049, 1) TRUE (1049, 2) (1050, 0) (1050, 1) TRUE (1050, 2) (1051, 0) (1051, 1) TRUE (1051, 2) (1052, 0) (1052, 1) TRUE (1052, 2) (1053, 0) (1053, 1) TRUE (1053, 2) (1054, 0) (1054, 1) TRUE (1054, 2) (1055, 0) (1055, 1) TRUE (1055, 2) (1056, 0) (1056, 1) TRUE (1056, 2) (1057, 0) (1057, 1) TRUE (1057, 2) (1058, 0) (1058, 1) TRUE (1058, 2) (1059, 0) (1059, 1) TRUE (1059, 2) (1060, 0) (1060, 1) (1060, 2) (1061, 0) (1061, 1) TRUE (1061, 2) copy back to infofile (1062, 0) (1062, 1) TRUE (1062, 2) (1063, 0) (1063, 1) TRUE (1063, 2) (1064, 0) (1064, 1) TRUE (1064, 2) (1065, 0) (1065, 1) TRUE (1065, 2) (1066, 0) (1066, 1) TRUE (1066, 2) (1067, 0) (1067, 1) TRUE (1067, 2) (1068, 0) (1068, 1) TRUE (1068, 2) (1069, 0) (1069, 1) TRUE (1069, 2) (1070, 0) (1070, 1) TRUE (1070, 2) (1071, 0) (1071, 1) TRUE (1071, 2) (1072, 0) (1072, 1) TRUE (1072, 2) (1073, 0) (1073, 1) TRUE (1073, 2) (1074, 0) (1074, 1) TRUE (1074, 2) (1075, 0) (1075, 1) TRUE (1075, 2) (1076, 0) (1076, 1) #N/A! (1076, 2) (1077, 0) (1077, 1) TRUE (1077, 2) (1078, 0) (1078, 1) TRUE (1078, 2) (1079, 0) (1079, 1) TRUE (1079, 2) (1080, 0) (1080, 1) TRUE (1080, 2) (1081, 0) (1081, 1) TRUE (1081, 2) (1082, 0) (1082, 1) TRUE (1082, 2) (1083, 0) (1083, 1) TRUE (1083, 2) (1084, 0) (1084, 1) TRUE (1084, 2) (1085, 0) (1085, 1) TRUE (1085, 2) (1086, 0) (1086, 1) TRUE (1086, 2) (1087, 0) (1087, 1) TRUE (1087, 2) (1088, 0) (1088, 1) TRUE (1088, 2) end of warn option = 1 (1089, 0) (1089, 1) TRUE (1089, 2) (1090, 0) (1090, 1) (1090, 2) (1091, 0) (1091, 1) #N/A! (1091, 2) (1092, 0) (1092, 1) FALSE (1092, 2) (1093, 0) (1093, 1) 7 (1093, 2) (1094, 0) (1094, 1) TRUE (1094, 2) (1095, 0) (1095, 1) TRUE (1095, 2) (1096, 0) (1096, 1) TRUE (1096, 2) (1097, 0) (1097, 1) TRUE (1097, 2) (1098, 0) (1098, 1) TRUE (1098, 2) (1099, 0) (1099, 1) TRUE (1099, 2) (1100, 0) (1100, 1) TRUE (1100, 2) (1101, 0) (1101, 1) TRUE (1101, 2) (1102, 0) (1102, 1) TRUE (1102, 2) (1103, 0) (1103, 1) TRUE (1103, 2) (1104, 0) (1104, 1) TRUE (1104, 2) (1105, 0) (1105, 1) TRUE (1105, 2) (1106, 0) (1106, 1) TRUE (1106, 2) (1107, 0) (1107, 1) TRUE (1107, 2) (1108, 0) (1108, 1) TRUE (1108, 2) (1109, 0) (1109, 1) TRUE (1109, 2) (1110, 0) (1110, 1) TRUE (1110, 2) (1111, 0) (1111, 1) (1111, 2) (1112, 0) (1112, 1) Sortinfo (1112, 2) (1113, 0) (1113, 1) TRUE (1113, 2) (1114, 0) (1114, 1) TRUE (1114, 2) (1115, 0) (1115, 1) TRUE (1115, 2) (1116, 0) (1116, 1) FALSE (1116, 2) (1117, 0) (1117, 1) FALSE (1117, 2) (1118, 0) (1118, 1) FALSE (1118, 2) (1119, 0) (1119, 1) TRUE (1119, 2) (1120, 0) (1120, 1) TRUE (1120, 2) (1121, 0) (1121, 1) TRUE (1121, 2) (1122, 0) (1122, 1) TRUE (1122, 2) (1123, 0) (1123, 1) TRUE (1123, 2) (1124, 0) (1124, 1) TRUE (1124, 2) (1125, 0) (1125, 1) TRUE (1125, 2) (1126, 0) (1126, 1) TRUE (1126, 2) (1127, 0) (1127, 1) TRUE (1127, 2) (1128, 0) (1128, 1) TRUE (1128, 2) (1129, 0) (1129, 1) TRUE (1129, 2) (1130, 0) (1130, 1) TRUE (1130, 2) (1131, 0) (1131, 1) TRUE (1131, 2) (1132, 0) (1132, 1) TRUE (1132, 2) (1133, 0) (1133, 1) TRUE (1133, 2) (1134, 0) (1134, 1) FALSE (1134, 2) (1135, 0) (1135, 1) TRUE (1135, 2) (1136, 0) (1136, 1) TRUE (1136, 2) (1137, 0) (1137, 1) 6 (1137, 2) (1138, 0) (1138, 1) FALSE (1138, 2) (1139, 0) (1139, 1) FALSE (1139, 2) (1140, 0) (1140, 1) TRUE (1140, 2) (1141, 0) (1141, 1) (1141, 2) (1142, 0) (1142, 1) TRUE (1142, 2) (1143, 0) (1143, 1) FALSE (1143, 2) (1144, 0) (1144, 1) FALSE (1144, 2) (1145, 0) (1145, 1) TRUE (1145, 2) (1146, 0) (1146, 1) TRUE (1146, 2) (1147, 0) (1147, 1) TRUE (1147, 2) (1148, 0) (1148, 1) FALSE (1148, 2) (1149, 0) (1149, 1) TRUE (1149, 2) (1150, 0) (1150, 1) TRUE (1150, 2) (1151, 0) (1151, 1) TRUE (1151, 2) (1152, 0) (1152, 1) TRUE (1152, 2) (1153, 0) (1153, 1) TRUE (1153, 2) (1154, 0) (1154, 1) TRUE (1154, 2) (1155, 0) (1155, 1) TRUE (1155, 2) (1156, 0) (1156, 1) TRUE (1156, 2) (1157, 0) (1157, 1) TRUE (1157, 2) (1158, 0) (1158, 1) TRUE (1158, 2) (1159, 0) (1159, 1) TRUE (1159, 2) (1160, 0) (1160, 1) FALSE (1160, 2) (1161, 0) (1161, 1) FALSE (1161, 2) (1162, 0) (1162, 1) TRUE (1162, 2) (1163, 0) (1163, 1) TRUE (1163, 2) (1164, 0) (1164, 1) TRUE (1164, 2) (1165, 0) (1165, 1) TRUE (1165, 2) (1166, 0) (1166, 1) TRUE (1166, 2) (1167, 0) (1167, 1) TRUE (1167, 2) (1168, 0) (1168, 1) TRUE (1168, 2) (1169, 0) (1169, 1) TRUE (1169, 2) (1170, 0) (1170, 1) TRUE (1170, 2) (1171, 0) (1171, 1) TRUE (1171, 2) (1172, 0) (1172, 1) (1172, 2) (1173, 0) (1173, 1) DoSort (1173, 2) (1174, 0) (1174, 1) (1174, 2) (1175, 0) (1175, 1) (1175, 2) (1176, 0) (1176, 1) (1176, 2) (1177, 0) (1177, 1) (1177, 2) (1178, 0) (1178, 1) (1178, 2) (1179, 0) (1179, 1) (1179, 2) (1180, 0) (1180, 1) (1180, 2) (1181, 0) (1181, 1) (1181, 2) (1182, 0) (1182, 1) (1182, 2) (1183, 0) (1183, 1) (1183, 2) (1184, 0) (1184, 1) (1184, 2) (1185, 0) (1185, 1) (1185, 2) (1186, 0) (1186, 1) (1186, 2) (1187, 0) (1187, 1) (1187, 2) (1188, 0) (1188, 1) (1188, 2) (1189, 0) (1189, 1) (1189, 2) (1190, 0) (1190, 1) (1190, 2) (1191, 0) (1191, 1) (1191, 2) (1192, 0) (1192, 1) (1192, 2) (1193, 0) (1193, 1) (1193, 2) (1194, 0) (1194, 1) (1194, 2) (1195, 0) (1195, 1) (1195, 2) (1196, 0) (1196, 1) (1196, 2) (1197, 0) (1197, 1) (1197, 2) (1198, 0) (1198, 1) (1198, 2) (1199, 0) (1199, 1) (1199, 2) (1200, 0) (1200, 1) (1200, 2) (1201, 0) (1201, 1) (1201, 2) (1202, 0) (1202, 1) (1202, 2) (1203, 0) (1203, 1) SortMenu (1203, 2) (1204, 0) (1204, 1) (1204, 2) (1204, 3) (1204, 4) 320 (1204, 5) 144 (1204, 6) (1204, 7) (1205, 0) (1205, 1) 14 (1205, 2) 46 (1205, 3) 13 (1205, 4) 229 (1205, 5) 68 (1205, 6) (1205, 7) (1206, 0) (1206, 1) 11 (1206, 2) (1206, 3) (1206, 4) (1206, 5) (1206, 6) (1206, 7) 1 (1206, 8) SortOption (1207, 0) (1207, 1) 12 (1207, 2) (1207, 3) (1207, 4) (1207, 5) (1207, 6) Sort by File Name (1207, 7) (1208, 0) (1208, 1) 12 (1208, 2) (1208, 3) (1208, 4) (1208, 5) (1208, 6) Sort by Date and Time (1208, 7) (1209, 0) (1209, 1) 12 (1209, 2) (1209, 3) (1209, 4) (1209, 5) (1209, 6) Sort by Size (1209, 7) (1210, 0) (1210, 1) 1 (1210, 2) 55 (1210, 3) 96 (1210, 4) 88 (1210, 5) (1210, 6) OK (1210, 7) (1211, 0) (1211, 1) 2 (1211, 2) 173 (1211, 3) 96 (1211, 4) 88 (1211, 5) (1211, 6) Cancel (1211, 7) (1212, 0) (1212, 1) (1212, 2) (1213, 0) (1213, 1) (1213, 2) (1214, 0) (1214, 1) (1214, 2) (1215, 0) (1215, 1) (1215, 2) (1216, 0) (1216, 1) (1216, 2) (1217, 0) (1217, 1) DirFileType (1217, 2) (1218, 0) (1218, 1) XL* (1218, 2) (1219, 0) (1219, 1) (1219, 2) (1220, 0) (1220, 1) FileType (1220, 2) (1221, 0) (1221, 1) WK* (1221, 2) (1222, 0) (1222, 1) (1222, 2) (1223, 0) (1223, 1) CopyDirBox (1223, 2) (1224, 0) (1224, 1) (1224, 2) (1224, 3) (1224, 4) 479 (1224, 5) 162 (1224, 6) (1224, 7) (1225, 0) (1225, 1) 5 (1225, 2) 10 (1225, 3) 6 (1225, 4) (1225, 5) (1225, 6) Choose THE SOURCE of the files to be copied: (1225, 7) (1226, 0) (1226, 1) 14 (1226, 2) 19 (1226, 3) 30 (1226, 4) 449 (1226, 5) 85 (1226, 6) Files in: (1226, 7) (1227, 0) (1227, 1) 11 (1227, 2) (1227, 3) (1227, 4) (1227, 5) (1227, 6) (1227, 7) 0 (1227, 8) Copydiroption (1228, 0) (1228, 1) 12 (1228, 2) (1228, 3) (1228, 4) (1228, 5) (1228, 6) C:\XLSFILES (1228, 7) (1228, 8) CopyDirName (1229, 0) (1229, 1) 12 (1229, 2) (1229, 3) (1229, 4) (1229, 5) (1229, 6) A: (1229, 7) (1230, 0) (1230, 1) 12 (1230, 2) (1230, 3) (1230, 4) (1230, 5) (1230, 6) B: (1230, 7) (1231, 0) (1231, 1) 12 (1231, 2) (1231, 3) (1231, 4) (1231, 5) (1231, 6) User specified directory or drive (1231, 7) (1232, 0) (1232, 1) 1 (1232, 2) 100 (1232, 3) 135 (1232, 4) 88 (1232, 5) (1232, 6) OK (1232, 7) (1233, 0) (1233, 1) 2 (1233, 2) 239 (1233, 3) 134 (1233, 4) 88 (1233, 5) (1233, 6) Cancel (1233, 7) (1234, 0) (1234, 1) (1234, 2) (1235, 0) (1235, 1) GetSourceDir (1235, 2) (1236, 0) (1236, 1) (1236, 2) (1236, 3) (1236, 4) 416 (1236, 5) 122 (1236, 6) (1236, 7) 3 (1237, 0) (1237, 1) 5 (1237, 2) 11 (1237, 3) 6 (1237, 4) (1237, 5) (1237, 6) Please specify the full path of the directory or drive (1237, 7) (1238, 0) (1238, 1) 5 (1238, 2) 11 (1238, 3) 24 (1238, 4) (1238, 5) (1238, 6) (1238, 7) (1239, 0) (1239, 1) 6 (1239, 2) 10 (1239, 3) 55 (1239, 4) 395 (1239, 5) (1239, 6) (1239, 7) (1239, 8) UserSpecifiedDir (1240, 0) (1240, 1) 1 (1240, 2) 28 (1240, 3) 95 (1240, 4) 88 (1240, 5) (1240, 6) OK (1240, 7) (1241, 0) (1241, 1) 2 (1241, 2) 207 (1241, 3) 95 (1241, 4) 88 (1241, 5) (1241, 6) Cancel (1241, 7) (1242, 0) (1242, 1) (1242, 2) (1243, 0) (1243, 1) DestDirBox (1243, 2) (1244, 0) (1244, 1) (1244, 2) (1244, 3) (1244, 4) 370 (1244, 5) 244 (1244, 6) (1244, 7) (1245, 0) (1245, 1) 5 (1245, 2) 28 (1245, 3) 30 (1245, 4) (1245, 5) (1245, 6) Choose THE DESTINATION of the files: (1245, 7) (1246, 0) (1246, 1) 14 (1246, 2) 10 (1246, 3) 45 (1246, 4) 349 (1246, 5) 85 (1246, 6) (1246, 7) (1247, 0) (1247, 1) 11 (1247, 2) (1247, 3) (1247, 4) (1247, 5) (1247, 6) (1247, 7) 1 (1247, 8) DestDirOption (1248, 0) (1248, 1) 12 (1248, 2) (1248, 3) (1248, 4) (1248, 5) (1248, 6) To a directory listed in the spreadsheet * (1248, 7) (1249, 0) (1249, 1) 12 (1249, 2) (1249, 3) (1249, 4) (1249, 5) (1249, 6) A: (1249, 7) (1250, 0) (1250, 1) 12 (1250, 2) (1250, 3) (1250, 4) (1250, 5) (1250, 6) B: (1250, 7) (1251, 0) (1251, 1) 12 (1251, 2) (1251, 3) (1251, 4) (1251, 5) (1251, 6) User specified directory or drive (1251, 7) (1252, 0) (1252, 1) 1 (1252, 2) 34 (1252, 3) 148 (1252, 4) 143 (1252, 5) (1252, 6) OK (1252, 7) (1253, 0) (1253, 1) 2 (1253, 2) 235 (1253, 3) 148 (1253, 4) 88 (1253, 5) (1253, 6) Cancel (1253, 7) (1254, 0) (1254, 1) 5 (1254, 2) 27 (1254, 3) 6 (1254, 4) (1254, 5) (1254, 6) Files in C:\XLSFILES selected. (1254, 7) (1254, 8) SourceDirName (1255, 0) (1255, 1) 5 (1255, 2) 14 (1255, 3) 190 (1255, 4) (1255, 5) (1255, 6) * If this option selected, place the cell pointer (1255, 7) (1256, 0) (1256, 1) 5 (1256, 2) 14 (1256, 3) 208 (1256, 4) (1256, 5) (1256, 6) in the destination directory and double click (1256, 7) (1257, 0) (1257, 1) 5 (1257, 2) 14 (1257, 3) 226 (1257, 4) (1257, 5) (1257, 6) the mouse or press enter. (1257, 7) (1258, 0) (1258, 1) (1258, 2) (1259, 0) (1259, 1) SourceDir (1259, 2) (1260, 0) (1260, 1) C:\XLSFILES (1260, 2) (1261, 0) (1261, 1) (1261, 2) (1262, 0) (1262, 1) DestDir (1262, 2) (1263, 0) (1263, 1) C:\XXX (1263, 2) (1264, 0) (1264, 1) (1264, 2) (1265, 0) (1265, 1) EraseBox (1265, 2) (1266, 0) (1266, 1) (1266, 2) (1266, 3) (1266, 4) 483 (1266, 5) 168 (1266, 6) (1266, 7) (1267, 0) (1267, 1) 5 (1267, 2) 10 (1267, 3) 6 (1267, 4) (1267, 5) (1267, 6) Choose the files to be erased: (1267, 7) (1268, 0) (1268, 1) 14 (1268, 2) 10 (1268, 3) 36 (1268, 4) 462 (1268, 5) 85 (1268, 6) All files in: (1268, 7) (1269, 0) (1269, 1) 11 (1269, 2) (1269, 3) (1269, 4) (1269, 5) (1269, 6) (1269, 7) 1 (1269, 8) EraseDirOption (1270, 0) (1270, 1) 12 (1270, 2) (1270, 3) (1270, 4) (1270, 5) (1270, 6) C:\XXX\RRR (1270, 7) (1270, 8) EraseDirName (1271, 0) (1271, 1) 12 (1271, 2) (1271, 3) (1271, 4) (1271, 5) (1271, 6) A: (1271, 7) (1272, 0) (1272, 1) 12 (1272, 2) (1272, 3) (1272, 4) (1272, 5) (1272, 6) B: (1272, 7) (1273, 0) (1273, 1) 12 (1273, 2) (1273, 3) (1273, 4) (1273, 5) (1273, 6) User specified directory or drive (1273, 7) (1274, 0) (1274, 1) 1 (1274, 2) 127 (1274, 3) 137 (1274, 4) 88 (1274, 5) (1274, 6) OK (1274, 7) (1275, 0) (1275, 1) 2 (1275, 2) 262 (1275, 3) 137 (1275, 4) 88 (1275, 5) (1275, 6) Cancel (1275, 7) (1276, 0) (1276, 1) (1276, 2) (1277, 0) (1277, 1) GetEraseDirBox (1277, 2) (1278, 0) (1278, 1) (1278, 2) (1278, 3) (1278, 4) 416 (1278, 5) 117 (1278, 6) (1278, 7) 3 (1279, 0) (1279, 1) 5 (1279, 2) 82 (1279, 3) 6 (1279, 4) (1279, 5) (1279, 6) Enter the full path and name of (1279, 7) (1280, 0) (1280, 1) 5 (1280, 2) 82 (1280, 3) 24 (1280, 4) (1280, 5) (1280, 6) the directory to be erased: (1280, 7) (1281, 0) (1281, 1) 6 (1281, 2) 10 (1281, 3) 51 (1281, 4) 395 (1281, 5) (1281, 6) (1281, 7) e (1281, 8) UserEraseDir (1282, 0) (1282, 1) 1 (1282, 2) 92 (1282, 3) 90 (1282, 4) 88 (1282, 5) (1282, 6) OK (1282, 7) (1283, 0) (1283, 1) 2 (1283, 2) 234 (1283, 3) 89 (1283, 4) 88 (1283, 5) (1283, 6) Cancel (1283, 7) (1284, 0) (1284, 1) (1284, 2) (1285, 0) (1285, 1) EraseADir (1285, 2) (1286, 0) (1286, 1) TRUE (1286, 2) (1287, 0) (1287, 1) #N/A! (1287, 2) (1288, 0) (1288, 1) TRUE (1288, 2) (1289, 0) (1289, 1) TRUE (1289, 2) (1290, 0) (1290, 1) TRUE (1290, 2) (1291, 0) (1291, 1) TRUE (1291, 2) (1292, 0) (1292, 1) TRUE (1292, 2) (1293, 0) (1293, 1) #N/A! (1293, 2) (1294, 0) (1294, 1) TRUE (1294, 2) (1295, 0) (1295, 1) TRUE (1295, 2) (1296, 0) (1296, 1) 8 (1296, 2) (1297, 0) (1297, 1) FALSE (1297, 2) load in directory info (1298, 0) (1298, 2) (1299, 0) (1299, 1) TRUE (1299, 2) (1300, 0) (1300, 1) TRUE (1300, 2) (1301, 0) (1301, 1) TRUE (1301, 2) (1302, 0) (1302, 1) TRUE (1302, 2) (1303, 0) (1303, 1) FALSE (1303, 2) (1304, 0) (1304, 1) TRUE (1304, 2) (1305, 0) (1305, 1) (1305, 2) (1306, 0) (1306, 1) TRUE (1306, 2) (1307, 0) (1307, 2) (1308, 0) (1308, 1) FALSE (1308, 2) (1309, 0) (1309, 1) FALSE (1309, 2) (1310, 0) (1310, 2) (1311, 0) (1311, 1) TRUE (1311, 2) (1312, 0) (1312, 1) TRUE (1312, 2) (1313, 0) (1313, 1) 4 (1313, 2) (1314, 0) (1314, 1) FALSE (1314, 2) (1315, 0) (1315, 1) TRUE (1315, 2) (1316, 0) (1316, 1) TRUE (1316, 2) (1317, 0) (1317, 1) TRUE (1317, 2) (1318, 0) (1318, 1) TRUE (1318, 2) (1319, 0) (1319, 1) TRUE (1319, 2) (1320, 0) (1320, 1) FALSE (1320, 2) (1321, 0) (1321, 1) TRUE (1321, 2) (1322, 0) (1322, 1) TRUE (1322, 2) (1323, 0) (1323, 2) (1324, 0) (1324, 1) #N/A! (1324, 2) (1325, 0) (1325, 2) (1326, 0) (1326, 1) TRUE (1326, 2) (1327, 0) (1327, 1) TRUE (1327, 2) (1328, 0) (1328, 1) TRUE (1328, 2) (1329, 0) (1329, 1) (1329, 2) (1330, 0) (1330, 1) TRUE (1330, 2) (1331, 0) (1331, 1) FALSE (1331, 2) (1332, 0) (1332, 1) TRUE (1332, 2) (1333, 0) (1333, 1) (1333, 2) (1334, 0) (1334, 1) TRUE (1334, 2) create command to delete directory (1335, 0) (1335, 1) TRUE (1335, 2) (1336, 0) (1336, 1) TRUE (1336, 2) (1337, 0) (1337, 1) #N/A! (1337, 2) (1338, 0) (1338, 1) TRUE (1338, 2) (1339, 0) (1339, 1) TRUE (1339, 2) pause macro while dos commands runs (1340, 0) (1340, 1) TRUE (1340, 2) (1341, 0) (1341, 1) TRUE (1341, 2) (1342, 0) (1342, 1) TRUE (1342, 2) (1343, 0) (1343, 1) TRUE (1343, 2) (1344, 0) (1344, 1) (1344, 2) (1345, 0) (1345, 1) TRUE (1345, 2) further pause macro (1346, 0) (1346, 1) TRUE (1346, 2) (1347, 0) (1347, 1) TRUE (1347, 2) (1348, 0) (1348, 1) (1348, 2) (1349, 0) (1349, 1) TRUE (1349, 2) remove done file (1350, 0) (1350, 1) TRUE (1350, 2) (1351, 0) (1351, 1) TRUE (1351, 2) (1352, 0) (1352, 1) (1352, 2) (1353, 0) (1353, 1) TRUE (1353, 2) confirm directory was deleted (1354, 0) (1354, 1) TRUE (1354, 2) (1355, 0) (1355, 1) TRUE (1355, 2) (1356, 0) (1356, 1) FALSE (1356, 2) (1357, 0) (1357, 1) (1357, 2) (1358, 0) (1358, 1) TRUE (1358, 2) remove report file (1359, 0) (1359, 1) TRUE (1359, 2) (1360, 0) (1360, 1) TRUE (1360, 2) (1361, 0) (1361, 1) (1361, 2) (1362, 0) (1362, 1) TRUE (1362, 2) (1363, 0) (1363, 1) TRUE (1363, 2) remove rows associated with directory (1364, 0) (1364, 1) TRUE (1364, 2) (1365, 0) (1365, 1) TRUE (1365, 2) (1366, 0) (1366, 1) TRUE (1366, 2) (1367, 0) (1367, 1) TRUE (1367, 2) (1368, 0) (1368, 1) TRUE (1368, 2) (1369, 0) (1369, 1) TRUE (1369, 2) (1370, 0) (1370, 1) TRUE (1370, 2) (1371, 0) (1371, 1) TRUE (1371, 2) (1372, 0) (1372, 1) TRUE (1372, 2) (1373, 0) (1373, 1) TRUE (1373, 2) (1374, 0) (1374, 1) TRUE (1374, 2) (1375, 0) (1375, 1) (1375, 2) (1376, 0) (1376, 1) CreateADir (1376, 2) (1377, 0) (1377, 1) TRUE (1377, 2) (1378, 0) (1378, 1) TRUE (1378, 2) move to file column (1379, 0) (1379, 1) #N/A! (1379, 2) (1380, 0) (1380, 1) FALSE (1380, 2) (1381, 0) (1381, 1) FALSE (1381, 2) (1382, 0) (1382, 1) FALSE (1382, 2) (1383, 0) (1383, 1) (1383, 2) (1384, 0) (1384, 1) TRUE (1384, 2) (1385, 0) (1385, 1) TRUE (1385, 2) (1386, 0) (1386, 1) TRUE (1386, 2) (1387, 0) (1387, 1) (1387, 2) (1388, 0) (1388, 1) #N/A! (1388, 2) (1389, 0) (1389, 1) #N/A! (1389, 2) (1390, 0) (1390, 1) TRUE (1390, 2) (1391, 0) (1391, 1) TRUE (1391, 2) (1392, 0) (1392, 1) TRUE (1392, 2) (1393, 0) (1393, 1) TRUE (1393, 2) (1394, 0) (1394, 1) TRUE (1394, 2) (1395, 0) (1395, 2) (1396, 0) (1396, 1) TRUE (1396, 2) (1397, 0) (1397, 1) FALSE (1397, 2) (1398, 0) (1398, 1) TRUE (1398, 2) (1399, 0) (1399, 1) TRUE (1399, 2) (1400, 0) (1400, 1) TRUE (1400, 2) (1401, 0) (1401, 1) FALSE (1401, 2) (1402, 0) (1402, 1) 3 (1402, 2) (1403, 0) (1403, 1) FALSE (1403, 2) (1404, 0) (1404, 1) TRUE (1404, 2) (1405, 0) (1405, 2) (1406, 0) (1406, 1) TRUE (1406, 2) DO THIS IF ON A BLANK ROW (1407, 0) (1407, 2) (1408, 0) (1408, 1) TRUE (1408, 2) (1409, 0) (1409, 1) TRUE (1409, 2) (1410, 0) (1410, 1) TRUE (1410, 2) (1411, 0) (1411, 1) FALSE (1411, 2) (1412, 0) (1412, 1) TRUE (1412, 2) (1413, 0) (1413, 1) TRUE (1413, 2) mark current row (1414, 0) (1414, 1) TRUE (1414, 2) get current path (1415, 0) (1415, 1) TRUE (1415, 2) (1416, 0) (1416, 1) TRUE (1416, 2) (1417, 0) (1417, 1) #N/A! (1417, 2) (1418, 0) (1418, 1) #N/A! (1418, 2) (1419, 0) (1419, 1) TRUE (1419, 2) (1420, 0) (1420, 1) #N/A! (1420, 2) (1421, 0) (1421, 1) TRUE (1421, 2) (1422, 0) (1422, 1) TRUE (1422, 2) (1423, 0) (1423, 1) TRUE (1423, 2) (1424, 0) (1424, 1) 3 (1424, 2) (1425, 0) (1425, 1) FALSE (1425, 2) stop if cancel selected (1426, 0) (1426, 1) TRUE (1426, 2) (1427, 0) (1427, 1) TRUE (1427, 2) (1428, 0) (1428, 1) TRUE (1428, 2) (1429, 0) (1429, 1) TRUE (1429, 2) (1430, 0) (1430, 1) FALSE (1430, 2) (1431, 0) (1431, 1) TRUE (1431, 2) (1432, 0) (1432, 1) TRUE (1432, 2) (1433, 0) (1433, 1) FALSE (1433, 2) (1434, 0) (1434, 1) TRUE (1434, 2) (1435, 0) (1435, 1) TRUE (1435, 2) (1436, 0) (1436, 1) (1436, 2) (1437, 0) (1437, 1) #VALUE! (1437, 2) (1438, 0) (1438, 1) TRUE (1438, 2) (1439, 0) (1439, 1) TRUE (1439, 2) (1440, 0) (1440, 1) TRUE (1440, 2) (1441, 0) (1441, 1) FALSE (1441, 2) (1442, 0) (1442, 1) (1442, 2) (1443, 0) (1443, 1) TRUE (1443, 2) (1444, 0) (1444, 1) TRUE (1444, 2) (1445, 0) (1445, 1) TRUE (1445, 2) (1446, 0) (1446, 1) TRUE (1446, 2) (1447, 0) (1447, 1) TRUE (1447, 2) (1448, 0) (1448, 1) TRUE (1448, 2) (1449, 0) (1449, 1) (1449, 2) (1450, 0) (1450, 1) TRUE (1450, 2) (1451, 0) (1451, 1) TRUE (1451, 2) (1452, 0) (1452, 1) TRUE (1452, 2) (1453, 0) (1453, 1) TRUE (1453, 2) (1454, 0) (1454, 1) (1454, 2) (1455, 0) (1455, 1) FALSE (1455, 2) (1456, 0) (1456, 1) TRUE (1456, 2) (1457, 0) (1457, 1) TRUE (1457, 2) (1458, 0) (1458, 1) TRUE (1458, 2) (1459, 0) (1459, 1) FALSE (1459, 2) (1460, 0) (1460, 1) TRUE (1460, 2) (1461, 0) (1461, 1) (1461, 2) (1462, 0) (1462, 1) TRUE (1462, 2) (1463, 0) (1463, 1) TRUE (1463, 2) Confirm that a new name has been provided (1464, 0) (1464, 1) TRUE (1464, 2) (1465, 0) (1465, 1) FALSE (1465, 2) (1466, 0) (1466, 1) (1466, 2) (1467, 0) (1467, 1) TRUE (1467, 2) confirm that path has not changed (1468, 0) (1468, 1) TRUE (1468, 2) (1469, 0) (1469, 1) TRUE (1469, 2) (1470, 0) (1470, 1) 8 (1470, 2) (1471, 0) (1471, 1) TRUE (1471, 2) (1472, 0) (1472, 1) FALSE (1472, 2) (1473, 0) (1473, 1) (1473, 2) (1474, 0) (1474, 1) TRUE (1474, 2) END OF BLANK ROW OPTION (1475, 0) (1475, 1) (1475, 2) (1476, 0) (1476, 1) TRUE (1476, 2) remove alldone.mgr flag file if it exists (1477, 0) (1477, 1) TRUE (1477, 2) (1478, 0) (1478, 1) TRUE (1478, 2) (1479, 0) (1479, 1) (1479, 2) (1480, 0) (1480, 1) TRUE (1480, 2) Remove report file if it exists (1481, 0) (1481, 1) FALSE (1481, 2) (1482, 0) (1482, 1) TRUE (1482, 2) (1483, 0) (1483, 1) (1483, 2) (1484, 0) (1484, 1) TRUE (1484, 2) construct exec command (1485, 0) (1485, 1) TRUE (1485, 2) (1486, 0) (1486, 1) TRUE (1486, 2) (1487, 0) (1487, 1) #N/A! (1487, 2) execute filectrl (1488, 0) (1488, 1) TRUE (1488, 2) (1489, 0) (1489, 1) TRUE (1489, 2) pause excel macro while exec executes (1490, 0) (1490, 1) TRUE (1490, 2) exit after 10 seconds (1491, 0) (1491, 1) TRUE (1491, 2) (1492, 0) (1492, 1) TRUE (1492, 2) (1493, 0) (1493, 1) TRUE (1493, 2) (1494, 0) (1494, 1) (1494, 2) (1495, 0) (1495, 1) TRUE (1495, 2) display box to further pause macro (1496, 0) (1496, 1) TRUE (1496, 2) (1497, 0) (1497, 1) TRUE (1497, 2) (1498, 0) (1498, 1) (1498, 2) (1499, 0) (1499, 1) TRUE (1499, 2) remove done file (1500, 0) (1500, 1) TRUE (1500, 2) (1501, 0) (1501, 1) TRUE (1501, 2) (1502, 0) (1502, 1) (1502, 2) (1503, 0) (1503, 1) TRUE (1503, 2) if OK file doesn't exist, dos command did not work (1504, 0) (1504, 1) TRUE (1504, 2) (1505, 0) (1505, 1) TRUE (1505, 2) (1506, 0) (1506, 1) FALSE (1506, 2) (1507, 0) (1507, 1) (1507, 2) (1508, 0) (1508, 1) TRUE (1508, 2) (1509, 0) (1509, 1) TRUE (1509, 2) (1510, 0) (1510, 1) TRUE (1510, 2) (1511, 0) (1511, 1) (1511, 2) (1512, 0) (1512, 1) FALSE (1512, 2) (1513, 0) (1513, 1) TRUE (1513, 2) (1514, 0) (1514, 1) TRUE (1514, 2) add two lines and insert new directory name (1515, 0) (1515, 1) #N/A! (1515, 2) (1516, 0) (1516, 1) TRUE (1516, 2) (1517, 0) (1517, 1) #N/A! (1517, 2) (1518, 0) (1518, 1) TRUE (1518, 2) (1519, 0) (1519, 1) TRUE (1519, 2) (1520, 0) (1520, 1) FALSE (1520, 2) (1521, 0) (1521, 1) TRUE (1521, 2) (1522, 0) (1522, 1) TRUE (1522, 2) (1523, 0) (1523, 1) TRUE (1523, 2) (1524, 0) (1524, 1) TRUE (1524, 2) (1525, 0) (1525, 1) TRUE (1525, 2) (1526, 0) (1526, 1) TRUE (1526, 2) (1527, 0) (1527, 1) TRUE (1527, 2) (1528, 0) (1528, 1) TRUE (1528, 2) (1529, 0) (1529, 1) TRUE (1529, 2) (1530, 0) (1530, 1) TRUE (1530, 2) (1531, 0) (1531, 1) TRUE (1531, 2) copy format (1532, 0) (1532, 1) TRUE (1532, 2) remove borders (1533, 0) (1533, 1) TRUE (1533, 2) (1534, 0) (1534, 1) TRUE (1534, 2) (1535, 0) (1535, 1) TRUE (1535, 2) (1536, 0) (1536, 1) TRUE (1536, 2) (1537, 0) (1537, 1) FALSE (1537, 2) (1538, 0) (1538, 1) FALSE (1538, 2) (1539, 0) (1539, 1) TRUE (1539, 2) (1540, 0) (1540, 1) TRUE (1540, 2) (1541, 0) (1541, 1) (1541, 2) (1542, 0) (1542, 1) (1542, 2) (1543, 0) (1543, 1) (1543, 2) (1544, 0) (1544, 1) (1544, 2) (1545, 0) (1545, 1) (1545, 2) (1546, 0) (1546, 1) (1546, 2) (1547, 0) (1547, 1) (1547, 2) (1548, 0) (1548, 1) (1548, 2) (1549, 0) (1549, 1) (1549, 2) (1550, 0) (1550, 1) (1550, 2) (1551, 0) (1551, 1) (1551, 2) (1552, 0) (1552, 1) (1552, 2) (1553, 0) (1553, 1) (1553, 2) (1554, 0) (1554, 1) NewDirectoryBox (1554, 2) (1555, 0) (1555, 1) (1555, 2) (1555, 3) (1555, 4) 500 (1555, 5) 159 (1555, 6) (1555, 7) (1556, 0) (1556, 1) 5 (1556, 2) 10 (1556, 3) 31 (1556, 4) (1556, 5) (1556, 6) Please enten the new directory name and the complete path: (1556, 7) (1557, 0) (1557, 1) 6 (1557, 2) 10 (1557, 3) 49 (1557, 4) 477 (1557, 5) (1557, 6) (1557, 7) C:\XXX\RRR (1557, 8) NewDirName (1558, 0) (1558, 1) 1 (1558, 2) 59 (1558, 3) 132 (1558, 4) 222 (1558, 5) (1558, 6) OK - Create new directory (1558, 7) (1559, 0) (1559, 1) 2 (1559, 2) 345 (1559, 3) 129 (1559, 4) 88 (1559, 5) (1559, 6) Cancel (1559, 7) (1560, 0) (1560, 1) 5 (1560, 2) 117 (1560, 3) 6 (1560, 4) (1560, 5) (1560, 6) NEW DIRECTORY DIALOG BOX (1560, 7) (1561, 0) (1561, 1) 5 (1561, 2) 10 (1561, 3) 86 (1561, 4) (1561, 5) (1561, 6) Please enter documentation on the directory: (1561, 7) (1562, 0) (1562, 1) 6 (1562, 2) 10 (1562, 3) 101 (1562, 4) 479 (1562, 5) (1562, 6) (1562, 7) (1562, 8) NewDirDoc (1563, 0) (1563, 1) (1563, 2) (1564, 0) (1564, 1) DirWarningBox (1564, 2) (1565, 0) (1565, 1) (1565, 2) (1565, 3) (1565, 4) 534 (1565, 5) 168 (1565, 6) (1565, 7) (1566, 0) (1566, 1) 5 (1566, 2) 10 (1566, 3) 6 (1566, 4) (1566, 5) (1566, 6) The first part of the path for the new directory should be (1566, 7) (1567, 0) (1567, 1) 5 (1567, 2) 10 (1567, 3) 24 (1567, 4) (1567, 5) (1567, 6) C:\ACTIVE\ZZ\ (1567, 7) (1568, 0) (1568, 1) 5 (1568, 2) 10 (1568, 3) 42 (1568, 4) (1568, 5) (1568, 6) The directory you specified (1568, 7) (1569, 0) (1569, 1) 5 (1569, 2) 10 (1569, 3) 60 (1569, 4) (1569, 5) (1569, 6) C:\ACTIVE\AGINGS (1569, 7) (1570, 0) (1570, 1) 5 (1570, 2) 10 (1570, 3) 78 (1570, 4) (1570, 5) (1570, 6) if created will not be shown in the current section when a directory (1570, 7) (1571, 0) (1571, 1) 5 (1571, 2) 10 (1571, 3) 96 (1571, 4) (1571, 5) (1571, 6) update is done. To create this directory, you need to create a new (1571, 7) (1572, 0) (1572, 1) 5 (1572, 2) 10 (1572, 3) 114 (1572, 4) (1572, 5) (1572, 6) section using the other options on the main menu. (1572, 7) (1573, 0) (1573, 1) 1 (1573, 2) 195 (1573, 3) 141 (1573, 4) 88 (1573, 5) (1573, 6) OK (1573, 7) (1574, 0) (1574, 1) (1574, 2) (1575, 0) (1575, 1) RenameFile (1575, 2) (1575, 4) (1576, 0) (1576, 1) TRUE (1576, 2) (1576, 4) (1577, 0) (1577, 1) #N/A! (1577, 2) (1577, 4) (1578, 0) (1578, 1) TRUE (1578, 2) (1578, 4) (1579, 0) (1579, 1) TRUE (1579, 2) (1579, 4) (1580, 0) (1580, 1) (1580, 2) (1580, 4) (1581, 0) (1581, 1) TRUE (1581, 2) confirm cell pointer is on a file (1581, 4) (1582, 0) (1582, 1) TRUE (1582, 2) (1582, 4) (1583, 0) (1583, 1) TRUE (1583, 2) (1583, 4) (1584, 0) (1584, 1) FALSE (1584, 2) (1584, 4) (1585, 0) (1585, 1) (1585, 2) (1586, 0) (1586, 1) TRUE (1586, 2) store info about file and directory (1587, 0) (1587, 1) TRUE (1587, 2) (1588, 0) (1588, 1) TRUE (1588, 2) (1589, 0) (1589, 1) TRUE (1589, 2) (1590, 0) (1590, 1) TRUE (1590, 2) (1591, 0) (1591, 1) TRUE (1591, 2) (1592, 0) (1592, 1) #N/A! (1592, 2) (1593, 0) (1593, 1) TRUE (1593, 2) (1594, 0) (1594, 1) #N/A! (1594, 2) (1595, 0) (1595, 1) TRUE (1595, 2) (1596, 0) (1596, 1) TRUE (1596, 2) name first file temp2 for use in sorting (1597, 0) (1597, 1) (1597, 2) (1598, 0) (1598, 1) TRUE (1598, 2) relocate cell pointer (1599, 0) (1599, 1) TRUE (1599, 2) (1600, 0) (1600, 1) TRUE (1600, 2) (1601, 0) (1601, 1) (1601, 2) (1602, 0) (1602, 1) TRUE (1602, 2) (1603, 0) (1603, 1) FALSE (1603, 2) (1604, 0) (1604, 1) TRUE (1604, 2) (1605, 0) (1605, 1) TRUE (1605, 2) (1606, 0) (1606, 1) (1606, 2) (1607, 0) (1607, 1) 6 (1607, 2) display rename dialog box (1608, 0) (1608, 1) FALSE (1608, 2) (1609, 0) (1609, 1) TRUE (1609, 2) (1610, 0) (1610, 1) TRUE (1610, 2) (1611, 0) (1611, 1) TRUE (1611, 2) (1612, 0) (1612, 1) FALSE (1612, 2) (1613, 0) (1613, 1) TRUE (1613, 2) (1614, 0) (1614, 1) (1614, 2) (1615, 0) (1615, 1) TRUE (1615, 2) (1616, 0) (1616, 1) TRUE (1616, 2) (1617, 0) (1617, 1) TRUE (1617, 2) (1618, 0) (1618, 1) (1618, 2) (1619, 0) (1619, 1) #VALUE! (1619, 2) confirm that only a file name was entered (1620, 0) (1620, 1) TRUE (1620, 2) (1621, 0) (1621, 1) TRUE (1621, 2) (1622, 0) (1622, 1) TRUE (1622, 2) (1623, 0) (1623, 1) FALSE (1623, 2) (1624, 0) (1624, 1) (1624, 2) (1625, 0) (1625, 1) TRUE (1625, 2) check length of new file name (1626, 0) (1626, 1) TRUE (1626, 2) (1627, 0) (1627, 1) TRUE (1627, 2) (1628, 0) (1628, 1) TRUE (1628, 2) (1629, 0) (1629, 1) (1629, 2) (1630, 0) (1630, 1) #N/A! (1630, 2) get just file name (1631, 0) (1631, 1) #N/A! (1631, 2) get just file type (1632, 0) (1632, 1) (1632, 2) (1633, 0) (1633, 1) TRUE (1633, 2) Confirm new file does not exist (1634, 0) (1634, 1) TRUE (1634, 2) (1635, 0) (1635, 1) TRUE (1635, 2) (1636, 0) (1636, 1) TRUE (1636, 2) (1637, 0) (1637, 1) (1637, 2) (1638, 0) (1638, 1) TRUE (1638, 2) remove alldone.mgr flag file if it exists (1639, 0) (1639, 1) TRUE (1639, 2) (1640, 0) (1640, 1) TRUE (1640, 2) (1641, 0) (1641, 1) (1641, 2) (1642, 0) (1642, 1) TRUE (1642, 2) Remove report file if it exists (1643, 0) (1643, 1) TRUE (1643, 2) (1644, 0) (1644, 1) TRUE (1644, 2) (1645, 0) (1645, 1) (1645, 2) (1646, 0) (1646, 1) TRUE (1646, 2) construct exec command (1647, 0) (1647, 1) TRUE (1647, 2) (1648, 0) (1648, 1) TRUE (1648, 2) (1649, 0) (1649, 1) #N/A! (1649, 2) execute filectrl (1650, 0) (1650, 1) TRUE (1650, 2) (1651, 0) (1651, 1) TRUE (1651, 2) pause excel macro while exec executes (1652, 0) (1652, 1) TRUE (1652, 2) exit after 10 seconds (1653, 0) (1653, 1) TRUE (1653, 2) (1654, 0) (1654, 1) TRUE (1654, 2) (1655, 0) (1655, 1) TRUE (1655, 2) (1656, 0) (1656, 1) (1656, 2) (1657, 0) (1657, 1) TRUE (1657, 2) display box to further pause macro (1658, 0) (1658, 1) TRUE (1658, 2) (1659, 0) (1659, 1) TRUE (1659, 2) (1660, 0) (1660, 1) (1660, 2) (1661, 0) (1661, 1) TRUE (1661, 2) remove done file (1662, 0) (1662, 1) TRUE (1662, 2) (1663, 0) (1663, 1) TRUE (1663, 2) (1664, 0) (1664, 1) (1664, 2) (1665, 0) (1665, 1) TRUE (1665, 2) (1666, 0) (1666, 1) TRUE (1666, 2) (1667, 0) (1667, 1) TRUE (1667, 2) (1668, 0) (1668, 1) (1668, 2) (1669, 0) (1669, 1) TRUE (1669, 2) confirm rename (1670, 0) (1670, 1) TRUE (1670, 2) (1671, 0) (1671, 1) TRUE (1671, 2) (1672, 0) (1672, 1) TRUE (1672, 2) (1673, 0) (1673, 1) FALSE (1673, 2) (1674, 0) (1674, 1) TRUE (1674, 2) (1675, 0) (1675, 1) TRUE (1675, 2) put in new name and documentation (1676, 0) (1676, 1) TRUE (1676, 2) (1677, 0) (1677, 1) TRUE (1677, 2) (1678, 0) (1678, 1) TRUE (1678, 2) (1679, 0) (1679, 1) TRUE (1679, 2) (1680, 0) (1680, 1) (1680, 2) (1681, 0) (1681, 1) TRUE (1681, 2) select and sort data (1682, 0) (1682, 1) TRUE (1682, 2) (1683, 0) (1683, 1) TRUE (1683, 2) (1684, 0) (1684, 1) TRUE (1684, 2) (1685, 0) (1685, 1) TRUE (1685, 2) (1686, 0) (1686, 1) TRUE (1686, 2) (1687, 0) (1687, 1) TRUE (1687, 2) (1688, 0) (1688, 1) TRUE (1688, 2) (1689, 0) (1689, 1) TRUE (1689, 2) (1690, 0) (1690, 1) TRUE (1690, 2) (1691, 0) (1691, 1) TRUE (1691, 2) (1692, 0) (1692, 1) TRUE (1692, 2) (1693, 0) (1693, 1) (1693, 2) (1694, 0) (1694, 1) DirExist (1694, 2) Checks to see if a directory exists (1695, 0) (1695, 1) TRUE (1695, 2) (1696, 0) (1696, 1) TRUE (1696, 2) (1697, 0) (1697, 1) #N/A! (1697, 2) (1698, 0) (1698, 1) #N/A! (1698, 2) (1699, 0) (1699, 1) TRUE (1699, 2) (1700, 0) (1700, 1) TRUE (1700, 2) (1701, 0) (1701, 1) TRUE (1701, 2) (1702, 0) (1702, 1) TRUE (1702, 2) (1703, 0) (1703, 1) FALSE (1703, 2) (1704, 0) (1704, 1) TRUE (1704, 2) (1705, 0) (1705, 1) TRUE (1705, 2) (1706, 0) (1706, 1) (1706, 2) (1707, 0) (1707, 1) SearchInfo (1707, 2) (1708, 0) (1708, 1) TRUE (1708, 2) (1709, 0) (1709, 1) TRUE (1709, 2) (1710, 0) (1710, 1) TRUE (1710, 2) (1711, 0) (1711, 1) TRUE (1711, 2) (1712, 0) (1712, 1) TRUE (1712, 2) (1713, 0) (1713, 1) TRUE (1713, 2) (1714, 0) (1714, 1) 4 (1714, 2) (1715, 0) (1715, 1) FALSE (1715, 2) (1716, 0) (1716, 1) TRUE (1716, 2) (1717, 0) (1717, 1) TRUE (1717, 2) (1718, 0) (1718, 1) TRUE (1718, 2) (1719, 0) (1719, 1) FALSE (1719, 2) (1720, 0) (1720, 1) TRUE (1720, 2) (1721, 0) (1721, 1) TRUE (1721, 2) (1722, 0) (1722, 1) TRUE (1722, 2) (1723, 0) (1723, 1) TRUE (1723, 2) (1724, 0) (1724, 1) TRUE (1724, 2) (1725, 0) (1725, 1) TRUE (1725, 2) (1726, 0) (1726, 1) TRUE (1726, 2) (1727, 0) (1727, 1) TRUE (1727, 2) (1728, 0) (1728, 1) TRUE (1728, 2) (1729, 0) (1729, 1) (1729, 2) (1730, 0) (1730, 1) (1730, 2) (1731, 1) SearchBox (1731, 2) (1732, 1) (1732, 2) (1732, 3) (1732, 4) 357 (1732, 5) 218 (1732, 6) (1732, 7) 2 (1733, 1) 5 (1733, 2) 12 (1733, 3) 112 (1733, 4) (1733, 5) (1733, 6) Enter text to be searched for: (1733, 7) (1734, 1) 6 (1734, 2) 10 (1734, 3) 133 (1734, 4) 336 (1734, 5) (1734, 6) (1734, 7) (1734, 8) SearchText (1735, 1) 5 (1735, 2) 45 (1735, 3) 166 (1735, 4) (1735, 5) (1735, 6) Use F7 to find the next occurrence. (1735, 7) (1736, 1) 1 (1736, 2) 76 (1736, 3) 191 (1736, 4) 88 (1736, 5) (1736, 6) OK (1736, 7) (1737, 1) 2 (1737, 2) 188 (1737, 3) 191 (1737, 4) 88 (1737, 5) (1737, 6) Cancel (1737, 7) (1738, 1) 14 (1738, 2) 21 (1738, 3) 19 (1738, 4) 306 (1738, 5) 68 (1738, 6) Search (1738, 7) (1739, 1) 11 (1739, 2) (1739, 3) (1739, 4) (1739, 5) (1739, 6) (1739, 7) 3 (1739, 8) SearchOption (1740, 1) 12 (1740, 2) (1740, 3) (1740, 4) (1740, 5) (1740, 6) From the top of the current section (1740, 7) (1741, 1) 12 (1741, 2) (1741, 3) (1741, 4) (1741, 5) (1741, 6) From the top of the spreadsheet (1741, 7) (1742, 1) 12 (1742, 2) (1742, 3) (1742, 4) (1742, 5) (1742, 6) From the cell pointer location (1742, 7) (1743, 1) (1743, 2) (1744, 1) (1744, 2) (1745, 1) RenameBox (1745, 2) (1746, 1) (1746, 2) (1746, 3) (1746, 4) 615 (1746, 5) 173 (1746, 6) (1746, 7) 2 (1747, 1) 5 (1747, 2) 10 (1747, 3) 6 (1747, 4) (1747, 5) (1747, 6) Please enter the new name for ABCDEFGH.XLS (1747, 7) (1748, 1) 6 (1748, 2) 10 (1748, 3) 23 (1748, 4) 160 (1748, 5) (1748, 6) (1748, 7) AAA (1749, 1) 5 (1749, 2) 11 (1749, 3) 50 (1749, 4) (1749, 5) (1749, 6) (enter only a filename. Do not enter the filetype) (1749, 7) (1750, 1) 5 (1750, 2) 10 (1750, 3) 90 (1750, 4) (1750, 5) (1750, 6) Enter or change the documentation if desired (1750, 7) (1751, 1) 6 (1751, 2) 10 (1751, 3) 105 (1751, 4) 594 (1751, 5) (1751, 6) (1751, 7) dfsfasfsffsf (1752, 1) 1 (1752, 2) 166 (1752, 3) 146 (1752, 4) 88 (1752, 5) (1752, 6) RENAME (1752, 7) (1753, 1) 2 (1753, 2) 275 (1753, 3) 146 (1753, 4) 88 (1753, 5) (1753, 6) Cancel (1753, 7) (1754, 1) (1754, 2) (1755, 0) (1755, 1) FileName (1755, 2) (1756, 0) (1756, 1) CANADA.WK3 (1756, 2) (1757, 0) (1757, 1) (1757, 2) (1758, 0) (1758, 1) DirName (1758, 2) (1759, 0) (1759, 1) C:\XLSFILES (1759, 2) (1759, 3) (1760, 0) (1760, 1) (1760, 2) (1760, 4) (1761, 0) (1761, 1) OpenAFile (1761, 2) (1761, 3) (1762, 0) (1762, 1) TRUE (1762, 2) (1762, 3) chkcfg (1762, 4) chkcfg (1763, 0) (1763, 1) TRUE (1763, 2) (1763, 3) FALSE (1763, 4) FALSE (1764, 0) (1764, 1) TRUE (1764, 2) (1764, 3) TRUE (1764, 4) TRUE (1765, 0) (1765, 1) TRUE (1765, 2) (1765, 3) TRUE (1765, 4) TRUE (1766, 0) (1766, 1) (1766, 2) (1766, 3) TRUE (1766, 4) TRUE (1767, 0) (1767, 1) FALSE (1767, 2) (1767, 3) TRUE (1767, 4) TRUE (1768, 0) (1768, 1) #N/A! (1768, 2) (1768, 3) FALSE (1768, 4) FALSE (1769, 0) (1769, 1) #N/A! (1769, 2) (1769, 3) TRUE (1769, 4) TRUE (1770, 0) (1770, 1) #N/A! (1770, 2) (1770, 3) (1770, 4) (1771, 0) (1771, 1) TRUE (1771, 2) (1771, 3) TRUE (1771, 4) TRUE (1772, 0) (1772, 1) #N/A! (1772, 2) (1772, 3) TRUE (1772, 4) TRUE (1773, 1) TRUE (1773, 2) goes to file column (1774, 1) TRUE (1774, 2) (1775, 1) TRUE (1775, 2) (1776, 1) TRUE (1776, 2) (1777, 1) FALSE (1777, 2) (1778, 1) TRUE (1778, 2) (1779, 1) #N/A! (1779, 2) goto directory name (1780, 1) TRUE (1780, 2) (1781, 1) TRUE (1781, 2) (1782, 1) #N/A! (1782, 2) (1783, 1) TRUE (1783, 2) (1784, 1) TRUE (1784, 2) (1785, 1) TRUE (1785, 2) (1786, 1) TRUE (1786, 2) (1787, 1) TRUE (1787, 2) (1788, 1) FALSE (1788, 2) (1789, 1) TRUE (1789, 2) (1790, 1) TRUE (1790, 2) (1791, 1) TRUE (1791, 2) (1792, 1) (1792, 2) (1793, 1) TRUE (1793, 2) (1794, 1) FALSE (1794, 2) (1795, 1) TRUE (1795, 2) (1796, 1) (1796, 2) (1797, 1) OpenError (1797, 2) (1798, 1) TRUE (1798, 2) (1799, 1) TRUE (1799, 2) (1800, 1) TRUE (1800, 2) (1801, 1) FALSE (1801, 2) (1802, 1) (1802, 2) (1803, 1) NextSection (1803, 2) (1804, 1) TRUE (1804, 2) (1805, 1) TRUE (1805, 2) (1806, 1) TRUE (1806, 2) (1807, 1) FALSE (1807, 2) (1808, 1) TRUE (1808, 2) (1809, 1) TRUE (1809, 2) (1810, 1) TRUE (1810, 2) (1811, 1) TRUE (1811, 2) (1812, 1) TRUE (1812, 2) (1813, 1) TRUE (1813, 2) (1814, 1) TRUE (1814, 2) (1815, 1) FALSE (1815, 2) (1816, 1) TRUE (1816, 2) (1817, 1) TRUE (1817, 2) (1818, 1) TRUE (1818, 2) (1819, 1) TRUE (1819, 2) (1820, 1) TRUE (1820, 2) (1821, 1) TRUE (1821, 2) (1822, 1) TRUE (1822, 2) (1823, 1) (1823, 2) (1824, 1) PrevSection (1824, 2) (1825, 1) TRUE (1825, 2) (1826, 1) TRUE (1826, 2) (1827, 1) FALSE (1827, 2) (1828, 1) TRUE (1828, 2) (1829, 1) FALSE (1829, 2) (1830, 1) FALSE (1830, 2) (1831, 1) TRUE (1831, 2) (1832, 1) TRUE (1832, 2) (1833, 1) TRUE (1833, 2) (1834, 1) TRUE (1834, 2) (1835, 1) TRUE (1835, 2) (1836, 1) TRUE (1836, 2) (1837, 1) TRUE (1837, 2) (1838, 1) TRUE (1838, 2) (1839, 1) TRUE (1839, 2) (1840, 1) TRUE (1840, 2) (1841, 1) (1841, 2) (1842, 0) (1842, 1) execfront (1842, 2) (1843, 0) (1843, 1) exec(" (1843, 2) (1844, 0) (1844, 1) (1844, 2) (1845, 0) (1845, 1) execback (1845, 2) (1846, 0) (1846, 1) ",3) (1846, 2) (1847, 0) (1847, 1) (1847, 2) (1848, 0) (1848, 1) CopyMoveOption (1848, 2) (1849, 0) (1849, 1) COPY (1849, 2) (1850, 0) (1850, 1) (1850, 2) (1851, 0) (1851, 1) COPY_FILE (1851, 2) CALLED BY MAIN MENU (1852, 0) (1852, 1) TRUE (1852, 2) (1853, 0) (1853, 1) TRUE (1853, 2) (1854, 0) (1854, 1) TRUE (1854, 2) (1855, 0) (1855, 1) #N/A! (1855, 2) (1856, 0) (1856, 1) TRUE (1856, 2) (1857, 0) (1857, 1) (1857, 2) (1858, 0) (1858, 1) Move_File (1858, 2) (1859, 0) (1859, 1) TRUE (1859, 2) (1860, 0) (1860, 1) TRUE (1860, 2) (1861, 0) (1861, 1) TRUE (1861, 2) (1862, 0) (1862, 1) #N/A! (1862, 2) (1863, 0) (1863, 1) TRUE (1863, 2) (1864, 0) (1864, 1) (1864, 2) (1865, 0) (1865, 1) SelectDest (1865, 2) (1866, 0) (1866, 1) (1866, 2) (1866, 3) (1866, 4) 408 (1866, 5) 302 (1866, 6) (1866, 7) (1867, 0) (1867, 1) 5 (1867, 2) 10 (1867, 3) 6 (1867, 4) (1867, 5) (1867, 6) The following file has been selected to be copied: (1867, 7) (1868, 0) (1868, 1) 5 (1868, 2) 49 (1868, 3) 29 (1868, 4) (1868, 5) (1868, 6) BBB.XLS (1868, 7) (1868, 8) SelectedFile (1869, 0) (1869, 1) 5 (1869, 2) 49 (1869, 3) 47 (1869, 4) (1869, 5) (1869, 6) C:\XLSFILES (1869, 7) (1869, 8) SourceDirectory (1870, 0) (1870, 1) 5 (1870, 2) 49 (1870, 3) 65 (1870, 4) (1870, 5) (1870, 6) dfsfasfsffsf (1870, 7) (1870, 8) SelectedFileDesc (1871, 0) (1871, 1) 5 (1871, 2) 10 (1871, 3) 85 (1871, 4) (1871, 5) (1871, 6) Please select the destination: (1871, 7) (1872, 0) (1872, 1) 14 (1872, 2) 19 (1872, 3) 102 (1872, 4) 351 (1872, 5) 85 (1872, 6) (1872, 7) (1873, 0) (1873, 1) 11 (1873, 2) (1873, 3) (1873, 4) (1873, 5) (1873, 6) (1873, 7) 1 (1873, 8) DestFileOption (1874, 0) (1874, 1) 12 (1874, 2) (1874, 3) (1874, 4) (1874, 5) (1874, 6) To a directory listed in the spreadsheet * (1874, 7) (1875, 0) (1875, 1) 12 (1875, 2) (1875, 3) (1875, 4) (1875, 5) (1875, 6) A: (1875, 7) (1876, 0) (1876, 1) 12 (1876, 2) (1876, 3) (1876, 4) (1876, 5) (1876, 6) B: (1876, 7) (1877, 0) (1877, 1) 12 (1877, 2) (1877, 3) (1877, 4) (1877, 5) (1877, 6) User specified directory (1877, 7) (1878, 0) (1878, 1) 1 (1878, 2) 60 (1878, 3) 207 (1878, 4) 108 (1878, 5) (1878, 6) OK (1878, 7) (1879, 0) (1879, 1) 2 (1879, 2) 230 (1879, 3) 206 (1879, 4) 88 (1879, 5) (1879, 6) Cancel (1879, 7) (1880, 0) (1880, 1) 5 (1880, 2) 25 (1880, 3) 248 (1880, 4) (1880, 5) (1880, 6) * If this option selected, place the cell pointer (1880, 7) (1881, 0) (1881, 1) 5 (1881, 2) 25 (1881, 3) 266 (1881, 4) (1881, 5) (1881, 6) in the destination directory and double click (1881, 7) (1882, 0) (1882, 1) 5 (1882, 2) 25 (1882, 3) 284 (1882, 4) (1882, 5) (1882, 6) the mouse or press enter. (1882, 7) (1883, 0) (1883, 1) (1883, 2) (1884, 0) (1884, 1) MultiDest (1884, 2) (1885, 0) (1885, 1) (1885, 2) (1885, 3) (1885, 4) 388 (1885, 5) 250 (1885, 6) (1885, 7) (1886, 0) (1886, 1) 5 (1886, 2) 10 (1886, 3) 6 (1886, 4) (1886, 5) (1886, 6) 3 files have been selected to be copied (1886, 7) (1886, 8) MultiHeader (1887, 0) (1887, 1) 5 (1887, 2) 49 (1887, 3) 13 (1887, 4) (1887, 5) (1887, 6) (1887, 7) (1888, 0) (1888, 1) 5 (1888, 2) 10 (1888, 3) 33 (1888, 4) (1888, 5) (1888, 6) Please select the destination: (1888, 7) (1889, 0) (1889, 1) 14 (1889, 2) 19 (1889, 3) 50 (1889, 4) 351 (1889, 5) 85 (1889, 6) (1889, 7) (1890, 0) (1890, 1) 11 (1890, 2) (1890, 3) (1890, 4) (1890, 5) (1890, 6) (1890, 7) 1 (1891, 0) (1891, 1) 12 (1891, 2) (1891, 3) (1891, 4) (1891, 5) (1891, 6) To a directory listed in the spreadsheet * (1891, 7) (1892, 0) (1892, 1) 12 (1892, 2) (1892, 3) (1892, 4) (1892, 5) (1892, 6) A: (1892, 7) (1893, 0) (1893, 1) 12 (1893, 2) (1893, 3) (1893, 4) (1893, 5) (1893, 6) B: (1893, 7) (1894, 0) (1894, 1) 12 (1894, 2) (1894, 3) (1894, 4) (1894, 5) (1894, 6) User specified directory (1894, 7) (1895, 0) (1895, 1) 1 (1895, 2) 60 (1895, 3) 155 (1895, 4) 108 (1895, 5) (1895, 6) OK (1895, 7) (1896, 0) (1896, 1) 2 (1896, 2) 230 (1896, 3) 154 (1896, 4) 88 (1896, 5) (1896, 6) Cancel (1896, 7) (1897, 0) (1897, 1) 5 (1897, 2) 25 (1897, 3) 196 (1897, 4) (1897, 5) (1897, 6) * If this option selected, place the cell pointer (1897, 7) (1898, 0) (1898, 1) 5 (1898, 2) 25 (1898, 3) 214 (1898, 4) (1898, 5) (1898, 6) in the destination directory and double click (1898, 7) (1899, 0) (1899, 1) 5 (1899, 2) 25 (1899, 3) 232 (1899, 4) (1899, 5) (1899, 6) the mouse or press enter. (1899, 7) (1900, 0) (1900, 1) (1900, 2) (1901, 0) (1901, 1) UserSpecifiedDest (1901, 2) (1902, 0) (1902, 1) (1902, 2) (1902, 3) (1902, 4) 520 (1902, 5) 144 (1902, 6) (1902, 7) 3 (1903, 0) (1903, 1) 5 (1903, 2) 9 (1903, 3) 6 (1903, 4) (1903, 5) (1903, 6) Please enter the full path and name of the destination directory (1903, 7) (1904, 0) (1904, 1) 5 (1904, 2) 10 (1904, 3) 24 (1904, 4) (1904, 5) (1904, 6) for the selected file. (Example: C:\EXCEL\INACTIVE) (1904, 7) (1905, 0) (1905, 1) 6 (1905, 2) 16 (1905, 3) 62 (1905, 4) 467 (1905, 5) (1905, 6) (1905, 7) (1905, 8) UserDest (1906, 0) (1906, 1) 1 (1906, 2) 111 (1906, 3) 99 (1906, 4) 88 (1906, 5) (1906, 6) OK (1906, 7) (1907, 0) (1907, 1) 2 (1907, 2) 270 (1907, 3) 99 (1907, 4) 88 (1907, 5) (1907, 6) Cancel (1907, 7) (1908, 0) (1908, 1) (1908, 2) (1909, 0) (1909, 1) ConfirmCopyMove (1909, 2) (1910, 0) (1910, 1) (1910, 2) (1910, 3) (1910, 4) 434 (1910, 5) 175 (1910, 6) (1910, 7) (1911, 0) (1911, 1) 5 (1911, 2) 10 (1911, 3) 6 (1911, 4) (1911, 5) (1911, 6) Please confirm your request to COPY (1911, 7) (1912, 0) (1912, 1) 5 (1912, 2) 80 (1912, 3) 31 (1912, 4) (1912, 5) (1912, 6) TTTT.XLS (1912, 7) (1913, 0) (1913, 1) 5 (1913, 2) 80 (1913, 3) 49 (1913, 4) (1913, 5) (1913, 6) C:\XLSFILES (1913, 7) (1914, 0) (1914, 1) 5 (1914, 2) 80 (1914, 3) 67 (1914, 4) (1914, 5) (1914, 6) dfsfasfsffsf (1914, 7) (1915, 0) (1915, 1) 5 (1915, 2) 10 (1915, 3) 86 (1915, 4) (1915, 5) (1915, 6) TO: (1915, 7) (1916, 0) (1916, 1) 5 (1916, 2) 80 (1916, 3) 107 (1916, 4) (1916, 5) (1916, 6) C:\XXX (1916, 7) (1917, 0) (1917, 1) 1 (1917, 2) 84 (1917, 3) 142 (1917, 4) 88 (1917, 5) (1917, 6) OK (1917, 7) (1918, 0) (1918, 1) 2 (1918, 2) 250 (1918, 3) 142 (1918, 4) 88 (1918, 5) (1918, 6) Cancel (1918, 7) (1919, 0) (1919, 1) (1919, 2) (1919, 6) (1920, 0) (1920, 1) GetFileInfo (1920, 2) (1920, 6) (1921, 0) (1921, 1) #N/A! (1921, 2) (1922, 0) (1922, 1) #N/A! (1922, 2) confirm file selected (1923, 0) (1923, 1) TRUE (1923, 2) store name of file (1924, 0) (1924, 1) TRUE (1924, 2) (1925, 0) (1925, 1) TRUE (1925, 2) (1926, 0) (1926, 1) TRUE (1926, 2) store documentation (1927, 0) (1927, 1) TRUE (1927, 2) (1928, 0) (1928, 1) FALSE (1928, 2) (1929, 0) (1929, 1) #N/A! (1929, 2) execute routine to get directory name (1930, 0) (1930, 1) TRUE (1930, 2) store directory name (1931, 0) (1931, 1) TRUE (1931, 2) (1932, 0) (1932, 1) #N/A! (1932, 2) (1933, 0) (1933, 1) TRUE (1933, 2) (1934, 0) (1934, 1) TRUE (1934, 2) (1935, 0) (1935, 1) TRUE (1935, 2) (1936, 0) (1936, 1) TRUE (1936, 2) (1937, 0) (1937, 1) TRUE (1937, 2) (1938, 0) (1938, 1) TRUE (1938, 2) (1939, 0) (1939, 1) FALSE (1939, 2) (1940, 0) (1940, 1) TRUE (1940, 2) (1941, 0) (1941, 1) FALSE (1941, 2) (1942, 0) (1942, 1) TRUE (1942, 2) (1943, 0) (1943, 1) (1943, 2) (1944, 0) (1944, 1) CopyMoveMacro (1944, 2) (1945, 0) (1945, 1) TRUE (1945, 2) (1946, 0) (1946, 1) #N/A! (1946, 2) (1947, 0) (1947, 1) TRUE (1947, 2) (1948, 0) (1948, 1) TRUE (1948, 2) (1949, 0) (1949, 1) TRUE (1949, 2) (1950, 0) (1950, 1) TRUE (1950, 2) (1951, 0) (1951, 1) TRUE (1951, 2) (1952, 0) (1952, 1) TRUE (1952, 2) (1953, 0) (1953, 1) TRUE (1953, 2) (1954, 0) (1954, 1) TRUE (1954, 2) (1955, 0) (1955, 1) 10 (1955, 2) (1956, 0) (1956, 1) FALSE (1956, 2) (1957, 0) (1957, 1) TRUE (1957, 2) (1958, 0) (1958, 1) 12 (1958, 2) (1959, 0) (1959, 1) FALSE (1959, 2) (1960, 0) (1960, 1) TRUE (1960, 2) (1961, 0) (1961, 1) FALSE (1961, 2) (1962, 0) (1962, 1) (1962, 2) (1963, 0) (1963, 1) TRUE (1963, 2) (1964, 0) (1964, 1) TRUE (1964, 2) put message on screen (1965, 0) (1965, 1) TRUE (1965, 2) redefine enter key (1966, 0) (1966, 1) TRUE (1966, 2) (1967, 0) (1967, 1) TRUE (1967, 2) (1968, 0) (1968, 1) TRUE (1968, 2) (1969, 0) (1969, 1) TRUE (1969, 2) (1970, 0) (1970, 1) TRUE (1970, 2) (1971, 0) (1971, 1) TRUE (1971, 2) (1972, 0) (1972, 1) TRUE (1972, 2) (1973, 0) (1973, 1) TRUE (1973, 2) (1974, 0) (1974, 1) FALSE (1974, 2) (1975, 0) (1975, 1) TRUE (1975, 2) (1976, 0) (1976, 1) TRUE (1976, 2) (1977, 0) (1977, 1) FALSE (1977, 2) (1978, 0) (1978, 1) FALSE (1978, 2) (1979, 0) (1979, 1) TRUE (1979, 2) (1980, 0) (1980, 1) (1980, 2) (1981, 0) (1981, 1) CopyContinue (1981, 2) (1982, 0) (1982, 1) TRUE (1982, 2) FORMULA.GOTO(CALLER()) (1983, 0) (1983, 1) TRUE (1983, 2) (1984, 0) (1984, 1) TRUE (1984, 2) reset key (1985, 0) (1985, 1) TRUE (1985, 2) (1986, 0) (1986, 1) TRUE (1986, 2) (1987, 0) (1987, 1) TRUE (1987, 2) (1988, 0) (1988, 1) TRUE (1988, 2) clear msg (1989, 0) (1989, 1) TRUE (1989, 2) (1990, 0) (1990, 1) TRUE (1990, 2) confirm directory selected (1991, 0) (1991, 1) TRUE (1991, 2) (1992, 0) (1992, 1) TRUE (1992, 2) (1993, 0) (1993, 1) TRUE (1993, 2) (1994, 0) (1994, 1) FALSE (1994, 2) (1995, 0) (1995, 1) #N/A! (1995, 2) get directory name (1996, 0) (1996, 1) TRUE (1996, 2) (1997, 0) (1997, 1) TRUE (1997, 2) (1998, 0) (1998, 1) (1998, 2) (1999, 1) TRUE (1999, 2) (2000, 1) TRUE (2000, 2) (2001, 1) TRUE (2001, 2) (2002, 1) TRUE (2002, 2) (2003, 1) TRUE (2003, 2) (2004, 1) TRUE (2004, 2) (2005, 1) TRUE (2005, 2) (2006, 1) TRUE (2006, 2) (2007, 1) TRUE (2007, 2) (2008, 1) TRUE (2008, 2) (2009, 1) TRUE (2009, 2) (2010, 1) (2010, 2) (2011, 1) 7 (2011, 2) (2012, 1) #N/A! (2012, 2) (2013, 1) FALSE (2013, 2) (2014, 1) (2014, 2) (2015, 1) MultiContinue (2015, 2) (2016, 1) TRUE (2016, 2) (2017, 1) TRUE (2017, 2) (2018, 1) #N/A! (2018, 2) (2019, 1) TRUE (2019, 2) (2020, 1) TRUE (2020, 2) (2021, 1) TRUE (2021, 2) (2022, 1) TRUE (2022, 2) (2023, 1) TRUE (2023, 2) confirm file exists (2024, 1) FALSE (2024, 2) (2025, 1) TRUE (2025, 2) (2026, 1) FALSE (2026, 2) (2027, 1) (2027, 2) (2028, 0) (2028, 1) #N/A! (2028, 2) get filename (2029, 0) (2029, 1) #N/A! (2029, 2) get filetype (2030, 0) (2030, 1) (2030, 2) (2031, 0) (2031, 1) TRUE (2031, 2) remove alldone.mgr flag file if it exists (2032, 0) (2032, 1) #VALUE! (2032, 2) (2033, 0) (2033, 1) #VALUE! (2033, 2) (2034, 0) (2034, 1) (2034, 2) (2035, 0) (2035, 1) TRUE (2035, 2) Remove report file if it exists (2036, 0) (2036, 1) TRUE (2036, 2) (2037, 0) (2037, 1) TRUE (2037, 2) (2038, 0) (2038, 1) (2038, 2) (2039, 0) (2039, 1) TRUE (2039, 2) construct exec command (2040, 0) (2040, 1) TRUE (2040, 2) (2041, 0) (2041, 1) TRUE (2041, 2) (2042, 0) (2042, 1) (2042, 2) (2043, 0) (2043, 1) TRUE (2043, 2) (2044, 0) (2044, 1) #N/A! (2044, 2) execute filectrl (2045, 0) (2045, 1) TRUE (2045, 2) (2046, 0) (2046, 1) TRUE (2046, 2) pause excel macro while exec executes (2047, 0) (2047, 1) TRUE (2047, 2) exit after 60 seconds (2048, 0) (2048, 1) TRUE (2048, 2) (2049, 0) (2049, 1) TRUE (2049, 2) (2050, 0) (2050, 1) TRUE (2050, 2) (2051, 0) (2051, 1) (2051, 2) (2052, 0) (2052, 1) TRUE (2052, 2) display box to further pause macro (2053, 0) (2053, 1) TRUE (2053, 2) (2054, 0) (2054, 1) FALSE (2054, 2) (2055, 0) (2055, 1) TRUE (2055, 2) (2056, 0) (2056, 1) (2056, 2) (2057, 0) (2057, 1) TRUE (2057, 2) (2058, 0) (2058, 1) TRUE (2058, 2) (2059, 0) (2059, 1) TRUE (2059, 2) (2060, 0) (2060, 1) (2060, 2) (2061, 0) (2061, 1) TRUE (2061, 2) (2062, 0) (2062, 1) (2062, 2) (2063, 0) (2063, 1) TRUE (2063, 2) (2064, 0) (2064, 1) TRUE (2064, 2) (2065, 0) (2065, 1) (2065, 2) (2066, 0) (2066, 1) TRUE (2066, 2) (2067, 0) (2067, 1) TRUE (2067, 2) (2068, 0) (2068, 1) TRUE (2068, 2) (2069, 0) (2069, 1) TRUE (2069, 2) go to first file in destination directory (2070, 0) (2070, 1) TRUE (2070, 2) names blank row as next command moves cursor (2071, 0) (2071, 1) TRUE (2071, 2) set up search range (2072, 0) (2072, 1) TRUE (2072, 2) (2073, 0) (2073, 1) TRUE (2073, 2) (2074, 0) (2074, 1) TRUE (2074, 2) (2075, 0) (2075, 1) FALSE (2075, 2) find file by same name if it exists and erase it (2076, 0) (2076, 1) TRUE (2076, 2) (2077, 0) (2077, 1) TRUE (2077, 2) (2078, 0) (2078, 1) TRUE (2078, 2) (2079, 0) (2079, 1) TRUE (2079, 2) (2080, 0) (2080, 1) TRUE (2080, 2) (2081, 0) (2081, 1) TRUE (2081, 2) (2082, 0) (2082, 1) (2082, 2) (2083, 0) (2083, 1) TRUE (2083, 2) insert a blank line (2084, 0) (2084, 1) #N/A! (2084, 2) (2085, 0) (2085, 1) TRUE (2085, 2) names blank row as next command moves cursor (2086, 0) (2086, 1) TRUE (2086, 2) select file info (2087, 0) (2087, 1) TRUE (2087, 2) copy to buffer (2088, 0) (2088, 1) TRUE (2088, 2) returns to blank cell (2089, 0) (2089, 1) TRUE (2089, 2) paste (2090, 0) (2090, 1) TRUE (2090, 2) (2091, 0) (2091, 1) TRUE (2091, 2) go to directory and label temp1 (2092, 0) (2092, 1) TRUE (2092, 2) (2093, 0) (2093, 1) SORTING DIRECTORY (2093, 2) (2094, 0) (2094, 1) TRUE (2094, 2) (2095, 0) (2095, 1) TRUE (2095, 2) (2096, 0) (2096, 1) TRUE (2096, 2) (2097, 0) (2097, 1) TRUE (2097, 2) (2098, 0) (2098, 1) TRUE (2098, 2) select rows in directory for sorting (2099, 0) (2099, 1) TRUE (2099, 2) (2100, 0) (2100, 1) TRUE (2100, 2) (2101, 0) (2101, 1) TRUE (2101, 2) (2102, 0) (2102, 1) TRUE (2102, 2) (2103, 0) (2103, 1) TRUE (2103, 2) (2104, 0) (2104, 1) TRUE (2104, 2) (2105, 0) (2105, 1) TRUE (2105, 2) (2106, 0) (2106, 1) TRUE (2106, 2) (2107, 0) (2107, 1) TRUE (2107, 2) (2108, 0) (2108, 1) (2108, 2) (2109, 0) (2109, 1) TRUE (2109, 2) (2110, 0) (2110, 1) TRUE (2110, 2) puts on original file row (2111, 0) (2111, 1) TRUE (2111, 2) (2112, 0) (2112, 1) TRUE (2112, 2) (2113, 0) (2113, 1) TRUE (2113, 2) (2114, 0) (2114, 1) (2114, 2) (2115, 0) (2115, 1) TRUE (2115, 2) (2116, 0) (2116, 1) 7 (2116, 2) (2117, 0) (2117, 1) TRUE (2117, 2) (2118, 0) (2118, 1) TRUE (2118, 2) (2119, 0) (2119, 1) TRUE (2119, 2) (2120, 0) (2120, 1) TRUE (2120, 2) (2121, 0) (2121, 1) TRUE (2121, 2) (2122, 0) (2122, 1) TRUE (2122, 2) (2123, 0) (2123, 1) TRUE (2123, 2) (2124, 0) (2124, 1) TRUE (2124, 2) (2125, 0) (2125, 1) TRUE (2125, 2) (2126, 0) (2126, 1) TRUE (2126, 2) (2127, 0) (2127, 1) TRUE (2127, 2) (2128, 0) (2128, 1) (2128, 2) (2129, 0) (2129, 1) TRUE (2129, 2) (2130, 0) (2130, 1) TRUE (2130, 2) (2131, 0) (2131, 1) TRUE (2131, 2) (2132, 0) (2132, 1) FALSE (2132, 2) (2133, 0) (2133, 1) (2133, 2) (2134, 0) (2134, 1) TRUE (2134, 2) end of copy ok (2135, 0) (2135, 1) TRUE (2135, 2) (2136, 0) (2136, 1) TRUE (2136, 2) (2137, 0) (2137, 1) TRUE (2137, 2) (2138, 0) (2138, 1) (2138, 2) (2139, 0) (2139, 1) ReturnBox (2139, 2) (2140, 0) (2140, 1) (2140, 2) (2140, 3) (2140, 4) 412 (2140, 5) 144 (2140, 6) (2140, 7) (2141, 0) (2141, 1) 5 (2141, 2) 38 (2141, 3) 6 (2141, 4) (2141, 5) (2141, 6) (2141, 7) (2142, 0) (2142, 1) 5 (2142, 2) 68 (2142, 3) 31 (2142, 4) (2142, 5) (2142, 6) Please choose one of the following: (2142, 7) (2143, 0) (2143, 1) 14 (2143, 2) 66 (2143, 3) 49 (2143, 4) 277 (2143, 5) 51 (2143, 6) (2143, 7) (2144, 0) (2144, 1) 11 (2144, 2) (2144, 3) (2144, 4) (2144, 5) (2144, 6) (2144, 7) 1 (2144, 8) ReturnOption (2145, 0) (2145, 1) 12 (2145, 2) (2145, 3) (2145, 4) (2145, 5) (2145, 6) Return To Source Directory (2145, 7) (2146, 0) (2146, 1) 12 (2146, 2) (2146, 3) (2146, 4) (2146, 5) (2146, 6) Stay at Destination Directory (2146, 7) (2147, 0) (2147, 1) 1 (2147, 2) 157 (2147, 3) 111 (2147, 4) 88 (2147, 5) (2147, 6) OK (2147, 7) (2148, 0) (2148, 1) 5 (2148, 2) 9 (2148, 3) 12 (2148, 4) (2148, 5) (2148, 6) Selected activity has been successfully completed. (2148, 7) (2149, 0) (2149, 1) (2149, 2) (2150, 0) DestFileName (2150, 1) C:\ACTIVE\ESTIMATE\AAA.WK3 (2150, 2) (2151, 0) (2151, 1) (2151, 2) (2152, 0) (2152, 1) Verify_choice (2152, 2) (2153, 0) (2153, 1) TRUE (2153, 2) move to column 2 (2154, 0) (2154, 1) TRUE (2154, 2) If the cursor is not on a file, stop (2155, 0) (2155, 1) TRUE (2155, 2) (2156, 0) (2156, 1) TRUE (2156, 2) (2157, 0) (2157, 1) FALSE (2157, 2) (2158, 0) (2158, 1) TRUE (2158, 2) (2159, 0) (2159, 1) (2159, 2) (2160, 0) (2160, 1) DestDirectory (2160, 2) (2161, 0) (2161, 1) C:\XXX (2161, 2) (2162, 0) (2162, 1) (2162, 2) (2163, 1) StopMacro (2163, 2) (2164, 0) (2164, 1) TRUE (2164, 2) (2165, 0) (2165, 1) TRUE (2165, 2) (2166, 0) (2166, 1) TRUE (2166, 2) (2167, 0) (2167, 1) TRUE (2167, 2) (2168, 0) (2168, 1) TRUE (2168, 2) (2169, 0) (2169, 1) TRUE (2169, 2) (2170, 0) (2170, 1) TRUE (2170, 2) (2171, 0) (2171, 1) TRUE (2171, 2) (2172, 0) (2172, 1) (2172, 2) (2173, 0) (2173, 1) (2173, 2) (2174, 0) (2174, 1) DeleteFileMenu (2174, 2) (2175, 0) (2175, 1) (2175, 2) (2175, 3) (2175, 4) 521 (2175, 5) 154 (2175, 6) (2175, 7) (2176, 0) (2176, 1) 1 (2176, 2) 21 (2176, 3) 119 (2176, 4) 202 (2176, 5) (2176, 6) Erase the file from Disk (2176, 7) (2177, 0) (2177, 1) 2 (2177, 2) 274 (2177, 3) 119 (2177, 4) 180 (2177, 5) (2177, 6) Do not erase the file (2177, 7) (2178, 0) (2178, 1) 5 (2178, 2) 18 (2178, 3) 6 (2178, 4) (2178, 5) (2178, 6) THE FOLLOWING FILE HAS BEEN SELECTED: (2178, 7) (2179, 0) (2179, 1) 5 (2179, 2) 10 (2179, 3) 38 (2179, 4) (2179, 5) (2179, 6) File: (2179, 7) (2180, 0) (2180, 1) 5 (2180, 2) 10 (2180, 3) 65 (2180, 4) (2180, 5) (2180, 6) Directory: (2180, 7) (2181, 0) (2181, 1) 5 (2181, 2) 10 (2181, 3) 87 (2181, 4) (2181, 5) (2181, 6) Description: (2181, 7) (2182, 0) (2182, 1) 5 (2182, 2) 122 (2182, 3) 38 (2182, 4) (2182, 5) (2182, 6) BBB.XLS (2182, 7) (2182, 8) DeleteFile (2183, 0) (2183, 1) 5 (2183, 2) 122 (2183, 3) 65 (2183, 4) (2183, 5) (2183, 6) C:\XLSFILES\TEST (2183, 7) (2183, 8) DeleteFileDir (2184, 0) (2184, 1) 5 (2184, 2) 122 (2184, 3) 87 (2184, 4) (2184, 5) (2184, 6) (2184, 7) (2184, 8) DeleteFileDoc (2185, 0) (2185, 1) (2185, 2) (2186, 0) (2186, 1) (2186, 2) (2186, 6) (2187, 0) (2187, 1) EraseAFile (2187, 2) (2188, 0) (2188, 1) TRUE (2188, 2) (2189, 0) (2189, 1) #N/A! (2189, 2) (2190, 0) (2190, 1) #N/A! (2190, 2) Make sure file is picked out (2191, 0) (2191, 1) TRUE (2191, 2) mark location (2192, 0) (2192, 1) TRUE (2192, 2) store filename (2193, 0) (2193, 1) TRUE (2193, 2) (2194, 0) (2194, 1) TRUE (2194, 2) store documentation (2195, 0) (2195, 1) FALSE (2195, 2) (2196, 0) (2196, 1) #N/A! (2196, 2) (2197, 0) (2197, 1) TRUE (2197, 2) store directory (2198, 0) (2198, 1) #N/A! (2198, 2) (2199, 0) (2199, 1) TRUE (2199, 2) return to filename (2200, 0) (2200, 1) TRUE (2200, 2) (2201, 0) (2201, 1) TRUE (2201, 2) (2202, 0) (2202, 1) TRUE (2202, 2) (2203, 0) (2203, 1) 1 (2203, 2) display box (2204, 0) (2204, 1) FALSE (2204, 2) (2205, 0) (2205, 1) TRUE (2205, 2) (2206, 0) (2206, 1) TRUE (2206, 2) (2207, 0) (2207, 1) TRUE (2207, 2) (2208, 0) (2208, 1) 2 (2208, 2) (2209, 0) (2209, 1) FALSE (2209, 2) (2210, 0) (2210, 1) TRUE (2210, 2) (2211, 0) (2211, 1) TRUE (2211, 2) (2212, 0) (2212, 1) FALSE (2212, 2) delete row if file doesn't exist (2213, 0) (2213, 1) FALSE (2213, 2) (2214, 0) (2214, 1) TRUE (2214, 2) (2215, 0) (2215, 1) FALSE (2215, 2) (2216, 0) (2216, 1) TRUE (2216, 2) delete file if it exists (2217, 0) (2217, 1) TRUE (2217, 2) delete file row (2218, 0) (2218, 1) TRUE (2218, 2) (2219, 0) (2219, 1) TRUE (2219, 2) (2220, 0) (2220, 1) (2220, 2) (2221, 0) (2221, 1) MultiDeleteBox (2221, 2) (2222, 0) (2222, 1) (2222, 2) (2222, 3) (2222, 4) 424 (2222, 5) 144 (2222, 6) (2222, 7) (2223, 0) (2223, 1) 5 (2223, 2) 46 (2223, 3) 18 (2223, 4) (2223, 5) (2223, 6) 2 files have been selected to be erased. (2223, 7) (2223, 8) MultiDeleteText (2224, 0) (2224, 1) 1 (2224, 2) 101 (2224, 3) 51 (2224, 4) 211 (2224, 5) (2224, 6) OK - ERASE ALL FILES (2224, 7) (2225, 0) (2225, 1) 2 (2225, 2) 54 (2225, 3) 94 (2225, 4) 305 (2225, 5) (2225, 6) Cancel - DO NOT ERASE ANY FILES (2225, 7) (2226, 0) (2226, 1) (2226, 2) (2227, 0) (2227, 1) (2227, 2) (2228, 0) (2228, 1) ExtractName (2228, 2) (2229, 0) (2229, 1) TRUE (2229, 2) (2230, 0) (2230, 1) TRUE (2230, 2) (2231, 0) (2231, 1) TRUE (2231, 2) (2232, 0) (2232, 1) TRUE (2232, 2) (2233, 0) (2233, 1) #VALUE! (2233, 2) (2234, 0) (2234, 1) TRUE (2234, 2) (2235, 0) (2235, 1) #VALUE! (2235, 2) (2236, 0) (2236, 1) TRUE (2236, 2) (2237, 0) (2237, 1) #VALUE! (2237, 2) (2238, 0) (2238, 1) TRUE (2238, 2) (2239, 0) (2239, 1) (2239, 2) (2240, 0) (2240, 1) ExtractType (2240, 2) (2241, 0) (2241, 1) TRUE (2241, 2) (2242, 0) (2242, 1) TRUE (2242, 2) (2243, 0) (2243, 1) TRUE (2243, 2) (2244, 0) (2244, 1) TRUE (2244, 2) (2245, 0) (2245, 1) #VALUE! (2245, 2) (2246, 0) (2246, 1) TRUE (2246, 2) (2247, 0) (2247, 1) #VALUE! (2247, 2) (2248, 0) (2248, 1) TRUE (2248, 2) (2249, 0) (2249, 1) #VALUE! (2249, 2) (2250, 0) (2250, 1) TRUE (2250, 2) (2251, 0) (2251, 1) (2251, 2) (2252, 0) (2252, 1) (2252, 2) (2253, 0) (2253, 1) GotoDirName (2253, 2) This routine called to go to the directory cell (2253, 6) (2254, 0) (2254, 1) TRUE (2254, 2) goes to column 2 and up one row (2255, 0) (2255, 1) TRUE (2255, 2) if not blank, to to top of list (2256, 0) (2256, 1) TRUE (2256, 2) (2257, 0) (2257, 1) TRUE (2257, 2) (2258, 0) (2258, 1) TRUE (2258, 2) (2259, 0) (2259, 1) TRUE (2259, 2) if blank, go down 1 (2260, 0) (2260, 1) TRUE (2260, 2) (2261, 0) (2261, 1) TRUE (2261, 2) (2262, 0) (2262, 1) TRUE (2262, 2) (2263, 0) (2263, 1) TRUE (2263, 2) (2264, 0) (2264, 1) (2264, 2) (2265, 0) (2265, 1) CREATEAFILE (2265, 2) Creates a new file (2266, 0) (2266, 1) TRUE (2266, 2) (2267, 0) (2267, 1) TRUE (2267, 2) (2268, 0) (2268, 1) TRUE (2268, 2) (2269, 0) (2269, 1) TRUE (2269, 2) (2270, 0) (2270, 1) TRUE (2270, 2) (2271, 0) (2271, 1) FALSE (2271, 2) (2272, 0) (2272, 1) #N/A! (2272, 2) (2273, 0) (2273, 1) #N/A! (2273, 2) (2274, 0) (2274, 1) TRUE (2274, 2) (2275, 0) (2275, 1) TRUE (2275, 2) (2276, 0) (2276, 1) TRUE (2276, 2) (2277, 0) (2277, 1) TRUE (2277, 2) (2278, 0) (2278, 1) FALSE (2278, 2) (2279, 0) (2279, 1) TRUE (2279, 2) Clears new name (2280, 0) (2280, 1) TRUE (2280, 2) sets default selection to a spreadsheet (2281, 0) (2281, 1) TRUE (2281, 2) (2282, 0) (2282, 1) #N/A! (2282, 2) goto directory name (2283, 0) (2283, 1) TRUE (2283, 2) store directory name in box (2284, 0) (2284, 1) #N/A! (2284, 2) (2285, 0) (2285, 1) TRUE (2285, 2) clears new name (2286, 0) (2286, 1) 7 (2286, 2) presents box to get filename (2287, 0) (2287, 1) FALSE (2287, 2) stop if no selection (2288, 0) (2288, 1) TRUE (2288, 2) (2289, 0) (2289, 1) TRUE (2289, 2) stop if no name given (2290, 0) (2290, 1) TRUE (2290, 2) (2291, 0) (2291, 1) TRUE (2291, 2) (2292, 0) (2292, 1) TRUE (2292, 2) remove blanks, convert to upper case (2293, 0) (2293, 1) (2293, 2) (2294, 0) (2294, 1) TRUE (2294, 2) (2295, 0) (2295, 1) FALSE (2295, 2) (2296, 0) (2296, 1) TRUE (2296, 2) (2297, 0) (2297, 1) TRUE (2297, 2) (2298, 0) (2298, 1) TRUE (2298, 2) (2299, 0) (2299, 1) TRUE (2299, 2) (2300, 0) (2300, 1) TRUE (2300, 2) (2301, 0) (2301, 1) FALSE (2301, 2) (2302, 0) (2302, 1) TRUE (2302, 2) (2303, 0) (2303, 1) (2303, 2) (2304, 0) (2304, 1) TRUE (2304, 2) (2305, 0) (2305, 1) TRUE (2305, 2) stop if >8 characters (2306, 0) (2306, 1) TRUE (2306, 2) (2307, 0) (2307, 1) TRUE (2307, 2) (2308, 0) (2308, 1) TRUE (2308, 2) (2309, 0) (2309, 1) TRUE (2309, 2) creates full name and type if spreadsheet (2310, 0) (2310, 1) (2310, 2) (2311, 0) (2311, 1) TRUE (2311, 2) (2312, 0) (2312, 1) TRUE (2312, 2) (2313, 0) (2313, 1) TRUE (2313, 2) creates full name and type if macrosheet (2314, 0) (2314, 1) TRUE (2314, 2) (2315, 0) (2315, 1) TRUE (2315, 2) (2316, 0) (2316, 1) TRUE (2316, 2) creates full name and type if chart (2317, 0) (2317, 1) TRUE (2317, 2) (2318, 0) (2318, 1) TRUE (2318, 2) (2319, 0) (2319, 1) TRUE (2319, 2) (2320, 0) (2320, 1) TRUE (2320, 2) (2321, 0) (2321, 1) TRUE (2321, 2) (2322, 0) (2322, 1) TRUE (2322, 2) (2323, 0) (2323, 1) (2323, 2) (2324, 0) (2324, 1) TRUE (2324, 2) Check and see if new file exists. (2325, 0) (2325, 1) TRUE (2325, 2) (2326, 0) (2326, 1) TRUE (2326, 2) (2327, 0) (2327, 1) TRUE (2327, 2) (2328, 0) (2328, 1) TRUE (2328, 2) create new file (2329, 0) (2329, 1) TRUE (2329, 2) (2330, 0) (2330, 1) TRUE (2330, 2) (2331, 0) (2331, 1) TRUE (2331, 2) (2332, 0) (2332, 1) TRUE (2332, 2) (2333, 0) (2333, 1) TRUE (2333, 2) (2334, 0) (2334, 1) TRUE (2334, 2) (2335, 0) (2335, 1) TRUE (2335, 2) (2336, 0) (2336, 1) (2336, 2) (2337, 0) (2337, 1) TRUE (2337, 2) (2338, 0) (2338, 1) TRUE (2338, 2) go down one row (2339, 1) TRUE (2339, 2) insert a row (2340, 0) (2340, 1) #N/A! (2340, 2) (2341, 0) (2341, 1) TRUE (2341, 2) insert new name (2342, 0) (2342, 1) TRUE (2342, 2) (2343, 0) (2343, 1) FALSE (2343, 2) insert documentation (2344, 0) (2344, 1) TRUE (2344, 2) insert date and time (2345, 0) (2345, 1) TRUE (2345, 2) (2346, 0) (2346, 1) TRUE (2346, 2) (2347, 0) (2347, 1) TRUE (2347, 2) (2348, 0) (2348, 1) TRUE (2348, 2) (2349, 0) (2349, 1) TRUE (2349, 2) (2350, 0) (2350, 1) TRUE (2350, 2) (2351, 0) (2351, 1) (2351, 2) (2352, 0) (2352, 1) TRUE (2352, 2) Select corners for sorting (2353, 0) (2353, 1) TRUE (2353, 2) (2354, 0) (2354, 1) TRUE (2354, 2) move to directory name (2355, 0) (2355, 1) TRUE (2355, 2) move to last file (2356, 0) (2356, 1) TRUE (2356, 2) move to documentation (2357, 0) (2357, 1) TRUE (2357, 2) (2358, 0) (2358, 1) TRUE (2358, 2) (2359, 0) (2359, 1) TRUE (2359, 2) sort new data (2360, 0) (2360, 1) FORMULA.GOTO("r1c") (2360, 2) (2361, 0) (2361, 1) TRUE (2361, 2) (2362, 0) (2362, 1) TRUE (2362, 2) (2363, 0) (2363, 1) TRUE (2363, 2) (2364, 0) (2364, 1) TRUE (2364, 2) (2365, 0) (2365, 1) TRUE (2365, 2) (2366, 0) (2366, 1) TRUE (2366, 2) go to new file (2367, 0) (2367, 1) (2367, 2) (2368, 0) (2368, 1) TRUE (2368, 2) (2369, 0) (2369, 1) (2369, 2) (2370, 0) (2370, 1) NewFileError (2370, 2) (2371, 0) (2371, 1) TRUE (2371, 2) (2372, 0) (2372, 1) TRUE (2372, 2) (2373, 0) (2373, 1) FALSE (2373, 2) (2374, 0) (2374, 1) TRUE (2374, 2) (2375, 0) (2375, 1) TRUE (2375, 2) (2376, 0) (2376, 1) (2376, 2) (2377, 0) (2377, 1) (2377, 2) (2378, 1) NEWFILEMENU (2378, 2) (2379, 0) NewFileMenu (2379, 1) (2379, 2) (2379, 3) (2379, 4) 512 (2379, 5) 275 (2379, 6) (2379, 7) 13 (2380, 0) (2380, 1) 14 (2380, 2) 357 (2380, 3) 30 (2380, 4) 144 (2380, 5) 85 (2380, 6) Filetype (2380, 7) (2381, 0) (2381, 1) 11 (2381, 2) (2381, 3) (2381, 4) (2381, 5) (2381, 6) (2381, 7) 1 (2381, 8) newfileoption (2382, 0) (2382, 1) 12 (2382, 2) (2382, 3) (2382, 4) (2382, 5) (2382, 6) Worksheet (2382, 7) (2383, 0) (2383, 1) 12 (2383, 2) (2383, 3) (2383, 4) (2383, 5) (2383, 6) Graph (2383, 7) (2384, 0) (2384, 1) 12 (2384, 2) (2384, 3) (2384, 4) (2384, 5) (2384, 6) Macrosheet (2384, 7) (2385, 0) (2385, 1) 12 (2385, 2) (2385, 3) (2385, 4) (2385, 5) (2385, 6) WorkBook (2385, 7) (2386, 0) (2386, 1) 1 (2386, 2) 144 (2386, 3) 248 (2386, 4) 88 (2386, 5) (2386, 6) OK (2386, 7) (2387, 0) (2387, 1) 2 (2387, 2) 322 (2387, 3) 247 (2387, 4) 88 (2387, 5) (2387, 6) Cancel (2387, 7) (2388, 0) (2388, 1) 5 (2388, 2) 141 (2388, 3) 6 (2388, 4) (2388, 5) (2388, 6) ***** CREATE A NEW FILE *** (2388, 7) (2389, 0) (2389, 1) 5 (2389, 2) 20 (2389, 3) 46 (2389, 4) (2389, 5) (2389, 6) DIRECTORY: (2389, 7) (2389, 8) newfiledir (2390, 0) (2390, 1) 5 (2390, 2) 20 (2390, 3) 64 (2390, 4) (2390, 5) (2390, 6) C:\XLSFILES (2390, 7) (2391, 0) (2391, 1) 5 (2391, 2) 21 (2391, 3) 93 (2391, 4) (2391, 5) (2391, 6) New Filename: (2391, 7) (2392, 0) (2392, 1) 6 (2392, 2) 22 (2392, 3) 113 (2392, 4) 160 (2392, 5) (2392, 6) (2392, 7) AAA.XLS (2392, 8) newfilename (2393, 0) (2393, 1) 5 (2393, 2) 10 (2393, 3) 187 (2393, 4) (2393, 5) (2393, 6) File Documentation: (2393, 7) (2394, 0) (2394, 1) 6 (2394, 2) 10 (2394, 3) 202 (2394, 4) 488 (2394, 5) (2394, 6) (2394, 7) (2394, 8) newfiledoc (2395, 0) (2395, 1) 14 (2395, 2) 352 (2395, 3) 136 (2395, 4) 147 (2395, 5) 51 (2395, 6) Worksheet Type: (2395, 7) (2396, 0) (2396, 1) 11 (2396, 2) (2396, 3) (2396, 4) (2396, 5) (2396, 6) (2396, 7) 1 (2396, 8) NewFiletype (2397, 0) (2397, 1) 12 (2397, 2) (2397, 3) (2397, 4) (2397, 5) (2397, 6) Normal (2397, 7) (2398, 0) (2398, 1) 12 (2398, 2) (2398, 3) (2398, 4) (2398, 5) (2398, 6) Excel 3 (2398, 7) (2399, 0) (2399, 1) (2399, 2) (2399, 3) (2399, 4) (2399, 5) (2399, 6) (2399, 7) (2400, 0) (2400, 1) (2400, 2) (2400, 3) (2400, 4) (2400, 5) (2400, 6) (2400, 7) (2401, 0) (2401, 1) NewSectionBox (2401, 2) (2401, 3) (2401, 4) (2401, 5) (2401, 6) (2401, 7) (2402, 0) (2402, 1) (2402, 2) (2402, 3) (2402, 4) 388 (2402, 5) 257 (2402, 6) (2402, 7) 3 (2403, 0) (2403, 1) 5 (2403, 2) 74 (2403, 3) 6 (2403, 4) (2403, 5) (2403, 6) N E W S E C T I O N D A T A (2403, 7) (2404, 0) (2404, 1) 5 (2404, 2) 10 (2404, 3) 38 (2404, 4) (2404, 5) (2404, 6) Enter full path and directory name (2404, 7) (2405, 0) (2405, 1) 6 (2405, 2) 10 (2405, 3) 53 (2405, 4) 360 (2405, 5) (2405, 6) (2405, 7) C: (2405, 8) NewSectionDirectory (2406, 0) (2406, 1) 5 (2406, 2) 10 (2406, 3) 97 (2406, 4) (2406, 5) (2406, 6) Enter filetype (Ex: XL*) (2406, 7) (2407, 0) (2407, 1) 6 (2407, 2) 10 (2407, 3) 112 (2407, 4) 358 (2407, 5) (2407, 6) (2407, 7) XL* (2407, 8) NewSectionType (2408, 0) (2408, 1) 5 (2408, 2) 13 (2408, 3) 160 (2408, 4) (2408, 5) (2408, 6) Enter documentation (2408, 7) (2409, 0) (2409, 1) 6 (2409, 2) 13 (2409, 3) 175 (2409, 4) 364 (2409, 5) (2409, 6) (2409, 7) (2409, 8) NewSectionDoc (2410, 0) (2410, 1) 1 (2410, 2) 67 (2410, 3) 230 (2410, 4) 88 (2410, 5) (2410, 6) OK (2410, 7) (2411, 0) (2411, 1) 2 (2411, 2) 217 (2411, 3) 229 (2411, 4) 88 (2411, 5) (2411, 6) Cancel (2411, 7) (2412, 0) (2412, 1) (2412, 2) (2412, 3) (2412, 4) (2412, 5) (2412, 6) (2412, 7) (2413, 0) (2413, 1) (2413, 2) (2413, 3) (2413, 4) (2413, 5) (2413, 6) (2413, 7) (2414, 0) (2414, 1) (2414, 2) (2414, 3) (2414, 4) (2414, 5) (2414, 6) (2414, 7) (2415, 0) (2415, 1) (2415, 2) (2415, 3) (2415, 4) (2415, 5) (2415, 6) (2415, 7) (2416, 0) (2416, 1) (2416, 2) (2416, 3) (2416, 4) (2416, 5) (2416, 6) (2416, 7) (2417, 0) (2417, 1) (2417, 2) (2417, 3) (2417, 4) (2417, 5) (2417, 6) (2417, 7) (2418, 0) (2418, 1) SectionColorBox (2418, 2) (2418, 3) (2418, 4) (2418, 5) (2418, 6) (2418, 7) (2419, 0) (2419, 1) (2419, 2) (2419, 3) (2419, 4) 582 (2419, 5) 326 (2419, 6) (2419, 7) (2420, 0) (2420, 1) 5 (2420, 2) 11 (2420, 3) 6 (2420, 4) (2420, 5) (2420, 6) Please select the colors to be used for the text and foreground of (2420, 7) (2421, 0) (2421, 1) 5 (2421, 2) 11 (2421, 3) 24 (2421, 4) (2421, 5) (2421, 6) directory cells. This will highlight all directory rows in this section. If (2421, 7) (2422, 0) (2422, 1) 5 (2422, 2) 11 (2422, 3) 42 (2422, 4) (2422, 5) (2422, 6) you choose to not specify any of the below colors, you can use the Excel (2422, 7) (2423, 0) (2423, 1) 5 (2423, 2) 11 (2423, 3) 60 (2423, 4) (2423, 5) (2423, 6) formatting commands to add color later. (Whenever you run an update, (2423, 7) (2424, 0) (2424, 1) 5 (2424, 2) 10 (2424, 3) 79 (2424, 4) (2424, 5) (2424, 6) the latest color specified on the directory in the section head is used.) (2424, 7) (2425, 0) (2425, 1) 14 (2425, 2) 64 (2425, 3) 118 (2425, 4) 171 (2425, 5) 136 (2425, 6) Text (2425, 7) (2426, 0) (2426, 1) 11 (2426, 2) (2426, 3) (2426, 4) (2426, 5) (2426, 6) (2426, 7) 5 (2426, 8) TextOption (2427, 0) (2427, 1) 12 (2427, 2) (2427, 3) (2427, 4) (2427, 5) (2427, 6) Black (2427, 7) (2428, 0) (2428, 1) 12 (2428, 2) (2428, 3) (2428, 4) (2428, 5) (2428, 6) White (2428, 7) (2429, 0) (2429, 1) 12 (2429, 2) (2429, 3) (2429, 4) (2429, 5) (2429, 6) Red (2429, 7) (2430, 0) (2430, 1) 12 (2430, 2) (2430, 3) (2430, 4) (2430, 5) (2430, 6) Light Green (2430, 7) (2431, 0) (2431, 1) 12 (2431, 2) (2431, 3) (2431, 4) (2431, 5) (2431, 6) Dark Blue (2431, 7) (2432, 0) (2432, 1) 12 (2432, 2) (2432, 3) (2432, 4) (2432, 5) (2432, 6) Yellow (2432, 7) (2433, 0) (2433, 1) 12 (2433, 2) (2433, 3) (2433, 4) (2433, 5) (2433, 6) Magenta (2433, 7) (2434, 0) (2434, 1) 1 (2434, 2) 152 (2434, 3) 268 (2434, 4) 233 (2434, 5) (2434, 6) USE ABOVE SELECTIONS (2434, 7) (2435, 0) (2435, 1) 2 (2435, 2) 175 (2435, 3) 299 (2435, 4) 173 (2435, 5) (2435, 6) DO NOT COLORIZE (2435, 7) (2436, 0) (2436, 1) 14 (2436, 2) 293 (2436, 3) 118 (2436, 4) 171 (2436, 5) 136 (2436, 6) Foreground (2436, 7) (2437, 0) (2437, 1) 11 (2437, 2) (2437, 3) (2437, 4) (2437, 5) (2437, 6) (2437, 7) 3 (2437, 8) ForeGroundOption (2438, 0) (2438, 1) 12 (2438, 2) (2438, 3) (2438, 4) (2438, 5) (2438, 6) Light Green (2438, 7) (2439, 0) (2439, 1) 12 (2439, 2) (2439, 3) (2439, 4) (2439, 5) (2439, 6) Dark Blue (2439, 7) (2440, 0) (2440, 1) 12 (2440, 2) (2440, 3) (2440, 4) (2440, 5) (2440, 6) Yellow (2440, 7) (2441, 0) (2441, 1) 12 (2441, 2) (2441, 3) (2441, 4) (2441, 5) (2441, 6) Magenta (2441, 7) (2442, 0) (2442, 1) 12 (2442, 2) (2442, 3) (2442, 4) (2442, 5) (2442, 6) Cyan (2442, 7) (2443, 0) (2443, 1) 12 (2443, 2) (2443, 3) (2443, 4) (2443, 5) (2443, 6) Lightly Shaded (2443, 7) (2444, 0) (2444, 1) 12 (2444, 2) (2444, 3) (2444, 4) (2444, 5) (2444, 6) None (2444, 7) (2445, 0) (2445, 1) (2445, 2) (2445, 3) (2445, 4) (2445, 5) (2445, 6) (2445, 7) (2446, 0) (2446, 1) (2446, 2) (2446, 3) (2446, 4) (2446, 5) (2446, 6) (2446, 7) (2447, 0) (2447, 1) New_Section (2447, 2) (2448, 0) (2448, 1) TRUE (2448, 2) (2449, 0) (2449, 1) TRUE (2449, 2) (2450, 0) (2450, 1) TRUE (2450, 2) (2451, 0) (2451, 1) TRUE (2451, 2) (2452, 0) (2452, 1) TRUE (2452, 2) (2453, 0) (2453, 1) TRUE (2453, 2) (2454, 0) (2454, 1) TRUE (2454, 2) (2455, 0) (2455, 1) TRUE (2455, 2) (2456, 0) (2456, 1) TRUE (2456, 2) (2457, 0) (2457, 1) TRUE (2457, 2) (2458, 0) (2458, 1) TRUE (2458, 2) (2459, 0) (2459, 1) TRUE (2459, 2) (2460, 0) (2460, 1) TRUE (2460, 2) (2461, 0) (2461, 1) TRUE (2461, 2) (2462, 0) (2462, 1) TRUE (2462, 2) (2463, 0) (2463, 1) TRUE (2463, 2) (2464, 0) (2464, 1) TRUE (2464, 2) (2465, 0) (2465, 1) FALSE (2465, 2) (2466, 0) (2466, 1) TRUE (2466, 2) (2467, 0) (2467, 1) TRUE (2467, 2) (2468, 0) (2468, 1) TRUE (2468, 2) (2469, 0) (2469, 1) 8 (2469, 2) (2470, 0) (2470, 1) FALSE (2470, 2) (2471, 0) (2471, 1) TRUE (2471, 2) (2472, 0) (2472, 1) TRUE (2472, 2) (2473, 0) (2473, 1) TRUE (2473, 2) (2474, 0) (2474, 1) TRUE (2474, 2) (2475, 0) (2475, 1) FALSE (2475, 2) (2476, 0) (2476, 1) FALSE (2476, 2) (2477, 0) (2477, 1) TRUE (2477, 2) (2478, 0) (2478, 1) TRUE (2478, 2) (2479, 0) (2479, 1) TRUE (2479, 2) (2480, 0) (2480, 1) FALSE (2480, 2) (2481, 0) (2481, 1) (2481, 2) (2482, 0) (2482, 1) TRUE (2482, 2) (2483, 0) (2483, 1) TRUE (2483, 2) (2484, 0) (2484, 1) TRUE (2484, 2) (2485, 0) (2485, 1) TRUE (2485, 2) (2486, 0) (2486, 1) TRUE (2486, 2) (2487, 0) (2487, 1) TRUE (2487, 2) (2488, 0) (2488, 1) (2488, 2) (2489, 0) (2489, 1) TRUE (2489, 2) (2490, 0) (2490, 1) TRUE (2490, 2) (2491, 0) (2491, 1) TRUE (2491, 2) (2492, 0) (2492, 1) (2492, 2) (2493, 0) (2493, 1) FALSE (2493, 2) (2494, 0) (2494, 1) TRUE (2494, 2) (2495, 0) (2495, 1) TRUE (2495, 2) (2496, 0) (2496, 1) TRUE (2496, 2) (2497, 0) (2497, 1) FALSE (2497, 2) (2498, 0) (2498, 1) TRUE (2498, 2) (2499, 0) (2499, 1) (2499, 2) (2500, 0) (2500, 1) TRUE (2500, 2) (2501, 0) (2501, 1) TRUE (2501, 2) (2502, 0) (2502, 1) TRUE (2502, 2) (2503, 0) (2503, 1) TRUE (2503, 2) (2504, 0) (2504, 1) FALSE (2504, 2) (2505, 0) (2505, 1) TRUE (2505, 2) (2506, 0) (2506, 1) FALSE (2506, 2) (2507, 0) (2507, 1) FALSE (2507, 2) (2508, 0) (2508, 1) FALSE (2508, 2) (2509, 0) (2509, 1) (2509, 2) (2510, 0) (2510, 1) FALSE (2510, 2) (2511, 0) (2511, 1) TRUE (2511, 2) (2512, 0) (2512, 1) TRUE (2512, 2) (2513, 0) (2513, 1) TRUE (2513, 2) (2514, 0) (2514, 1) FALSE (2514, 2) (2515, 0) (2515, 1) FALSE (2515, 2) (2516, 0) (2516, 1) TRUE (2516, 2) (2517, 0) (2517, 1) FALSE (2517, 2) (2518, 0) (2518, 1) TRUE (2518, 2) (2519, 0) (2519, 1) TRUE (2519, 2) (2520, 0) (2520, 1) TRUE (2520, 2) (2521, 0) (2521, 1) TRUE (2521, 2) (2522, 0) (2522, 1) TRUE (2522, 2) (2523, 0) (2523, 1) TRUE (2523, 2) (2524, 0) (2524, 1) (2524, 2) (2525, 0) (2525, 1) TRUE (2525, 2) (2526, 0) (2526, 1) FALSE (2526, 2) (2527, 0) (2527, 1) FALSE (2527, 2) (2528, 0) (2528, 1) (2528, 2) (2529, 0) (2529, 1) TRUE (2529, 2) (2530, 0) (2530, 1) TRUE (2530, 2) (2531, 0) (2531, 1) TRUE (2531, 2) (2532, 0) (2532, 1) (2532, 2) (2533, 0) (2533, 1) TRUE (2533, 2) (2534, 0) (2534, 1) FALSE (2534, 2) (2535, 0) (2535, 1) FALSE (2535, 2) (2536, 0) (2536, 1) FALSE (2536, 2) (2537, 0) (2537, 1) (2537, 2) (2538, 0) (2538, 1) TRUE (2538, 2) (2539, 0) (2539, 1) TRUE (2539, 2) (2540, 0) (2540, 1) TRUE (2540, 2) (2541, 0) (2541, 1) TRUE (2541, 2) (2542, 0) (2542, 1) TRUE (2542, 2) (2543, 0) (2543, 1) FALSE (2543, 2) (2544, 0) (2544, 1) TRUE (2544, 2) (2545, 0) (2545, 1) (2545, 2) (2546, 1) 15 (2546, 2) (2547, 0) (2547, 1) 8 (2547, 2) (2548, 0) (2548, 1) TRUE (2548, 2) (2549, 0) (2549, 1) TRUE (2549, 2) (2550, 1) TRUE (2550, 2) (2551, 0) (2551, 1) FALSE (2551, 2) (2552, 1) FALSE (2552, 2) (2553, 1) FALSE (2553, 2) (2554, 1) TRUE (2554, 2) (2555, 0) (2555, 1) TRUE (2555, 2) (2556, 0) (2556, 1) TRUE (2556, 2) (2557, 0) (2557, 1) TRUE (2557, 2) (2558, 0) (2558, 1) TRUE (2558, 2) (2559, 0) (2559, 1) TRUE (2559, 2) (2560, 0) (2560, 1) TRUE (2560, 2) (2561, 0) (2561, 1) TRUE (2561, 2) (2562, 0) (2562, 1) TRUE (2562, 2) (2563, 0) (2563, 1) TRUE (2563, 2) (2564, 0) (2564, 1) TRUE (2564, 2) (2565, 0) (2565, 1) TRUE (2565, 2) (2566, 0) (2566, 1) TRUE (2566, 2) (2567, 0) (2567, 1) TRUE (2567, 2) (2568, 0) (2568, 1) FALSE (2568, 2) (2569, 0) (2569, 1) TRUE (2569, 2) (2570, 0) (2570, 1) TRUE (2570, 2) (2571, 0) (2571, 1) TRUE (2571, 2) (2572, 0) (2572, 1) TRUE (2572, 2) (2573, 0) (2573, 1) TRUE (2573, 2) (2574, 0) (2574, 1) TRUE (2574, 2) (2575, 0) (2575, 1) TRUE (2575, 2) (2576, 0) (2576, 1) TRUE (2576, 2) (2577, 0) (2577, 1) FALSE (2577, 2) (2578, 0) (2578, 1) TRUE (2578, 2) (2579, 0) (2579, 1) TRUE (2579, 2) (2580, 0) (2580, 1) TRUE (2580, 2) (2581, 0) (2581, 1) TRUE (2581, 2) (2582, 0) (2582, 1) TRUE (2582, 2) (2583, 0) (2583, 1) TRUE (2583, 2) (2584, 0) (2584, 1) TRUE (2584, 2) (2585, 0) (2585, 1) TRUE (2585, 2) (2586, 0) (2586, 1) TRUE (2586, 2) (2587, 0) (2587, 1) FALSE (2587, 2) (2588, 0) (2588, 1) TRUE (2588, 2) (2589, 0) (2589, 1) TRUE (2589, 2) (2590, 0) (2590, 1) TRUE (2590, 2) (2591, 0) (2591, 1) TRUE (2591, 2) (2592, 0) (2592, 1) TRUE (2592, 2) (2593, 0) (2593, 1) TRUE (2593, 2) (2594, 0) (2594, 1) (2594, 2) (2595, 0) (2595, 1) TRUE (2595, 2) (2596, 0) (2596, 1) 5 (2596, 2) (2597, 0) (2597, 1) TRUE (2597, 2) (2598, 0) (2598, 1) TRUE (2598, 2) (2599, 0) (2599, 1) TRUE (2599, 2) (2600, 0) (2600, 1) TRUE (2600, 2) (2601, 0) (2601, 1) TRUE (2601, 2) (2602, 0) (2602, 1) TRUE (2602, 2) (2603, 0) (2603, 1) TRUE (2603, 2) (2604, 0) (2604, 1) TRUE (2604, 2) (2605, 0) (2605, 1) TRUE (2605, 2) (2606, 0) (2606, 1) TRUE (2606, 2) (2607, 0) (2607, 1) TRUE (2607, 2) (2608, 0) (2608, 1) TRUE (2608, 2) (2609, 0) (2609, 1) TRUE (2609, 2) (2610, 0) (2610, 1) TRUE (2610, 2) (2611, 0) (2611, 1) TRUE (2611, 2) (2612, 0) (2612, 1) TRUE (2612, 2) (2613, 0) (2613, 1) TRUE (2613, 2) (2614, 0) (2614, 1) TRUE (2614, 2) ResetCfg (2615, 0) (2615, 1) TRUE (2615, 2) TRUE (2616, 0) (2616, 1) TRUE (2616, 2) TRUE (2617, 0) (2617, 1) TRUE (2617, 2) TRUE (2618, 0) (2618, 1) TRUE (2618, 2) TRUE (2619, 0) (2619, 1) TRUE (2619, 2) FALSE (2620, 0) (2620, 1) (2620, 2) TRUE (2621, 0) (2621, 1) (2621, 2) (2622, 0) (2622, 1) SectionOptions (2622, 2) (2623, 0) (2623, 1) (2623, 2) (2623, 3) (2623, 4) 322 (2623, 5) 201 (2623, 6) (2623, 7) (2624, 0) (2624, 1) 14 (2624, 2) 10 (2624, 3) 101 (2624, 4) 301 (2624, 5) 51 (2624, 6) (2624, 7) (2625, 0) (2625, 1) 11 (2625, 2) (2625, 3) (2625, 4) (2625, 5) (2625, 6) (2625, 7) 1 (2625, 8) DisplayEmpties (2626, 0) (2626, 1) 12 (2626, 2) (2626, 3) (2626, 4) (2626, 5) (2626, 6) Display empty directories (2626, 7) (2627, 0) (2627, 1) 12 (2627, 2) (2627, 3) (2627, 4) (2627, 5) (2627, 6) Do not display empty directories (2627, 7) (2628, 0) (2628, 1) 1 (2628, 2) 101 (2628, 3) 174 (2628, 4) 88 (2628, 5) (2628, 6) OK (2628, 7) (2629, 0) (2629, 1) 14 (2629, 2) 10 (2629, 3) 32 (2629, 4) 301 (2629, 5) 51 (2629, 6) (2629, 7) (2630, 0) (2630, 1) 11 (2630, 2) (2630, 3) (2630, 4) (2630, 5) (2630, 6) (2630, 7) 1 (2630, 8) Searchsubs (2631, 0) (2631, 1) 12 (2631, 2) (2631, 3) (2631, 4) (2631, 5) (2631, 6) Search sub-directories for files (2631, 7) (2632, 0) (2632, 1) 12 (2632, 2) (2632, 3) (2632, 4) (2632, 5) (2632, 6) Do not do sub-directories (2632, 7) (2633, 0) (2633, 1) 5 (2633, 2) 25 (2633, 3) 6 (2633, 4) (2633, 5) (2633, 6) Please specify the section options (2633, 7) (2634, 0) (2634, 1) (2634, 2) (2635, 0) (2635, 1) FIX_COMMENTS (2635, 2) Indents comments to two spaces (2636, 0) (2636, 1) TRUE (2636, 2) (2637, 0) (2637, 1) TRUE (2637, 2) puts two spaces in front of any documentation (2638, 0) (2638, 1) FALSE (2638, 2) (2639, 0) (2639, 1) TRUE (2639, 2) (2640, 0) (2640, 1) TRUE (2640, 2) (2641, 0) (2641, 1) TRUE (2641, 2) (2642, 0) (2642, 1) (2643, 0) TandC (2643, 1) Trim and Capitalize Macro (2644, 1) TRUE (2644, 2) converts to upper case (2645, 1) TRUE (2645, 2) removes any blanks (2646, 1) TRUE (2647, 1) (2648, 0) CHKDIR (2648, 1) CHKDIR (2649, 1) TRUE (2649, 2) if a single letter is entered for the drive (2650, 1) TRUE (2650, 2) add a colon (2651, 1) TRUE (2652, 1) TRUE (2652, 2) check for path statement (2653, 1) TRUE (2654, 1) TRUE (2654, 2) if no path display error box (2655, 1) TRUE (2655, 2) stop macros (2656, 1) TRUE (2657, 1) TRUE (2657, 2) check for a \ at end of path (2658, 1) TRUE (2658, 2) remove \ if present (2659, 1) TRUE (2660, 1) TRUE (2661, 1) TRUE (2662, 1) TRUE (2663, 1) #VALUE! (2664, 1) TRUE (2665, 1) TRUE (2666, 1) TRUE (2667, 1) FALSE (2668, 1) TRUE (2669, 1) TRUE (2670, 1) TRUE (2671, 1) TRUE (2672, 1) (2673, 1) FALSE (2674, 1) TRUE (2675, 1) TRUE (2676, 1) TRUE (2677, 1) FALSE (2678, 1) TRUE (2679, 1) (2680, 1) TRUE (2681, 1) (2682, 1) (2683, 0) CHKFILETYPE (2683, 1) CHKFILETYPE (2684, 1) TRUE (2685, 1) FALSE (2686, 1) TRUE (2687, 1) TRUE (2688, 1) FALSE (2689, 1) TRUE (2690, 1) TRUE (2691, 1) TRUE (2692, 1) FALSE (2693, 1) #VALUE! (2694, 1) TRUE (2695, 1) TRUE (2696, 1) TRUE (2697, 1) FALSE (2698, 1) (2699, 1) TRUE (2700, 1) (2701, 0) CHKDIROPTION (2701, 1) CHKSUBDIROPTION (2702, 1) TRUE (2703, 1) TRUE (2704, 1) TRUE (2705, 1) TRUE (2706, 1) FALSE (2707, 1) TRUE (2708, 1) TRUE (2709, 1) FALSE (2710, 1) TRUE (2711, 1) TRUE (2712, 1) FALSE (2713, 1) TRUE (2713, 2) (2714, 1) TRUE (2715, 1) FALSE (2716, 1) (2717, 1) CHKSHOWDIROPTION (2718, 1) TRUE (2719, 1) FALSE (2720, 1) TRUE (2721, 1) FALSE (2722, 1) TRUE (2723, 1) TRUE (2724, 1) FALSE (2725, 1) TRUE (2726, 1) TRUE (2726, 2) (2727, 1) FALSE (2727, 2) (2728, 1) TRUE (2728, 2) (2729, 1) TRUE (2729, 2) (2730, 1) FALSE (2730, 2) (2731, 1) (2732, 1) (2733, 1) UpdateADirectory (2733, 2) this option used by FileControl toolbar (2734, 1) TRUE (2735, 1) TRUE (2736, 1) TRUE (2737, 1) TRUE (2738, 1) TRUE (2739, 1) #N/A! (2739, 2) done this was as update..via menu called by other funtions (2740, 1) TRUE (2741, 1) TRUE (2742, 1) #N/A! (2743, 1) TRUE (2744, 1) #N/A! (2745, 1) TRUE (2746, 1) TRUE (2747, 1) (2748, 1) MASTERDIRNAME (2749, 1) C:\XLSFILES (2750, 1) (2751, 1) Update (2752, 1) TRUE (2753, 1) TRUE (2753, 2) UpdateAfterADirCopy (2754, 1) TRUE (2755, 1) FALSE (2756, 1) #N/A! (2757, 1) TRUE (2758, 1) TRUE (2759, 1) TRUE (2760, 1) TRUE (2761, 1) TRUE (2762, 1) FALSE (2763, 1) TRUE (2764, 1) TRUE (2765, 1) TRUE (2766, 1) TRUE (2767, 1) TRUE (2768, 1) TRUE (2769, 1) TRUE (2770, 1) TRUE (2771, 1) TRUE (2772, 1) TRUE (2773, 1) TRUE (2774, 1) TRUE (2775, 1) TRUE (2776, 1) FALSE (2777, 1) FALSE (2778, 1) TRUE (2779, 1) TRUE (2780, 1) TRUE (2781, 1) TRUE (2782, 1) (2783, 1) #N/A! (2783, 2) trims blanks, capitalizes (2784, 1) #N/A! (2784, 2) validate directory entry (2785, 1) TRUE (2785, 2) stores name for later use (2786, 1) TRUE (2787, 1) TRUE (2787, 2) stores name in macro file for use also (2788, 1) TRUE (2789, 1) TRUE (2790, 1) TRUE (2791, 1) TRUE (2792, 1) TRUE (2793, 1) TRUE (2793, 2) (2794, 1) FALSE (2795, 1) TRUE (2796, 1) #N/A! (2797, 1) TRUE (2798, 1) TRUE (2798, 2) go to filetype cell (2799, 1) #N/A! (2799, 2) trims blanks, capitalizes (2800, 1) #N/A! (2800, 2) validate file type (2801, 1) TRUE (2801, 2) store filetype (2802, 1) TRUE (2802, 2) goto directory option cell (2803, 1) #N/A! (2803, 2) checks option (2804, 1) TRUE (2804, 2) store directory option (2805, 1) TRUE (2805, 2) go to show directory cell (2806, 1) FALSE (2807, 1) #N/A! (2807, 2) checks option (2808, 1) TRUE (2808, 2) store option (2809, 1) select old info (2810, 1) TRUE (2810, 2) go to top of current file info (2811, 1) TRUE (2811, 2) names top left cell (2812, 1) TRUE (2812, 2) goes to bottom right cell (2813, 1) TRUE (2814, 1) TRUE (2814, 2) names bottom right cell (2815, 1) TRUE (2816, 1) TRUE (2816, 2) move to column a (2817, 1) TRUE (2817, 2) goes up to section marker (2818, 1) TRUE (2818, 2) select filetype (2819, 1) #N/A! (2820, 1) TRUE (2821, 1) TRUE (2822, 1) TRUE (2823, 1) TRUE (2824, 1) TRUE (2825, 1) TRUE (2826, 1) TRUE (2826, 2) (2827, 1) TRUE (2827, 2) (2828, 1) TRUE (2828, 2) (2829, 1) TRUE (2829, 2) (2830, 1) TRUE (2830, 2) (2831, 1) TRUE (2831, 2) (2832, 1) TRUE (2832, 2) (2833, 1) TRUE (2833, 2) (2834, 1) TRUE (2834, 2) (2835, 1) name range old info (2835, 2) (2836, 1) TRUE (2836, 2) selects entire range (2837, 1) TRUE (2837, 2) names range oldinfo (2838, 1) TRUE (2839, 1) TRUE (2839, 2) select single cell (2840, 1) TRUE (2841, 1) TRUE (2841, 2) goto workarea (2842, 1) TRUE (2843, 1) TRUE (2843, 2) move to top of old info (2844, 1) TRUE (2844, 2) move to first directory name (2845, 1) TRUE (2846, 1) TRUE (2847, 1) #N/A! (2848, 1) TRUE (2849, 1) sort and delete old files without any documentation (2850, 1) TRUE (2851, 1) TRUE (2852, 1) TRUE (2853, 1) TRUE (2853, 2) to to top of data (2854, 1) TRUE (2855, 1) TRUE (2855, 2) select old data (2856, 1) TRUE (2856, 2) sort files so those with comments are on top (2857, 1) TRUE (2857, 2) go to first file's info column (2858, 1) #N/A! (2858, 2) go to first blank cell (2859, 1) TRUE (2859, 2) move to first column (2860, 1) TRUE (2860, 2) select rows without any info (2861, 1) TRUE (2862, 1) TRUE (2862, 2) erase contents (2863, 1) TRUE (2863, 2) select current cell so only a single cell is active (2864, 1) TRUE (2865, 1) Get_File_Error_Return (2866, 1) TRUE (2867, 1) TRUE (2868, 1) #N/A! (2868, 2) import data from DOS (2869, 1) (2870, 1) TRUE (2871, 1) TRUE (2872, 1) #N/A! (2872, 2) go to first blank cell (2873, 1) TRUE (2873, 2) select bottom right of data (2874, 1) TRUE (2875, 1) TRUE (2875, 2) select data (2876, 1) TRUE (2877, 1) TRUE (2877, 2) Does this only if old data rows with comments (2878, 1) TRUE (2879, 1) #N/A! (2879, 2) copy documentation and zapp old files (2880, 1) TRUE (2880, 2) (2881, 1) TRUE (2881, 2) (2882, 1) TRUE (2882, 2) (2883, 1) TRUE (2883, 2) (2884, 1) TRUE (2884, 2) (2885, 1) TRUE (2885, 2) (2886, 1) #N/A! (2886, 2) repeats thru above selection (2887, 1) TRUE (2887, 2) (2888, 1) TRUE (2888, 2) (2889, 1) TRUE (2889, 2) go to top of file column (2890, 1) #N/A! (2891, 1) TRUE (2891, 2) name corners of new info (2892, 1) TRUE (2893, 1) TRUE (2894, 1) TRUE (2895, 1) TRUE (2896, 1) TRUE (2896, 2) name new info (2897, 1) TRUE (2898, 1) TRUE (2899, 1) TRUE (2900, 1) TRUE (2900, 2) go to info file (2901, 1) TRUE (2902, 1) TRUE (2903, 1) TRUE (2904, 1) #N/A! (2905, 1) TRUE (2906, 1) TRUE (2907, 1) TRUE (2908, 1) TRUE (2908, 2) Erase workarea (2909, 1) TRUE (2910, 1) TRUE (2911, 1) TRUE (2912, 1) TRUE (2913, 1) (2914, 1) TRUE (2914, 2) relocate cursor (2915, 1) TRUE (2916, 1) (2917, 1) TRUE (2918, 1) TRUE (2919, 1) TRUE (2920, 1) TRUE (2921, 1) TRUE (2922, 1) TRUE (2923, 1) TRUE (2924, 1) TRUE (2925, 1) TRUE (2926, 1) TRUE (2927, 1) TRUE (2928, 1) TRUE (2929, 1) TRUE (2930, 1) TRUE (2931, 1) TRUE (2932, 1) TRUE (2933, 1) TRUE (2934, 1) TRUE (2935, 1) TRUE (2936, 1) TRUE (2937, 1) TRUE (2938, 1) TRUE (2939, 1) TRUE (2940, 1) TRUE (2941, 1) TRUE (2942, 1) TRUE (2943, 1) TRUE (2944, 1) TRUE (2945, 1) TRUE (2946, 1) TRUE (2947, 1) TRUE (2947, 2) end of update macro (2948, 1) (2948, 2) (2949, 1) add or delete rows (2949, 2) (2950, 1) TRUE (2950, 2) (2951, 1) TRUE (2951, 2) (2952, 1) TRUE (2952, 2) (2953, 1) TRUE (2953, 2) (2954, 1) TRUE (2954, 2) (2955, 1) TRUE (2955, 2) (2956, 1) TRUE (2956, 2) (2957, 1) TRUE (2957, 2) (2958, 1) TRUE (2958, 2) (2959, 1) TRUE (2959, 2) (2960, 1) TRUE (2960, 2) (2961, 1) TRUE (2961, 2) (2962, 1) TRUE (2962, 2) (2963, 1) TRUE (2963, 2) (2964, 1) TRUE (2964, 2) (2965, 1) TRUE (2965, 2) (2966, 1) TRUE (2966, 2) (2967, 1) TRUE (2967, 2) (2968, 1) (2968, 2) (2969, 1) (2969, 2) (2970, 1) (2970, 2) (2971, 1) (2971, 2) (2972, 1) RELOCATE_DIR_NAMES (2972, 2) (2973, 1) TRUE (2973, 2) (2974, 1) TRUE (2974, 2) a zero indicates a directory row (2975, 1) TRUE (2975, 2) (2976, 1) TRUE (2976, 2) remove empty directories (2977, 1) TRUE (2977, 2) (2978, 1) TRUE (2978, 2) (2979, 1) TRUE (2979, 2) (2980, 1) TRUE (2980, 2) (2981, 1) TRUE (2981, 2) select cell containing dir name (2982, 1) TRUE (2982, 2) (2983, 1) TRUE (2983, 2) (2984, 1) TRUE (2984, 2) paste over the zero (2985, 1) TRUE (2985, 2) copies format (2986, 1) TRUE (2986, 2) selects directory cells (2987, 1) TRUE (2987, 2) copies format (2988, 1) TRUE (2988, 2) remove borders (2989, 1) TRUE (2989, 2) insert a blank line (2990, 1) #N/A! (2990, 2) (2991, 1) TRUE (2991, 2) put an 'xx' in blank cell (2992, 1) TRUE (2992, 2) go to directory that was processed (2993, 1) TRUE (2993, 2) (2994, 1) TRUE (2994, 2) (2995, 1) TRUE (2995, 2) go down one cell (2996, 1) TRUE (2996, 2) (2997, 1) TRUE (2997, 2) (2998, 1) (2999, 1) COPY_AND_ZAPP (2999, 2) starts on directory name (3000, 1) TRUE (3000, 2) check is done on file name column (3001, 1) TRUE (3001, 2) go to documenation column (3002, 1) TRUE (3002, 2) go down one cell if blank (3003, 1) TRUE (3003, 2) go back to file row and down 1 cell (3004, 1) do this if documentation not blank (3005, 1) TRUE (3005, 2) (3006, 1) TRUE (3006, 2) go back to directory name (3007, 1) TRUE (3007, 2) assign names to path in this row (3008, 1) TRUE (3008, 2) go to next directory name (3009, 1) TRUE (3009, 2) assign it a name (3010, 1) TRUE (3010, 2) if directories are the same chk filetypes (3011, 1) TRUE (3011, 2) go to file name on original row (3012, 1) TRUE (3012, 2) assign it to temp3 (3013, 1) TRUE (3013, 2) go to file name on 2nd row (3014, 1) TRUE (3014, 2) assign it a name (3015, 1) TRUE (3015, 2) if files the same, copy documentation (3016, 1) TRUE (3016, 2) copies documentation (3017, 1) TRUE (3017, 2) pastes to row below (3018, 1) TRUE (3019, 1) TRUE (3020, 1) TRUE (3021, 1) TRUE (3022, 1) TRUE (3023, 1) TRUE (3024, 1) TRUE (3025, 1) TRUE (3026, 1) TRUE (3026, 2) go back up to original row dir cell (3027, 1) TRUE (3027, 2) deletes row (3028, 1) TRUE (3028, 2) go to next directory name (3029, 1) TRUE (3030, 1) TRUE (3030, 2) go up one row and to directory name (3031, 1) TRUE (3032, 1) TRUE (3032, 2) end of temp3=temp4 if (3033, 1) TRUE (3033, 2) else to temp1=temp2 if (3034, 1) TRUE (3034, 2) go to temp1 row (3035, 1) TRUE (3035, 2) if not the same directory, delete (3036, 1) TRUE (3036, 2) end of temp1=temp2 IF (3037, 1) TRUE (3037, 2) end of documentation IF (3038, 1) TRUE (3038, 2) end of while loop (3039, 1) TRUE (3040, 1) (3041, 1) NEXTBLANK (3041, 2) go to next blank cell in a column (3042, 1) TRUE (3042, 2) do if statement if not blank (3043, 1) TRUE (3044, 1) TRUE (3044, 2) do if next cell not blank (3045, 1) TRUE (3045, 2) go up one row then do end down (3046, 1) TRUE (3047, 1) TRUE (3048, 1) TRUE (3048, 2) end second if (3049, 1) TRUE (3049, 2) end first if (3050, 1) TRUE (3051, 1) (3052, 1) LABEL_OLD_FILES (3053, 1) TRUE (3053, 2) select directory format (3054, 1) TRUE (3055, 1) TRUE (3056, 1) TRUE (3057, 1) TRUE (3057, 2) clears directory formats (3058, 1) TRUE (3058, 2) select single cell (3059, 1) TRUE (3059, 2) store directory name (3060, 1) TRUE (3060, 2) move to cell to left of dir name (3061, 1) TRUE (3061, 2) name location (3062, 1) TRUE (3062, 2) go to cell below dir name (3063, 1) TRUE (3064, 1) TRUE (3064, 2) if cell blank, go up one and stop (3065, 1) TRUE (3066, 1) TRUE (3066, 2) if not blank, go to dir name and then to end (3067, 1) TRUE (3068, 1) TRUE (3069, 1) TRUE (3070, 1) TRUE (3070, 2) name bottom location (3071, 1) TRUE (3071, 2) select range (3072, 1) TRUE (3072, 2) copy dir name into cells (3073, 1) TRUE (3073, 2) go to directory name (3074, 1) TRUE (3074, 2) change dir name to a blank & a zero so it sorts out on top (3075, 1) TRUE (3075, 2) go to blank cell below temp2 and to the left (3076, 1) TRUE (3076, 2) go to next directory (3077, 1) TRUE (3078, 1) (3079, 1) (3080, 1) GET_NEW_DATA (3081, 1) TRUE (3081, 2) Removes ALLDONE.MGR if it exists. (3082, 1) #VALUE! (3082, 2) this is done as the existance fo this file tells the (3083, 1) #VALUE! (3083, 2) macro to continue. (3084, 1) TRUE (3085, 1) TRUE (3085, 2) delete to insure old report is not found (3086, 1) #VALUE! (3087, 1) #VALUE! (3088, 1) TRUE (3088, 2) delete to insure an old list is not found (3089, 1) TRUE (3090, 1) TRUE (3091, 1) (3092, 1) TRUE (3092, 2) construct exec command (3093, 1) TRUE (3094, 1) TRUE (3095, 1) TRUE (3096, 1) #N/A! (3097, 1) TRUE (3098, 1) TRUE (3099, 1) TRUE (3099, 2) pause excel macro while exec executes (3100, 1) TRUE (3101, 1) TRUE (3101, 2) 11 (3102, 1) TRUE (3103, 1) (3104, 1) TRUE (3104, 2) Safety net stop in case EXE file doesn't work (3105, 1) TRUE (3106, 1) TRUE (3107, 1) (3108, 1) TRUE (3108, 2) remove all done file if it exists (3109, 1) TRUE (3110, 1) TRUE (3111, 1) (3112, 1) TRUE (3112, 2) Confirm that Exe worked ok (3113, 1) TRUE (3114, 1) TRUE (3115, 1) TRUE (3116, 1) TRUE (3117, 1) TRUE (3118, 1) TRUE (3119, 1) TRUE (3120, 1) TRUE (3121, 1) FALSE (3122, 1) TRUE (3123, 1) (3124, 1) TRUE (3124, 2) turn off error detection of FileFns problem (3125, 1) TRUE (3126, 1) (3127, 1) TRUE (3127, 2) open new file listing (3128, 1) TRUE (3129, 1) TRUE (3129, 2) goes back to top of sheet (3130, 1) TRUE (3130, 2) selects 1st column (3131, 1) TRUE (3131, 2) parses the column (3132, 1) select range, copy, paste and close file (3132, 2) (3133, 1) TRUE (3133, 2) select first cell that should contain file data (3134, 1) TRUE (3134, 2) names top left cell (3135, 1) TRUE (3135, 2) go to top so next command works ok (3136, 1) TRUE (3136, 2) goes to bottom cell (3137, 1) TRUE (3137, 2) goes to far right cell (3138, 1) TRUE (3138, 2) names bottom right cell (3139, 1) TRUE (3139, 2) selects entire range (3140, 1) TRUE (3140, 2) copies file info (3141, 1) TRUE (3141, 2) (3142, 1) TRUE (3142, 2) pastes file info (3143, 1) TRUE (3144, 1) TRUE (3144, 2) select and copy a single cell so clipboard is small (3145, 1) TRUE (3146, 1) TRUE (3146, 2) closes worksheet (3147, 1) TRUE (3148, 1) TRUE (3149, 1) TRUE (3149, 2) stops macro (3151, 1)