+ Reply to Thread
Results 1 to 1 of 1

populating location matching with computername when excel file is opened

  1. #1
    Forum Contributor
    Join Date
    02-19-2013
    Location
    UK
    MS-Off Ver
    Excel 2019
    Posts
    677

    populating location matching with computername when excel file is opened

    Hi all,
    This solution is given by Izandol and works perfectly.
    Please refer to http://www.excelforum.com/excel-prog...ith-table.html

    I now want to find out if we can populate computername when excel file is opened, then
    Compare the computer number with its location from table
    Then populate this location in the inputbox heading like “your location is XYZ"
    Sample file is attached
    Is it possible??

    many thanks
    Kind regards
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How to set a Global Macros so that it gets opened every time an excel file is opened?
    By pericopericone in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-09-2013, 05:53 AM
  2. Splash screen in file opened by VBA hinders further processing of opened file.
    By Rod38 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-08-2012, 09:53 AM
  3. Replies: 0
    Last Post: 06-30-2011, 09:53 AM
  4. stop excel file opened as read only if already opened by another u
    By bobm in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-09-2011, 08:45 AM
  5. [SOLVED] How can I print the username or computername from excel?
    By YesNo in forum Excel General
    Replies: 1
    Last Post: 03-09-2005, 03:48 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1