Macro To Check Internal Ips
May 26, 2008
we have a network of small routers and wifi aps. The Ip range has got a bit out of control so I would like to be able to audit it every once and a while.
how I could go through a set of IPs on a spreadsheet, open a telnet session or whatever, try pinging each ip individually, paste a response or no response in the adjacent column then move to the next ip in the first column (some sort of loop).
Time is not too much of an issue as I could run this overnight if need be.
As a response, the macro could just copy the last line of the ping eg
Minimum = 7ms, Maximum = 9ms, Average = 7ms
if it responds
or
Packets: Sent = 4, Received = 0, Lost = 4 (100% loss)
if it does not respond
Example
Col1 col 2
Ip
1.2.3.4 Packets: Sent = 4, Received = 0, Lost = 4 (100% loss)
4.5.6.7 Minimum = 7ms, Maximum = 9ms, Average = 7ms
5.6.7.8 Packets: Sent = 4, Received = 0, Lost = 4 (100% loss)
6.7.8.9 Minimum = 3ms, Maximum = 21ms, Average = 9ms
etc
View 12 Replies
ADVERTISEMENT
Nov 27, 2009
My company uses 4 types of barcodes 8, 12, 13, & 14 number barcodes for our products my problem is that I can't figure out how to force the barcode to format properly no matter how somebody enters it if they don't use spaces or put them in the wrong spots, I can't use custom formats because there is 4 different layouts
8 digit should be "#### ####"
12 digit should be "###### ######"
13 digit should be "# ###### ######"
14 digit should be "# ## ##### ######"
these barcodes are in columns L, M, & N also right now 'm using a formula in another cell to verify the barcodes by calculating the check digit and comparing it to the check digit typed the formula i'm using is
View 9 Replies
View Related
Jul 28, 2006
I have numerous hyperlinks in cells on a worksheet, next to these I have checkboxes. I am looking for a macro that will check if the boxes are checked and if not ignore them and if so run a certain macro.
View 6 Replies
View Related
Mar 1, 2007
I update files monthly and save them each month with a new name (eg. Jan, Feb, etc.).
In the file I have a reference from one tab to another tab within the same file. So every time I re-save this file with a new name, it should still reference the cell in the other tab - same file.
BUT on 2 occasions this reference changed to an "external" reference to the previous month's file.
I've been doing this every month for over 2 years and this problem has only happened 2 times. I know others that have experienced this, but nobody knows what caused it.
Does anyone know what would cause this? The biggest problem is that I may not notice this has happened for a long time.
One other thing I might add. I use an older version of Excel (2000). I share these files with other people who may have newer versions (I'm not sure who has what). Can sharing these files with others over a network system have something to do with this? Can opening "read only" when someone else is in the file and then saving as a copy do this?
View 11 Replies
View Related
Aug 4, 2009
I need to create a new worksheet and control both the internal and tab names of the worksheet. The following code works to create the new sheet, and set the external (tab) name.
Sub AddAndRenameWorksheet()
Dim ws As Worksheet
With ActiveWorkbook
.Worksheets.Add Before:=Sheets(1)
.Worksheets(1).Name = "Schedules" 'changes the external name
End With
End Sub
I do not know how to set the internal name For example, I would normally go into worksheet Properties and change the (Name) property. Is there a way to do this in VBA?
View 9 Replies
View Related
Mar 3, 2007
I have the following rows in my excel sheet:
-Cash needed to start the quarter.
-Net cash position.
-Begining of the quarter debt owed.
-Internal repayment.
I am trying to develop a formula for internal repayment which must fulfill following requirements(Net cash position-cash needed to start the quarter),the remaining amount goes to internal repayment but that must be <=Begining of the quarter debt owed.
View 6 Replies
View Related
May 16, 2007
Please take a look at this sample spreadsheet.
[url]
I am trying to find out how to write a formula that will sum the values in one column if the value in a corresponding column is within a range. For example, if the item number in the first column is greater than 2 and less than 7, the sum would be 179. I believe this would be some type of SUMIF but I cannot write it.
View 3 Replies
View Related
May 23, 2014
I have a workbook that need to call for external data (this is information from January till May) from another workbook to manage it. I get this external data as a Tabla_A that needs to be updated continually because the extenal workbooks is adding information constantly. However, now i have to incorporate a specific range of old information (information of December, 2013) before the external data in the same Table_A. This last information wont ever change and needs to be incorporated to analize de information from December till Now.
The problem is when I insert the December information as new arrows at the beginning of Table_A, later I update the table and this old data is remplaced automatic by the external Data range. For that reason, I'm wondering to know if there is some way to have one Table_A with a static range of arrows (december) and another range of arrows (January onwards) that is updatable.
View 1 Replies
View Related
Aug 23, 2009
I'm trying to set up a direct link to the internal excel calculator, using a button in VBA. I have the shortcut on my own toolbar, but I have many users that use the workbook, and to get them all to set up is almost impossible, so I am trying to make it simple for them.
I've tried doing it through a hyperlink direct to the calc.exe file, but get a lot of messages popping up (that'll scare a few of them). So thought I would try and find the excel name for it and use VBA, but I cannot find it anywhere.
View 2 Replies
View Related
Feb 9, 2013
I have an Excel file that use an internal link from one worksheet to the next. When I click on the link, I'd like it to go directly to a print preview page so I can print that one page instead just switching to the other worksheet. Is this possible?
View 3 Replies
View Related
Feb 19, 2013
Can I set the conditional formatting to highlight those cells, which contain internal (not pop-up) cell comment?
For example =10+N("free text comment"). The displayed value is 10, and I need this cell to be highlighted automatically.
The sheet has over 200 columns, so functions based on other cell values are not applicable.
View 8 Replies
View Related
Aug 5, 2003
I have a little spreadsheet aplication which ran perfectly in Office 97, but since the move to Windows/Office XP, I get the message:
Solver: An unexpected internal error occurred, or available memory was exhausted.
I'm running a P4 2.26GHz with 512MB RAM.
My code is as follows:
Public Processing_Message As String, Macro_to_Process As String
Public StartTerm As Integer, StopTerm As Integer, StepTerm As Integer
Public ResultsLabelCount As Integer
Public myErrorFound As Boolean
Public rs As Object
Public ctl As Control
View 9 Replies
View Related
Nov 3, 2008
I'm trying to get a formula to show me the value of one cell based on the value of another to automate some internal processes. Cell J3 returns today's date, then J4 says what week number that is. J5 concatenates the two to make the look up. Column A is named range "PN", and columns C onwards are named ranges to match the column heading.
What I'm wanting is for the result in test cell 2 (J8), is to return the stock requirements for the current week, based on the result of cell J5. I can do this by using nested IF statements, but that would be 8 cells to calculate, then another one to find the cell that has a value. If there a way to get Excel to recognize the value in J5 as a range name, so it just needs the one formula?
View 3 Replies
View Related
Oct 16, 2013
I am having trouble creating a hyperlink to a place in the current document for a file stored on a network drive. My workbook has a lot of sheets (50 or so), so I created a 'Navigation' sheet that contains hyperlinks to all the worksheets located therein, and pasted a link back to the Navigation sheet in cell A1 on every tab.
Setting up these Navigation sheets has never a problem until I started posting the file on a network drive. As soon as I did that, I noticed that the internal hyperlinks on all sheets in the workbook would stop working after I closed the file in Excel. Note that this network drive is not set as a drive letter on my computer, and is only accessible by entering the server ip address in Windows Explorer.
An example address the hyper is trying (and failing) to open is: "file:///\ IP ADDRESS sub-folders activefile.xlsm"
I've tried a few options, using the HYPERLINK formula, using the HYPERLINK feature in the Insert ribbon, etc, but all to no avail.
View 8 Replies
View Related
Dec 29, 2006
I have a macro that does a solver routine. I have another macro that runs this solver, then copies and pastes new inputs, then runs the solver, then copies the results and pastes them somewhere, then copies new inputs, etc. It is a long process and it worked fine a few days ago. Now when I run it, about 90% of the way through and then excel crashes. The error says:
Solver: An expected internal error occurred, or available memory was exhausted.
What can I do?
View 9 Replies
View Related
May 14, 2014
Basically, what I'm dealing with is an inventory system. When a cell value reaches below a certain quantity, we have a cell light up with the word "YES" (under the "re-order" column). What I'd like to do is have a macro that checks to see if that cell is populated with "YES" and if it is, to run another macro (which I already have written) that sends out an email notifying us of the need to re-order.
How it would work: The person pulling out the inventory would fill out this form and click "Submit"
submitbutton.jpg
I would then have a "call" code tied to the "Submit" button that when clicked, would run the macro to check cell population and send out the email. The email code is already written and works flawlessly on it's own. I just cant seem to figure out how to write a macro that checks for cell value and then runs it (or not) based on that.
View 14 Replies
View Related
Feb 25, 2011
Is it possible to produce a list on a new worksheet of all sheet names and their their internal names within a workbook?
If so I would like the tabbed name's to begin in say A2 with the corresponding internal name in B2.
View 3 Replies
View Related
Nov 17, 2009
I'm at a point in the macro where I want to check a value.
Not sure how to write it.
Here's what I need.
If the value in B2
View 9 Replies
View Related
May 8, 2014
If I explain all the 8 steps , it will be lengthy and not easy to explain , thus I will go step by step
See file attached raw 01 , copy it on drive c directory called DISC , see file attached the result file
I want the the result file to go fetch data from the folder created DISC in which there is file called raw 01 and do the following with pulling headers , since the header is already plugged.
a to a
b to b
c to c
d is thus empty for the second step of the macro ( explain following after this fetching is achieved )
d to e
e to f
f to g
g to h
h to i
j to k
k it should not copy
View 5 Replies
View Related
Apr 13, 2006
I have a huge spreadsheet that has part numbers and quantity. I need to find the same part number and sum the quantity of that part number.
View 10 Replies
View Related
Jul 16, 2012
I have a button that runs a macro every 5 seconds.
I have another button to stop the loop.
Problem happens if a user hits the stop button when the sequence is not running - they get an error.
Here's my code for button 1 (start) and 2 (stop):
Code:
Sub Process_Emails_and_Backup_Auto()
Application.Run "Process_All_Emails_In_The_Inbox"
runtime1 = Now + TimeValue("00:00:05")
Application.OnTime runtime1, "Process_Emails_and_Backup_Auto"
End Sub
Sub StopProcessing()
Application.OnTime runtime1, "Process_Emails_and_Backup_Auto", , False
End Sub
Is there a way for button 2 - the StopProcessing macro - to run a test like If process is scheduled then run this code - if not then don't?
View 2 Replies
View Related
Sep 21, 2006
My macro for some reason is not working. I want it to delete every row that has FALSE in Column A. I don't know what is wrong.
Sub deleteFalse()
Dim I As Long, trufalse As Long
With ActiveSheet
trufalse = . Range("a65536").End(xlUp).Row
For I = trufalse To 2 Step -1
If .Range("A" & I) = "FALSE" Then
Rows(I).Delete
End If
Next
End With
End Sub
View 2 Replies
View Related
Jul 29, 2007
I have completed a formulation and included in a macro but I dont know about coding to check for specific cell string values before macro will take off. I want macro to check that if specific cell text are not matched, use MsgBox to display the wrong versus correct cell string text, then vbOK to exit macro. Also, if Range(B2:G2,J2) are completely blank, use MsgBox to display "missing data", then vbOK to exit macro.
cell B =REQ
cell C =SS
cell D =Current Stock
cell E =PO
cell F =Sales Order
cell G =In-coming
cell L =unit cost
If these cell texts (U or L case will do) are in their specific cells, macro will proceed. If either one or some of these cell texts are not matched, display MsgBox of the wrong and correct cell texts. Then button OK to stop macro run. If Range(B2:G2,J2) are completely blank, use MsgBox to display "missing data", then vbOK to exit macro.
View 3 Replies
View Related
Feb 12, 2008
I have designed a functioning userform which transfers the data (limited or complete) into the sheet. Along with the data and at the end of each row it automatically generates 4 checkboxes and links them to 4 offset cells.
This is where I hit a dead end. I am not sure which avenue is suitable or indeed possible. I want to click any checkboxes in the first COLUMN and as a result have it change the complete ROW colorindex of the background. I did achieve this with conditional formatting but it seemed to make the empty sheet bulking when saving and I cannot alter the font size which is another goal on the 3rd column of checkboxes. Am I waffling yet?
The 3rd column checkboxes I want to have the ROW font size drop to 3pt. The 2nd and 4th currently serve no purpose i.e. trigger nothing as a result.
I don’t think I can use the checkbox_click event as the boxes are generated for me so I don’t know which number they will be. The worksheet_change event and calculate event don’t seem to register when the linked cell goes to TRUE or back to FALSE. I tried using FORMS and CONTROLS checkboxes but neither has brought me success.
I was hoping the linkedcell would trigger an event and in turn select and manipulate the entire row in which the linked cell is located….
Due to my limited knowledge the code I have written/adapted to suit my needs may appear a little unorthodox? I hope that in itself is not a problem.
I have not managed to get the Controls Checkboxes to initalise blank. Currently they appear greyed out with a tick but fully usable? Of minor importance.
I can't attach the file because the blank sheet is 4.5MB?? so here is the main body of code from the userform. If you need anything else I will supply as required, however I can't get anyfiles under the attachment maximum of 48.8kb. My jpeg image was 108kb....
View 9 Replies
View Related
Aug 11, 2013
I did not want to bother you again but I have a problem that I can not solve it because my knowledge in vba etc, are limited and could not become to find with Macro Recorder.Usually I solve the problems on my own by searching on Google and experimenting with ready Macros and Macro Recorder.
I have an excel file with a macro and I want before this macro launched, to run another macro that can check if the headers have the correct name and in its correct position. The headers is in first Row.
If are not in the correct position or if it doesn't exist or if not have the correct name, then the process of the next macro be stopped and of course be informed that there is a problem.But if Is everything okay, then proceed to the next macro and be informed that Is everything okay.
I have attached a Sample file with the headers i'm using.
Sample...xlsm
[Code].....
View 5 Replies
View Related
Jan 22, 2014
I have a large spreadsheet that has thousands of hyperlinks that I would like to check periodically to make sure they are up to date. I have found dozens of examples of VBA code that will do this for me and seemingly very clear instructions on how to do it (for example this), but haven't yet been able to successfully run anything in my spreadsheet. It either doesn't do anything, or I get an error message of a bad file name.
View 2 Replies
View Related
Apr 19, 2009
I would like a macro to look through a sheet.
1. Unhide all Rows
2. Check through all cells in Row, If all cell values in row is either 0 or Empty then hide this row.
View 14 Replies
View Related
Jun 17, 2009
1 - If any cells (with data in it) in the "state" column contain any of the following abbreviations in it...
AB, BC, MB, PE, NB, NL, NS, NT, NU, ON, QC, SK, YT
Then all matching row cells in the column named "country" should say "Canada",
AND....(it must also meet this criteria)...
Criteria 2 - If any text in "Country" column is "Kryponite", AND "State" column is blank
If BOTH criteria 1&2 are met.....THEN...
then delete both the country & state columns
If not, keep both columns and highlight in light red any errors to this macro.
View 14 Replies
View Related
Oct 30, 2011
i have number of cells as below and i need to make macro to check last character in each cells if text the result will be 0 and if number the result will be 1
A1 42SRY239Acd2
View 9 Replies
View Related
Jul 19, 2012
I've been assigned to develop a workbook that autopopulates a different workbook but they wanted it so the second macro is never messed with and the information is only entered once. Here is the macro i developed
Code:
Sub Monthly()
Dim wbthis As Workbook
Dim wsthis As Worksheet, wsm As Worksheet
[Code]....
Now The area in red is where the macro writes into the form. My thing is that I want to set up a check so there isn't duplicated entries. This is how the check would work. First it would match up any excisiting entries with JobNo and then check to see if the JobDate was the same. If both are the same then it would check Waste or CutTime, either one would work. If they didn't match, then those cells would be overwritten. If nothing matched then it would put in the new entry.
View 1 Replies
View Related
