Appendix Thread. 3 *

**DocAElstein** · 03-23-2018, 12:48 PM

**DocAElstein** · 03-24-2018, 02:17 PM

**DocAElstein** · 03-24-2018, 02:49 PM

**DocAElstein** · 03-28-2018, 12:48 AM

**DocAElstein** · 03-28-2018, 01:36 PM

Using this File:
“UpdatesOnVistaAspire4810TZG25thMarch.txt” : https://app.box.com/s/z90o8yj7iz0188yci34mu7gahe2tfhce
That file is downloaded into the same Folder as the file containing the code from the last Post.
This code line needs to have that text file reference in it such:
Let ActiviEL = ThisWorkbook.Path & "\UpdatesOnVistaAspire4810TZG25thMarch.txt"
Run code entering these search values when prompted
2553154 2726958 2965291 2920813 3054873 974554

Here the output string

You looked for
2553154
2726958
2965291
2920813
3054873
974554

Finded was

_.______________________________________________

Using this File:
“UpdatesAcerMartinWin7Pro64Bit26thMarch.txt” : https://app.box.com/s/8m96l0e7yh1wcb15y06eaaz6a7vtjzgd
That file is downloaded into the same Folder as the file containing the code from the last Post.
This code line needs to have that text file reference in it such:
Let ActiviEL = ThisWorkbook.Path & "\“UpdatesAcerMartinWin7Pro64Bit26thMarch.txt"
Run code entering these search values when prompted
2553154 2726958 2965291 2920813 3054873 974554

Here the output string

You looked for
2553154
2726958
2965291
2920813
3054873
974554

Finded was

**DocAElstein** · 03-29-2018, 04:13 PM

Appendix notes in support of these Threads:
http://www.excelfox.com/forum/showth...en-insert-them
http://www.excelfox.com/forum/showth...ommand-Buttons

Trying to find .exd files and delete them.
The results of most of what I have read or results of asking people suggests that they are usually findable if you look for a temp or temp somewhere in a file path

These appear a bit difficult to find sometimes . You can try:

_ manually navigating

_ a windows explorer search for *.exd
StarDotexeExplorerSearch.JPG : https://imgur.com/hfbC93Z
Attachment 2037

_ a search in a small bar using %temp% or %Temp%
You can get the small bar from either hitting WindowsKey+r or by selecting the Windows symbol
PerCenttempPerCentsearch.JPG : https://imgur.com/LypHLGY
Attachment 2038
PerCenttempPerCentsearch2.jpg : https://imgur.com/DZvycco
Attachment 2039

It seems a bit inconsistent which search finds what, but usually it is said that you find important places looking something like these:
C:\Users\username\AppData\Local\Temp\Excel8.0
C:\Users\username\AppData\Local\Temp\VBE

I found sometimes .exd files here also
C:\Users\username\Application Data\Microsoft\Forms

Some other typical places I found
C:\Dokumente und Einstellungen\Administrator\Application Data\Microsoft\Forms
C:\Dokumente und Einstellungen\Administrator\AppData\LocalLow

_.____._____________________

This is one of my typical attempts to get a ActiveX control button to_... either
_ insert into worksheet
or , if already three
_ work
_... by deleting .exd files

What I typically tried:
I looked here C:\Users\Elston\AppData\Local\Temp\Excel8.0
I found this:
C Users Elston AppData Local Temp Excel8.0.jpg https://imgur.com/doXstmr
Attachment 2040

I deleted that MSForms.exd File ( Excel had to be closed to do that ) : It had no effect. ( By the way, MSForms.exd gets made again every time I hit the button, or it appears to get made as soon as I open any file that either has or has ever had a control embedded in a worksheet)

In C:\Users\Elston\AppData\Local\Temp\VBE I found these:
C Users Elston AppData Local Temp VBE.jpg https://imgur.com/wjaZpXp
Attachment 2041

So…for these files I did:…
MSComctlLib.exd : I deleted this , - no effect
MSForms.exd : This could not be deleted with Excel 2003 open, it can when it is closed. But that had no effect
RefEdit.exd : This could not be deleted with Excel 2003 open, it can when it is closed. But no that had effect
( By the way, MSForms.exd and RefEdit.exd get made again every time I hit the button, or it appears to get made as soon as I open any file that either has, or has ever had, a control embedded in a worksheet )

