Stack Exchange
log in

jcbermu

 Discussion between jcbermu and Hiren …

Imported from a comment discussion on superuser.com/questions/...
jcbermu
Sep 14, 2018 07:39
Why did you put 192.168.0.2? I guess it should be 192.168.0.4.
jcbermu
Sep 13, 2018 12:58
I need a picture of the Virtual Server screen
jcbermu
Sep 13, 2018 12:56
@HirenGarai Please, update the router menu picture in your question with the actual state
jcbermu
Sep 13, 2018 12:56
@Hiren Go to https://www.whatismyip.com/ and get your public IP address, then go here, put the public IP address and the port and test. If it fails the problem is the router configuration
jcbermu
Sep 13, 2018 12:56
@HirenGarai User defined service name: Plex, Protocol: TCP, WAN Port: 32400, LAN Port: 32400, LAN Ip Address: 192.168.0.4
 

 Discussion on question by Fiksdal: Ho…

Imported from a comment discussion on superuser.com/questions/...
jcbermu
May 31, 2016 16:50
@Fiksdal Program a reboot of the computer.
 

 Discussion between jcbermu and Cain Nuke

Imported from a comment discussion on superuser.com/questions/...
jcbermu
Nov 5, 2015 13:21
It's possible but it will need to create a second column with the diffrence values, and modify the Sort line.
jcbermu
Nov 5, 2015 13:15
I know what it is ASAP utilities, but I have never used it.
jcbermu
Nov 5, 2015 13:14
keep in mind that the line that says
Application.EnableEvents = False
make the macro unaware of further changes.
At the end of the macro the line
Application.EnableEvents = True
reenable the event awareness.

In case of an error, I advised you to close the Workbook and open it again because it enables the event awareness.
jcbermu
Nov 5, 2015 13:11
Found it. The problem is the first column on Sheet 1. To ignore it change the line that says : thecolumn=1
to
thecolumn=2

In that way the calculations will be done from column 2 (B).
jcbermu
Nov 5, 2015 13:03
Downloaded, I'll check it
jcbermu
Nov 5, 2015 13:02
Megas is asking me that before downloading the file
jcbermu
Nov 5, 2015 13:01
It is asking me a key
jcbermu
Nov 5, 2015 12:59
Ok. Send me the file.
jcbermu
Nov 5, 2015 12:55
Well, use mine.
jcbermu
Nov 5, 2015 12:54
Is it working?
jcbermu
Nov 5, 2015 12:44
dropbox.com/s/mligz4tu2k0f3lc/sort_results.xlsm?dl=0
jcbermu
Nov 5, 2015 12:44
In Dropbox
jcbermu
Nov 5, 2015 12:36
No. Do you want me to send you my file, just to test ?
jcbermu
Nov 5, 2015 12:29
I don't know...
jcbermu
Nov 5, 2015 12:21
support.office.com/en-us/article/…
jcbermu
Nov 5, 2015 12:15
Is your Excel disabling macros by default?
jcbermu
Nov 5, 2015 12:14
I changed the code to easily reference to the sheets in the lines Set wks = wkb.Worksheets("Sheet1") and Set wks1 = wkb.Worksheets("Sheet2"). Paste the code, check that you put the code of the Workbook. Save, close, open again, activate macros and it should work.
jcbermu
Nov 5, 2015 12:14
It doesn't matter if Sheet 2is clear or not.
jcbermu
Nov 5, 2015 12:14
When you pasted the code, did you previously double clicked Sheet 1?
jcbermu
Nov 5, 2015 12:14
Change or add or remove a value on Sheet 1 and Sheet 2 will change.
 

 Discussion between jcbermu and KumarJohn

Imported from a comment discussion on superuser.com/questions/...
jcbermu
Jun 17, 2015 13:40
Great!!!
jcbermu
Jun 17, 2015 13:33
It's done. I changed it on the answer.
jcbermu
Jun 17, 2015 11:58
Ok. Ill try to solve it
jcbermu
Jun 17, 2015 11:58
Now I understand that there are no numbers on the titles.
jcbermu
Jun 17, 2015 11:55
Can you tell me how are the titles of the columns?
jcbermu
Jun 17, 2015 11:54
Ok
jcbermu
Jun 17, 2015 11:46
Can you tell me how are the titles of the columns?
jcbermu
Jun 17, 2015 11:46
Hello.
jcbermu
Jun 17, 2015 11:46
If there is not maching, it shows nothing. If text on column is like Rollno for example, change variable to_remove on the script.
jcbermu
Jun 17, 2015 11:46
I made a change to use the *title column` instead of a number
jcbermu
Jun 17, 2015 11:46
Takes the last character of variable column
 

 Discussion between jcbermu and tester…

Imported from a comment discussion on superuser.com/questions/...
jcbermu
Feb 20, 2015 11:19
You're welcome
jcbermu
Feb 20, 2015 11:18
It's more common in a place that hosts multiple services / servers and additional IPs gives them easy management of incoming traffic.
jcbermu
Feb 20, 2015 11:16
No in basic home / little company connections, because your ISP bills you an additional amount for that additional IP.
jcbermu
Feb 20, 2015 11:14
The other one is been used only as outgoing, so any outside request gets to nowhere (the blank page).
jcbermu
Feb 20, 2015 11:13
And one of them has been correlated to the domain name and the port 80 on the router.
jcbermu
Feb 20, 2015 11:13
Simply your ISP (Internet Provider) has provided you with two IPs
jcbermu
Feb 20, 2015 11:12
the ipecho.net test the outgoing IP, meanwhile DNSInfo tests the incoming
jcbermu
Feb 20, 2015 11:12
The connection to your Internet Ptovider has two IP addresses. One of them is used for incoming and the other one for outgoing
jcbermu
Feb 20, 2015 11:11
OK.
jcbermu
Feb 20, 2015 11:10
Are the two IPs on a close range or are they very different?
jcbermu
Feb 20, 2015 11:09
Has the CentOS server more than one interface?
jcbermu
Feb 20, 2015 11:05
What happens when you do a http:// x.x.x.x where x.x.x.x is an IP address? First use the public IP you found using ipcho.net and the the IP you found through dnsinfo
jcbermu
Feb 20, 2015 11:05
What happens when you do a x.x.x.x where x.x.x.x is an IP address? First use the public IP you found using ipcho.net and the the IP you found through dnsinfo