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


ADVERTISEMENT

VBA Slow To Assign A Null String To A Cell - On One Computer Only

Feb 11, 2009

I have a VBA program which is running very slowly on one of my computers, but none of the others.

Here's a piece of code which illustrates the problem, which is that assigning a null string to a cell is very slow.

Option Explicit
Public Sub test()
Dim objSh As Worksheet
Dim I As Integer

Set objSh = Worksheets("Sheet1")
MsgBox "test1"
For I = 1 To 1000
objSh.Cells(1, 1) = ""
Next
MsgBox "test2"
For I = 1 To 1000
objSh.Cells(1, 1) = " "
Next
MsgBox "done"
End Sub

If I change this to assign a space instead it is very fast (about 1,000 times faster).

This slow machine is not normally slow; an ACER Aspire 9410Z with 2GB RAM, running Vista Ultimate.

Other machines run this code OK on a mix of Windows XP, 2000 and Vista Business. with Excel 2003, 2000 and 2007.

Ultimate seems to be the only unique factor of the machine where it runs slowly.

View 9 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

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 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

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

Computer Game Database

Jun 30, 2007

I want to make a computer game database with excel, but do not know how to start..

i want to be able to enter the name, publisher, year, system and genre i.e.

Name ? A Game
Publisher ? Pub
Year ? i would like a drop down menu to choose the year
System ? as above
Genre as above

Also i would like to be able to add a screenshot of the game if that is possible

View 3 Replies View Related

Update Open Worksheet From Different Computer

Jul 8, 2014

Is it possible to update open worksheet which would stay open from different computer without doing anything to it.

View 8 Replies View Related

Strange Thing Only On One Computer Running This XLS

Feb 4, 2009

Copy of the scaled down Workbook are enclosed. Password is "j". Sheet("Final Schedule") is one of 11 sheets in the Workbook. Range("a10: BE120") is copied from another Sheet and pasted.

ISSUE BACKGROUND: Entries into cells are Data Validation and a drop down on each cell. In cells C15, 16, 17, 18 or O15, 16, 17, 18 First time the Sheet is opened: user has no problem if they select a D from the drop down.

ISSUE:
But if user types in D and hits enter key, contents of G10: M10 (merged cells) is copied into that cell. Any thoughts on where to check or what settings to check? It only happens on that one computer.

View 3 Replies View Related







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