5 Attachment(s)
Finding and deleteing .exd files
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.
:(
Master File After First Consolidation
Using Excel 2007 32 bit
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 |
RT1 |
RT2 |
RT3 |
RT4 |
02.04.2018 |
02.Apr.2018 |
|
Raghu |
|
2 |
ABC02 |
$ 13.66 |
7 |
$ 95.62 |
02.Apr.2018 |
JT1 |
JT2 |
JT3 |
JT4 |
02.Apr.2018 |
02.Apr.2018 |
|
John |
|
3 |
ABC03 |
$ 12.99 |
5 |
$ 64.95 |
02.Apr.2018 |
GT1 |
GT2 |
GT3 |
GT4 |
02.Apr.2018 |
02.Apr.2018 |
|
Greg |
|
4 |
ABC04 |
$ 8.51 |
12 |
$ 102.12 |
02.Apr.2018 |
MT1 |
MT2 |
MT3 |
MT4 |
02.Apr.2018 |
02.Apr.2018 |
|
Margaret |
|
5 |
ABC05 |
$ 7.22 |
62 |
$ 447.64 |
02.Apr.2018 |
RT1 |
RT2 |
RT3 |
RT4 |
02.04.2018 |
02.Apr.2018 |
|
Raghu |
|
6 |
ABC06 |
$ 3.99 |
35 |
$ 139.65 |
02.Apr.2018 |
JT1 |
JT2 |
JT3 |
JT4 |
02.Apr.2018 |
02.Apr.2018 |
|
John |
|
7 |
ABC07 |
$ 333.45 |
99 |
$ 33,011.55 |
02.Apr.2018 |
GT1 |
GT2 |
GT3 |
GT4 |
02.Apr.2018 |
02.Apr.2018 |
|
Greg |
|
8 |
ABC08 |
$ 11.99 |
1 |
$ 11.99 |
02.Apr.2018 |
MT1 |
MT2 |
MT3 |
MT4 |
02.Apr.2018 |
02.Apr.2018 |
|
Margaret |
|
9 |
ABC09 |
$ 741.99 |
101 |
$ 74,940.99 |
02.Apr.2018 |
RT1 |
RT2 |
RT3 |
RT4 |
02.04.2018 |
02.Apr.2018 |
|
Raghu |
|
10 |
ABC10 |
$ 55.00 |
22 |
$ 1,210.00 |
02.Apr.2018 |
JT1 |
JT2 |
JT3 |
JT4 |
02.Apr.2018 |
02.Apr.2018 |
|
John |
|
11 |
ABC11 |
$ 13.66 |
7 |
$ 95.62 |
02.Apr.2018 |
GT1 |
GT2 |
GT3 |
GT4 |
02.Apr.2018 |
02.Apr.2018 |
|
Greg |
|
12 |
ABC12 |
$ 12.99 |
5 |
$ 64.95 |
02.Apr.2018 |
MT1 |
MT2 |
MT3 |
MT4 |
02.Apr.2018 |
02.Apr.2018 |
|
Margaret |
|
13 |
ABC13 |
$ 8.51 |
12 |
$ 102.12 |
02.Apr.2018 |
RT1 |
RT2 |
RT3 |
RT4 |
02.04.2018 |
02.Apr.2018 |
|
Raghu |
|
14 |
ABC14 |
$ 7.22 |
62 |
$ 447.64 |
02.Apr.2018 |
JT1 |
JT2 |
JT3 |
JT4 |
02.Apr.2018 |
02.Apr.2018 |
|
John |
|
15 |
ABC15 |
$ 3.99 |
35 |
$ 139.65 |
02.Apr.2018 |
GT1 |
GT2 |
GT3 |
GT4 |
02.Apr.2018 |
02.Apr.2018 |
|
Greg |
|
16 |
ABC16 |
$ 333.45 |
99 |
$ 33,011.55 |
02.Apr.2018 |
MT1 |
MT2 |
MT3 |
MT4 |
02.Apr.2018 |
02.Apr.2018 |
|
Margaret |
|
17 |
ABC17 |
$ 11.99 |
1 |
$ 11.99 |
02.Apr.2018 |
RT1 |
RT2 |
RT3 |
RT4 |
02.04.2018 |
02.Apr.2018 |
|
Raghu |
|
18 |
ABC18 |
$ 741.99 |
101 |
$ 74,940.99 |
02.Apr.2018 |
JT1 |
JT2 |
JT3 |
JT4 |
02.Apr.2018 |
02.Apr.2018 |
|
John |
|
19 |
ABC19 |
$ 55.00 |
22 |
$ 1,210.00 |
02.Apr.2018 |
GT1 |
GT2 |
GT3 |
GT4 |
02.Apr.2018 |
02.Apr.2018 |
|
Greg |
|
20 |
ABC20 |
$ 13.66 |
7 |
$ 95.62 |
02.Apr.2018 |
MT1 |
MT2 |
MT3 |
MT4 |
02.Apr.2018 |
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 |
JT1 |
JT2 |
JT3 |
JT4 |
02.Apr.2018 |
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 |
MT1 |
MT2 |
MT3 |
MT4 |
02.Apr.2018 |
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 |
MT1 |
MT2 |
MT3 |
MT4 |
02.Apr.2018 |
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 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Working Examples 2b) -B- Cloud P2P remote access if you know the password and username of Sannce register
This is post #51 in Thread.
Links
https://excelfox.com/forum/showthrea...ll=1#post15937
https://excelfox.com/forum/showthread.php/2769-P2P-Cloud-DVR-remote-Access-via-a-(remote)-PC-Using-Guarding-Vision-PC-Client-Software?p=15937&viewfull=1#post15937
https://excelfox.com/forum/showthrea...age6#post15937 https://excelfox.com/forum/showthread.php/2769-P2P-Cloud-DVR-remote-Access-via-a-(remote)-PC-Using-Guarding-Vision-PC-Client-Software/page6#post15937
These are shortened summarised notes of specific worked examples. Missing information can be found in full detail in the main previous notes.
Example of 2b) -B- Cloud P2P remote access if you know the password and username of Sannce registered account holding DVR P2P relevant information
Main Thread notes: https://excelfox.com/forum/showthrea...ll=1#post15918
A fairly new standard Windows 10 PC
I installed the software, Gaurding Vision, from a personal stored .exe file
An icon appeared as expected. https://i.postimg.cc/V6mq3PGg/Icon-a...s-expected.jpg - I double clicked on it, which brought me the usual warning asking me if I wanted to let the program do what it wanted to do. I clicked yes
By the first launch I get a window to [FONT=Courier New]Register Administrator [/FONT ]. https://i.postimg.cc/N018Jj4L/Regist...ftware-run.jpg I can use any name and password which must not be, ( but can be ), that used on any other computer. It is only used to get access to the software client on this particular computer. For convenience and ease of remembering, I use the same name and password that I have been using throughout all tutorial work. Furthermore, I check the box to Enable Auto.login, just for convenience,
https://i.postimg.cc/VNyBWCX3/Regist...inistrator.jpg
DocAElstein
Gaudy.!*
Note that both the username and password are case sensitive.
I get offered a help wizard in first use. So far I have always ignored this, https://i.postimg.cc/T35Jb95V/Ignore-Help-wizzard.jpg and close it
A couple of things we note on this fist GUI view, is
_ We just two Main Tabs, Control Panel and Device Management https://i.postimg.cc/PrRMNcJf/First-GUI-view.jpg
¬ _ We are currently looking at Device Management, and by default a Device has been added. It goes by the name of simply Device , which is a bit misleading, as really this is indicating the simple local LAN type device ( our way (ii) in previous discussions ). We should think more logically that we have just the options , Upgrade Server and + Add New Device type: Effectively on opening the software has automatically clicked on + Add New Device type and made a device type of the simple way (ii) LAN local PC access
We want a P2P device type, so we
_ click on + Add New Device type , and select a Cloud P2P device https://i.postimg.cc/Hsx2YHpP/Add-Ne...2-P-Device.jpg
https://i.postimg.cc/8kw4gsV6/Cloud-P2-P-Device-OK.jpg
Which causes the device type to appear, https://i.postimg.cc/kGjvQYyc/Cloud-...pe-appears.jpg but its not actually selected, ( we are still looking at any locally connected Devices ). So we click on the Cloud P2P Device
https://i.postimg.cc/L54VZFj5/click-...ype-window.jpg
in the Device Type left window. Now the Cloud P2P Device in the Device Type left window becomes highlighted and some processing is done,
https://i.postimg.cc/Kz2fxMzn/clicke...ype-window.jpg
https://i.postimg.cc/htXprn67/Processing-is-done.jpg
after which we are prompted to login. Important at this point is to select first the land in which our DVR is, https://i.postimg.cc/3wp1sBK8/Prompt...ember-land.jpg , after which select Login
https://i.postimg.cc/WzSX91s0/Login.jpg
To now login, we need to know the password and username of Sannce registered account holding DVR P2P relevant information. So we add this information and then hit login. ( The username is not case sensitive, but the password is )
Some processing is done https://i.postimg.cc/htXprn67/Processing-is-done.jpg , and if successful, a small black window bottom right appears to indicate the success, and the Device Name and Serial No. of our DVR appears
https://i.postimg.cc/Y9z39CGT/Importing-succeeded.jpg ,
At this stage we are in Device Management but have finished managing the device.
So now we hit the View tab at the top, https://i.postimg.cc/wBs46zkd/View-Main-View.jpg
( and thereafter we will have a large View Tab added )
https://i.postimg.cc/4xyFSV7y/Main-View.jpg
We are finished at this point.
I am not too clear on what all the various view setting mean, but usually some random clicking around on the various View and Camera options will bring the thing into life. In particular, clicking refresh symbols seems to help get things going.
https://i.postimg.cc/nVK5jHfF/Refresh-Symbol.jpg , https://i.postimg.cc/15JjBJzb/Refresh-Symbol.jpg , https://i.postimg.cc/3JKq2P3g/Refresh-Symbol.jpg
