-
If you would like to post, please check out the MrExcel Message Board FAQ and register here.
If you forgot your password, you can reset your password.
hostname
-
Function to convert IP Address to Hostname (64 bit)
Good afternoon - since our upgrade to Win 10/Office 2016 64 bit, a lot of my functions, including those to extract IP addresses from HostNames and vice versa no longer work (no surprise there, then) Even when I add PtrSafe to my existing functions that worked in Win7/Office 2010 32 bit, the...- NewOrderFac33
- Thread
- bit extract function functions hostname
- Replies: 11
- Forum: Excel Questions
-
S
How to find position of certain value within group
Not sure my title is aligned with what I am trying to accomplish. So apologies. I have a table with a column Source HostName (Column G) and for each Source HostName there could 1 to many attempts in migrating that Host. When migrating that host, we either have a 'Success' or 'Error' Status...- sadonnie
- Thread
- full hostname migration source success
- Replies: 3
- Forum: Excel Questions
-
B
Change Value In Workbook from Outlook Macro
So I have a Macro that Opens an Attachment, and saves it in a shared drive location. After it saves I need to change the value of A1 to "Hostname" Set objApp = CreateObject("Excel.Application") objApp.Visible = False Set wb =...- Benzula
- Thread
- change false hostname saves set
- Replies: 0
- Forum: Excel Questions
Watch MrExcel Video
This Week's Hot Topics
-
Excel VBA Parse Column A into multiple columns help but with conditions
- Started by BalloutMoe
- Replies: 56
Hello, I have a TXT file that gets imported in excel and it always ends up in column A. I am trying to split the data up however. The middle... -
Data with Different score
- Started by sksanjeev786
- Replies: 30
Hi Team, I have a Wave 2 and Wave 1 data and need different only if we have any letter in Column A and B in Column D for example i have kept data... -
Looping a macro through all visible sheets?
- Started by GlennJ
- Replies: 29
I have a macro that does exactly what I need. I just need it to do the same thing to all sheets. Any help would be appreciated. [CODE=vba] Sub... -
Loop through Column, looking for an array of values, If NOT found, delete entire row
- Started by blbat
- Replies: 29
So I tried to modify some good code from Joe4, but ran into some walls. I'm trying to modify his working loop to cycle through Column "D", find... -
VBA to extract values starting with specific character
- Started by sncb
- Replies: 21
Hi all, I paste two cells of data into A1 and B1 with different formats and spacing like below and I need to extract only those values that start... -
macro/vba fix for not a blank, blank in Go To Special
- Started by LorettaAlsop
- Replies: 20
I am writing vba code (thru using macros) to format a ws. In a portion of the formatting I identify the blank cells and replace them with the cell...
