Computer IP Address

Mar 10, 2006

I have a problem running an excel macro on different laptops because the IP needs to be known (my program links to databases that are installed on a "server" laptop). The IP can be sourced by using the "Start, Run, cmd, ipconfig" but my users can have problems with process.

Does anyone know of a vb function that will display the ip of the computer that the code is run on?

View 9 Replies


ADVERTISEMENT

Using Macro To Find Email Address In Address Book Of Outlook

May 22, 2014

I am struggling to find a macro which can look at a name in column 'BT' and search it in the address book of Outlook to then place the email address of that person in column 'ED'

There are 35,000+ people in the address book and there may be over 5 email addresses for one name, so is there any way a message can appear for the user to select which email address is correct if there is more than 1 contact for that name?

View 1 Replies View Related

Need To Pull Street Address Out Of Full Address In A Cell

May 20, 2014

Assume the following list of addresses are all in separate cells of a single column (A1-A4). I just need the formula to extract the street addresses, and then a separate formula to extract the zip codes.

5430-44 PASCHALL AVENUE PHILADELPHIA, PA 19143 OPA/BRT#: 884350845

4010 MARPLE STREET PHILADELPHIA, PA 19136 OPA/BRT#: 651087200

2618 SOUTH HOWARD STREET PHILADELPHIA, PA 19148 OPA/BRT#: 391251216

5737 WOODCREST AVENUE PHILADELPHIA, PA 19131 OPA/BRT#: 522155600

View 2 Replies View Related

Split Address Which Is In Single Column Which Contains First / Last Name And Address Without Any Comma?

Apr 24, 2013

I have a list for addresses in excel in single column as shown below - aanandhi narayanan 3430 chemin de riviere sanjose,CA95148

DOMINIC ABANO 3838 GLENGROVE WAY SAN JOSE, CA 95121

abdi abdi 5390 monterey rd #6 sanjose,CA95111

Sheribel Abinsay 3212 Gateland CT San Jose, Ca 95148

I need the result to be in a way like -

3430 Chemin de riviere
San Jose
CA
95148

3838 Glengrove way
San Jose
CA
95121

5390 monterey rd#6
San Jose
CA
95111

3212 Gateland CT
San Jose
CA
95148

I have around 12000 records with the same format.

View 9 Replies View Related

Get Email Address From Global Address Book In Outlook

Feb 25, 2014

On a worksheet called "Contact Info" column A starting in row 2 I have a list of names (variable length). In Columns B2-D I need the email address, work phone number, and cell phone number.

View 5 Replies View Related

Get Computer ID

Mar 5, 2008

Is there a code available that can be used to get the user's computer ID number (Not Computer Name)? I'm using a password generator to randomly generate a password and I would like to use this unique password with the user's Computer ID.

View 9 Replies View Related

Macro To Get Computer ID

Jun 28, 2007

a macro to get the computer ID of the computer where the excel file is opened?

View 9 Replies View Related

Overflow On One Computer But Not On The Other

Sep 8, 2007

i am experiencing runtime error '6': overflow on one computer but not on another computer when it is the exact same file running on two different computers.

View 9 Replies View Related

Formula To Get The Name Of My Computer?

Apr 5, 2008

Is there a code or formula to get the name of my Computer?

View 9 Replies View Related

Return The Name Of Computer

Jan 15, 2003

Is there any way to return the name of the computer in Excel using VB?

View 9 Replies View Related

Assign Computer ID

Feb 9, 2009

Does anyone have a macro that could assign a 16-digit number, seperated by dashes, to a computer? (i.e. Computer ID: xxxx-xxxx-xxxx-xxxx)

View 9 Replies View Related

Scale Differs From One Computer To Another

May 9, 2014

Here's the scenario. A co-worker and I access the same file from the same online database and download it in the same manner. We have the same version of excel. We then open these identical files, we run a formatting macro (identical), but when it comes time to set the page breaks in order to get the items to print on the same page I have to increase a columns width to make it fit on one page and yet it still doesn't match theirs. It appears to have a different scale but I'm not sure of the option difference between our machines. I don't know how it could be the printer since it physically gives her different page break option than what mine does.

View 1 Replies View Related