In C:\Users\Elston\Application Data\Microsoft\Forms
I found these:
( https://imgur.com/Lv2kyhk )

So……for these files I did:…
RefEdit.exd This could not be deleted with Excel 2003 open, it can when it is closed. But that had no effect
mscomctllib.exd I deleted this: That had no effect
SHDocVw.exd I deleted this: That had no effect
( By the way, MSForms.exd gets made again every time I hit the button, or it appears to get made as soon as I open any file that either has or has ever had a control embedded in a worksheet)

_.._______________-

So for me none of that helped to get me a working ActiveX control Button in a worksheet.

**DocAElstein** · 04-02-2018, 02:00 PM

Screenshots and extra notes in support of this Thread:
http://www.excelfox.com/forum/showth...0595#post10595

Distributed Files for the day for "Raghu.xlsx"
From Raghu
Using Excel 2007 32 bit

_Row\^Col	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	S No	Item	Price	Qty	Total	Distributed	Task1	Task2	Task3	Task4	Completed	Consolidated	Comments	Team Member
2	1	ABC01	$ 55.00	22	$ 1,210.00	15. Mrz 18								Raghu
3	5	ABC05	$ 7.22	62	$ 447.64	15. Mrz 18								Raghu
4	9	ABC09	$ 741.99	101	$ 74,940.99	15. Mrz 18								Raghu
5	13	ABC13	$ 8.51	12	$ 102.12	15. Mrz 18								Raghu
6	17	ABC17	$ 11.99	1	$ 11.99	15. Mrz 18								Raghu
7	21	ABC21	$ 12.99	5	$ 64.95	15. Mrz 18								Raghu
8	25	ABC25	$ 333.45	99	$ 33,011.55	15. Mrz 18								Raghu
9	29	ABC29	$ 13.66	7	$ 95.62	15. Mrz 18								Raghu
10	33	ABC33	$ 3.99	35	$ 139.65	15. Mrz 18								Raghu
11	37	ABC37	$ 55.00	22	$ 1,210.00	15. Mrz 18								Raghu
12	41	ABC41	$ 7.22	62	$ 447.64	15. Mrz 18								Raghu
13	45	ABC45	$ 741.99	101	$ 74,940.99	15. Mrz 18								Raghu

Worksheet: FromRaghu

Or if distributed today, 2nd April
Using Excel 2007 32 bit

_Row\^Col	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	S No	Item	Price	Qty	Total	Distributed	Task1	Task2	Task3	Task4	Completed	Consolidated	Comments	Team Member
2	1	ABC01	$ 55.00	22	$ 1,210.00	02.Apr.2018								Raghu
3	5	ABC05	$ 7.22	62	$ 447.64	02.Apr.2018								Raghu
4	9	ABC09	$ 741.99	101	$ 74,940.99	02.Apr.2018								Raghu
5	13	ABC13	$ 8.51	12	$ 102.12	02.Apr.2018								Raghu
6	17	ABC17	$ 11.99	1	$ 11.99	02.Apr.2018								Raghu
7	21	ABC21	$ 12.99	5	$ 64.95	02.Apr.2018								Raghu
8	25	ABC25	$ 333.45	99	$ 33,011.55	02.Apr.2018								Raghu
9	29	ABC29	$ 13.66	7	$ 95.62	02.Apr.2018								Raghu
10	33	ABC33	$ 3.99	35	$ 139.65	02.Apr.2018								Raghu
11	37	ABC37	$ 55.00	22	$ 1,210.00	02.Apr.2018								Raghu
12	41	ABC41	$ 7.22	62	$ 447.64	02.Apr.2018								Raghu
13	45	ABC45	$ 741.99	101	$ 74,940.99	02.Apr.2018								Raghu

Worksheet: Tabelle1

_.________________________

In next Post could be a typical returned worksheet from a team member : ( based on similar files in the Zip Folder "WorkDistributedAndConsolidated 16MAR18.zip" )

**DocAElstein** · 04-02-2018, 02:01 PM

From last post...

This could be a typical returned worksheet from a team member : ( based on similar files in the Zip Folder "WorkDistributedAndConsolidated 16MAR18.zip" )
Using Excel 2007 32 bit

_Row\^Col	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	S No	Item	Price	Qty	Total	Distributed	Task1	Task2	Task3	Task4	Completed	Consolidated	Comments	Team Member
2	1	ABC01	$ 55.00	22	$ 1,210.00	15. Mrz 18	RT1	RT2	RT3	RT4	02. Apr 18			Raghu
3	5	ABC05	$ 7.22	62	$ 447.64	15. Mrz 18	RT1	RT2	RT3	RT4	02. Apr 18			Raghu
4	9	ABC09	$ 741.99	101	$ 74,940.99	15. Mrz 18	RT1	RT2	RT3	RT4	02. Apr 18			Raghu
5	13	ABC13	$ 8.51	12	$ 102.12	15. Mrz 18	RT1	RT2	RT3	RT4	02. Apr 18			Raghu
6	17	ABC17	$ 11.99	1	$ 11.99	15. Mrz 18	RT1	RT2	RT3	RT4	02. Apr 18			Raghu
7	21	ABC21	$ 12.99	5	$ 64.95	15. Mrz 18								Raghu
8	25	ABC25	$ 333.45	99	$ 33,011.55	15. Mrz 18								Raghu
9	29	ABC29	$ 13.66	7	$ 95.62	15. Mrz 18								Raghu
10	33	ABC33	$ 3.99	35	$ 139.65	15. Mrz 18								Raghu
11	37	ABC37	$ 55.00	22	$ 1,210.00	15. Mrz 18								Raghu
12	41	ABC41	$ 7.22	62	$ 447.64	15. Mrz 18								Raghu
13	45	ABC45	$ 741.99	101	$ 74,940.99	15. Mrz 18								Raghu

Worksheet: FromRaghu

or this
Using Excel 2007 32 bit

_Row\^Col	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	S No	Item	Price	Qty	Total	Distributed	Task1	Task2	Task3	Task4	Completed	Consolidated	Comments	Team Member
2	1	ABC01	$ 55.00	22	$ 1,210.00	02.Apr.2018	RT1	RT2	RT3	RT4	02. Apr 18			Raghu
3	5	ABC05	$ 7.22	62	$ 447.64	02.Apr.2018	RT1	RT2	RT3	RT4	02. Apr 18			Raghu
4	9	ABC09	$ 741.99	101	$ 74,940.99	02.Apr.2018	RT1	RT2	RT3	RT4	02. Apr 18			Raghu
5	13	ABC13	$ 8.51	12	$ 102.12	02.Apr.2018	RT1	RT2	RT3	RT4	02. Apr 18			Raghu
6	17	ABC17	$ 11.99	1	$ 11.99	02.Apr.2018	RT1	RT2	RT3	RT4	02. Apr 18			Raghu
7	21	ABC21	$ 12.99	5	$ 64.95	02.Apr.2018								Raghu
8	25	ABC25	$ 333.45	99	$ 33,011.55	02.Apr.2018								Raghu
9	29	ABC29	$ 13.66	7	$ 95.62	02.Apr.2018								Raghu
10	33	ABC33	$ 3.99	35	$ 139.65	02.Apr.2018								Raghu
11	37	ABC37	$ 55.00	22	$ 1,210.00	02.Apr.2018								Raghu
12	41	ABC41	$ 7.22	62	$ 447.64	02.Apr.2018								Raghu
13	45	ABC45	$ 741.99	101	$ 74,940.99	02.Apr.2018								Raghu

Worksheet: Tabelle1

**DocAElstein** · 04-02-2018, 02:26 PM

For this Post
http://www.excelfox.com/forum/showth...0595#post10595

Daily data files completed by team members:
John

S No	Item	Price	Qty	Total	Distributed	Task1	Task2	Task3	Task4	Completed	Consolidated
2	ABC02	$ 13.66	7	$ 95.62	02.Apr.2018	JT1	JT2	JT3	JT4	02.Apr.2018
6	ABC06	$ 3.99	35	$ 139.65	02.Apr.2018	JT1	JT2	JT3	JT4	02.Apr.2018
10	ABC10	$ 55.00	22	$ 1,210.00	02.Apr.2018	JT1	JT2	JT3	JT4	02.Apr.2018
14	ABC14	$ 7.22	62	$ 447.64	02.Apr.2018	JT1	JT2	JT3	JT4	02.Apr.2018
18	ABC18	$ 741.99	101	$ 74,940.99	02.Apr.2018	JT1	JT2	JT3	JT4	02.Apr.2018
22	ABC22	$ 8.51	12	$ 102.12	02.Apr.2018	JT1	JT2	JT3	JT4	02.Apr.2018
26	ABC26	$ 11.99	1	$ 11.99	02.Apr.2018

Worksheet: Tabelle1

Greg

3	ABC03	$ 12.99	5	$ 64.95	02.Apr.2018	GT1	GT2	GT3	GT4	02.Apr.2018
7	ABC07	$ 333.45	99	$ 33,011.55	02.Apr.2018	GT1	GT2	GT3	GT4	02.Apr.2018
11	ABC11	$ 13.66	7	$ 95.62	02.Apr.2018	GT1	GT2	GT3	GT4	02.Apr.2018
15	ABC15	$ 3.99	35	$ 139.65	02.Apr.2018	GT1	GT2	GT3	GT4	02.Apr.2018
19	ABC19	$ 55.00	22	$ 1,210.00	02.Apr.2018	GT1	GT2	GT3	GT4	02.Apr.2018
23	ABC23	$ 7.22	62	$ 447.64	02.Apr.2018

Worksheet: Tabelle1

Margret

4	ABC04	$ 8.51	12	$ 102.12	02.Apr.2018	MT1	MT2	MT3	MT4	02.Apr.2018
8	ABC08	$ 11.99	1	$ 11.99	02.Apr.2018	MT1	MT2	MT3	MT4	02.Apr.2018
12	ABC12	$ 12.99	5	$ 64.95	02.Apr.2018	MT1	MT2	MT3	MT4	02.Apr.2018
16	ABC16	$ 333.45	99	$ 33,011.55	02.Apr.2018	MT1	MT2	MT3	MT4	02.Apr.2018
20	ABC20	$ 13.66	7	$ 95.62	02.Apr.2018	MT1	MT2	MT3	MT4	02.Apr.2018
24	ABC24	$ 3.99	35	$ 139.65	02.Apr.2018	MT1	MT2	MT3	MT4	02.Apr.2018
28	ABC28	$ 55.00	22	$ 1,210.00	02.Apr.2018	MT1	MT2	MT3	MT4	02.Apr.2018
32	ABC32	$ 7.22	62	$ 447.64	02.Apr.2018

Worksheet: Tabelle1

Raghu

_Row\^Col	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	S No	Item	Price	Qty	Total	Distributed	Task1	Task2	Task3	Task4	Completed	Consolidated	Comments	Team Member
2	1	ABC01	$ 55.00	22	$ 1,210.00	02.Apr.2018	RT1	RT2	RT3	RT4	02. Apr 18			Raghu
3	5	ABC05	$ 7.22	62	$ 447.64	02.Apr.2018	RT1	RT2	RT3	RT4	02. Apr 18			Raghu
4	9	ABC09	$ 741.99	101	$ 74,940.99	02.Apr.2018	RT1	RT2	RT3	RT4	02. Apr 18			Raghu
5	13	ABC13	$ 8.51	12	$ 102.12	02.Apr.2018	RT1	RT2	RT3	RT4	02. Apr 18			Raghu
6	17	ABC17	$ 11.99	1	$ 11.99	02.Apr.2018	RT1	RT2	RT3	RT4	02. Apr 18			Raghu
7	21	ABC21	$ 12.99	5	$ 64.95	02.Apr.2018								Raghu
8	25	ABC25	$ 333.45	99	$ 33,011.55	02.Apr.2018								Raghu

Worksheet: Tabelle1

**DocAElstein** · 04-02-2018, 03:16 PM

From last Post... master File After Distribition and before Consolidation
File: “zMasterBeforeConsolidation.xlsm”
https://app.box.com/s/818q2ev3owpini2202n3dqp3xxicfeif

S No	Item	Price	Qty	Total	Distributed	Task1	Task2	Task3	Task4	Completed	Consolidated	Comments	Team Member	Checked
1	ABC01	$ 55.00	22	$ 1,210.00	02.Apr.2018								Raghu
2	ABC02	$ 13.66	7	$ 95.62	02.Apr.2018								John
3	ABC03	$ 12.99	5	$ 64.95	02.Apr.2018								Greg
4	ABC04	$ 8.51	12	$ 102.12	02.Apr.2018								Margaret
5	ABC05	$ 7.22	62	$ 447.64	02.Apr.2018								Raghu
6	ABC06	$ 3.99	35	$ 139.65	02.Apr.2018								John
7	ABC07	$ 333.45	99	$ 33,011.55	02.Apr.2018								Greg
8	ABC08	$ 11.99	1	$ 11.99	02.Apr.2018								Margaret
9	ABC09	$ 741.99	101	$ 74,940.99	02.Apr.2018								Raghu
10	ABC10	$ 55.00	22	$ 1,210.00	02.Apr.2018								John
11	ABC11	$ 13.66	7	$ 95.62	02.Apr.2018								Greg
12	ABC12	$ 12.99	5	$ 64.95	02.Apr.2018								Margaret
13	ABC13	$ 8.51	12	$ 102.12	02.Apr.2018								Raghu
14	ABC14	$ 7.22	62	$ 447.64	02.Apr.2018								John
15	ABC15	$ 3.99	35	$ 139.65	02.Apr.2018								Greg
16	ABC16	$ 333.45	99	$ 33,011.55	02.Apr.2018								Margaret
17	ABC17	$ 11.99	1	$ 11.99	02.Apr.2018								Raghu
18	ABC18	$ 741.99	101	$ 74,940.99	02.Apr.2018								John
19	ABC19	$ 55.00	22	$ 1,210.00	02.Apr.2018								Greg
20	ABC20	$ 13.66	7	$ 95.62	02.Apr.2018								Margaret
21	ABC21	$ 12.99	5	$ 64.95	02.Apr.2018								Raghu
22	ABC22	$ 8.51	12	$ 102.12	02.Apr.2018								John
23	ABC23	$ 7.22	62	$ 447.64	02.Apr.2018								Greg
24	ABC24	$ 3.99	35	$ 139.65	02.Apr.2018								Margaret
25	ABC25	$ 333.45	99	$ 33,011.55	02.Apr.2018								Raghu
26	ABC26	$ 11.99	1	$ 11.99	02.Apr.2018								John
27	ABC27	$ 741.99	101	$ 74,940.99	02.Apr.2018								Greg
28	ABC28	$ 55.00	22	$ 1,210.00	02.Apr.2018								Margaret
29	ABC29	$ 13.66	7	$ 95.62	02.Apr.2018								Raghu
30	ABC30	$ 12.99	5	$ 64.95	02.Apr.2018								John
31	ABC31	$ 8.51	12	$ 102.12	02.Apr.2018								Greg
32	ABC32	$ 7.22	62	$ 447.64	02.Apr.2018								Margaret
33	ABC33	$ 3.99	35	$ 139.65	02.Apr.2018								Raghu
34	ABC34	$ 333.45	99	$ 33,011.55	02.Apr.2018								John
35	ABC35	$ 11.99	1	$ 11.99	02.Apr.2018								Greg
36	ABC36	$ 741.99	101	$ 74,940.99	02.Apr.2018								Margaret
37	ABC37	$ 55.00	22	$ 1,210.00	02.Apr.2018								Raghu
38	ABC38	$ 13.66	7	$ 95.62	02.Apr.2018								John
39	ABC39	$ 12.99	5	$ 64.95	02.Apr.2018								Greg
40	ABC40	$ 8.51	12	$ 102.12	02.Apr.2018								Margaret
41	ABC41	$ 7.22	62	$ 447.64	02.Apr.2018								Raghu
42	ABC42	$ 3.99	35	$ 139.65	02.Apr.2018								John
43	ABC43	$ 333.45	99	$ 33,011.55	02.Apr.2018								Greg
44	ABC44	$ 11.99	1	$ 11.99	02.Apr.2018								Margaret
45	ABC45	$ 741.99	101	$ 74,940.99	02.Apr.2018								Raghu