Results 1 to 2 of 2

Changing macro localisation permamently

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-18-2017
    Location
    Poznań, Poland
    MS-Off Ver
    2016
    Posts
    139

    Changing macro localisation permamently

    Hi,

    I am facing a little problem with the connection my macros to the original file.

    1. I created the file on my "C:" drive
    2. When it was all settled down I transferred it to the common drive in my organisation "U:"
    3. One of thing that my macro does is to change a new workbook and saves it in the specific location.
    4. The new created workbook also contains macro which is the part of the original workbook and that macro can be enabled by clicking the right button. The problem is that this new created file refers to the original path of the workbook "C:\Urlopy" instead of the new path of the workbook U:\Urlopy

    I did not copy the original file to the new localization. I cut it and pasted it. So there is no file like that in the original localization.

    The question is:
    How can I change localisation of the macro? The problem also attached.
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Changing a Macro to search using a range instead of specifying the data in the macro
    By devildawg in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-19-2014, 02:12 PM
  2. Replies: 0
    Last Post: 10-22-2013, 01:04 PM
  3. Replies: 2
    Last Post: 01-28-2013, 05:40 AM
  4. Localisation of Range Names
    By Chris Gorham in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-02-2006, 11:30 AM
  5. Replies: 1
    Last Post: 04-20-2006, 09:45 AM
  6. [SOLVED] Localisation decimal problems
    By Mats Samson in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-18-2006, 11:30 AM
  7. [SOLVED] Localisation problem??
    By Mats Samson in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-16-2006, 04:25 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