Formula Working In One Computer But Not On Another?

Jan 5, 2013

I have a Age calculating formula in an excell cell, which calculates the age as on another date.
The forumala is =IF(E4="","",IF($C$1="","",ROUNDDOWN(($C$1-E4)/365,0))) where E4 is the date of birth and C1 is the date in which I want the age calculated to be.

The above formula works very well on my computer, but does not on any other computer. If I access it from my sent items or from a shared drive, it works perfectly on mine, but not on any other computer!!! I get a #value error message on all other computers.

I have tried the foll:
If i enter =ISNUMBER(C1) where the age has to be calculated, I get #Name?
If I enter =ISNUMBER(E4), i get TRUE

The above is on the sheet where it does not work ( on others computer ) and i get TRUE for both on mine. Also both have the same date formats and same time zones...

View 10 Replies View Related

Transfer Macros To Another Computer?

Jul 8, 2014

I am having trouble with transferring a Macros to another computer. I have saved and sent the file via e-mail as a .xls and .xlsm to no avail and tried other methods of transferring the macros to the other computer. Also No I cannot copy paste the coding information to the other computer since there are multiple macros buttons since they are add one item and subtract one item from separate rows for inventory at a warehouse (about 100+ rows x 2 = about 200+ macros buttons).

View 1 Replies View Related

Identify A Specific Computer

Sep 9, 2009

I have few macros that I use to reconfigure a particular workbook into a sort of "developer mode". I keep them in a text file that I can paste them from when I'm working on it and then delete them before I send it out to other people.

I'd like to be able to script them so they only run if the workbook is open on a specific machine (namely mine). Is there any way to identify the specific computer a spreadsheet is being run on?

View 2 Replies View Related

Save Icons From One Computer To Another?

Sep 11, 2009

I want to transfer my Excel-icons. Some of them are custom buttons where I have added user-defined functions. Is there any way I can do this? A list of icons with their function or purpose is OK as well.

View 4 Replies View Related

Formula Works On One Computer But Not Another

Nov 12, 2009

I have a odd problem. I have workbook that I made I placed this formula in cell A1

View 3 Replies View Related

VBA Code Not Working On Another Computer?

May 22, 2013

I have made a program using excel vba with userforms, however upon using it on another or any computer with the same version of Office(2007) i am getting a debugging error and highlighting any lines with the words "format" & "date" in the vba code.

View 3 Replies View Related

Subscript Out Of Range With New Computer

Jul 22, 2014

I created a code and I just changed computer. The code that was working perfectly fine on my previous laptop is no longer working now.

Workbooks.Add
ActiveWorkbook.SaveAs Filename:= _
"C:UsersUserDocumentsBCB MANAGEMENTBankArchiveData_TenantsData_Tenants_" & Left(strDate, 8) _
, FileFormat:=xlOpenXMLWorkbook, CreateBackup:=False
Set wbData = Workbooks("Data_Tenants_" & Left(strDate, 8))

When it reaches Set wbdata it says subscript out of range. I'm not sure how it cannot recognise the spreadsheet I just created and that is open and working.

View 5 Replies View Related

How To Get To A Computer On Our Network Using Code

Jan 29, 2007

I have code below that works well most of the time. One of the cases below will not work. It insists on requiring a name and password.

(note: it is the only Windows 2000 operating systems)

I want to enter this in my case line to automatically add the username and password.

Let's say the username is: "dave" and the password is: "happy"

How can I add this to this part of the code?

Case "DJ"
strfilename = "\DAVEJONESDavesProposals" & strfilename

Sub Save_and_SaveSalesman()

Dim strPath As String, strPath2 As String, CurrPath As String

Dim WB1 As Workbook
Dim WB2 As Workbook

View 9 Replies View Related

Spreadsheet Load To Another Computer All I Get Is #VALUE

Apr 17, 2008

Using some custom VB code to put the filename of the document into a cell.

I save the spreadsheet and load it up on another computer and all I get is #VALUE.

How do I fix this so its loaded on every machine without problems? (Multiple people will be using these sheets)

View 9 Replies View Related

How To Restrict A W/b To A Specific Computer

Oct 14, 2008

I've a workbook (XL 2003) test-1.xls, and I need to restrict it to a specific computer with ID: my-a1234567k

(shown under ControlPanel::System::Computer Name::Full computer name).

Is it possible to code such restriction in the w/b Open() event to prevent opening the w/b on a different computer?

My computers each has a different OS (Win 2000, Win XP Home, Win XP Prof ), different Excel version (XL 2000, 2003, 2007), etc., and the majority of my workbooks have been developed and would work only in certain environment (e.g.; in XL 2003 only, or XL 2007 only, ... ).

View 9 Replies View Related

Multiple Versions - One Computer

Feb 13, 2009

I'm running Excel 2007 with Windows Vista. I also have Excel 97, which I was told would not run with Vista. I've since discovered that many programs that I was told wouldn't run with Vista seem to work fine.

Is it possible to install Office 97 on the same machine with Office 2007?

View 9 Replies View Related

Module Runs On One Computer But Not On Another

Aug 12, 2009

I wrote some code that runs with no problem on my computer as well as another coworkers computer, but will not work on a 2nd coworker's computer. The "subscript out of range" error shows up at the point when the EMInput worksheet in the EMInput workbook is copied to the new workbook called "Out of Plane Section Cuts" (SEE BELOW). Is there an option in EXCEL or somewhere that could affect this. I don't see why you would get a subscript out of range error since the EMInput workbook is open....

View 9 Replies View Related

Listing Files From Your Computer

Apr 16, 2004

I am attempting compile a list of files from my computer into a spreadsheet but I am not sure how to get the list in the first place--I have searched many, many websites and everyone directed me here...

View 9 Replies View Related

Hyperlinking Info From Another Computer

Jul 1, 2006

In my restaurant we have a master computer upstairs that collects all of the register sales info. Then we have a computer downstairs that my employees sign in and out on.

This excel timesheet keeps track of the amount of labor hours being used per day. Is there a way of doing this without putting the timesheet on a web page or putting my sales info on a web page?

View 4 Replies View Related

Changing Computer Date

Jul 21, 2006

I have a form to imput a date but the problem is that it changes the computer date aswell. Is there another code i can use? Im using CDate code.

Private Sub CommandButtonProceed_Click()
Sheet2.Cells(2, 57) = TextBoxInitials
Cells(1, 2) = TextBoxSiteName
Cells(2, 2) = CDate(TextBoxDate)
Date = Cells(2, 2)
Sheet2.Cells(3, 28) = TextBoxPlant1
Sheet2.Cells(3, 31) = TextBoxPlant2
Sheet2.Cells(3, 34) = TextBoxPlant3
Sheet2.Cells(3, 37) = TextBoxPlant4
Sheet2.Cells(3, 40) = TextBoxPlant5
Sheet2.Cells(3, 43) = TextBoxPlant6
Sheet2.Cells(5, 27) = ExtractElement(Date, 3, "/")
Unload Me
DataImput.Show
End Sub

View 6 Replies View Related

Macro Does Not Run On Different Computer In Same Network

Jan 20, 2007

I wrote a macro that runs perfect when started from my pc, but if started from a different ps which is logged into the same network it doesn't run, also the macro is stored on the server. I have a code in the private section of the workbook:

Private Sub Workbook_Open()
Call FINAL
End Sub

then the macro 'FINAL' is stored in the 'Modules' section and starts with:

Sub FINAL()
'this part opens the Edit/Links dialog from which the user has to choose the relevant model
Dim Which_financial_model_contains_the_data As String
ActiveWorkbook.ChangeLink Name:= _
"T:DEALSSSalsa (Project)Financial modelsProject Salsa Model - BASED ON SPONSOR CASE - b - 20061214.xls" _
, NewName:= _
"Which_financial_model_contains_the_data" _
, Type:=xlExcelLinks

View 6 Replies View Related

Populate Cell With Computer Id

Mar 3, 2007

is it possible to populate a worksheets cell on opening a workbook with the idenification of the computer opening the workbook?

View 4 Replies View Related

Pasting Freezing Up Computer

Mar 28, 2007

Here is my code. When it pastes it takes so long my comp freezes up. How do i fix? ....

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved