+ Reply to Thread
Results 1 to 4 of 4

Correct Vba By Macro

  1. #1
    Registered User
    Join Date
    10-01-2013
    Location
    spanish fork
    MS-Off Ver
    Excel 2010
    Posts
    11

    Correct Vba By Macro

    I have a huge quantity of workbooks that access another workbook and use a "modular" macro to print specic pages inside a work book, check and correct some other links...

    anyway the location of the workbook moved due to IT issues.

    is there a way to write a macro to change the VBA from:


    Please Login or Register  to view this content.
    To:

    Please Login or Register  to view this content.
    So that the users can make there own corrections.

    Moderator's note: Please review forum rules. Rule #3 requires CODE tags around VBA code. I have added them since it's your first post. --6SJ
    Last edited by 6StringJazzer; 12-18-2013 at 04:05 PM. Reason: code tags

  2. #2
    Registered User
    Join Date
    04-18-2013
    Location
    North Carolina
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Correct Vba By Macro

    You need to reference the excel file's full path...not the mapped drive it's located in.

  3. #3
    Registered User
    Join Date
    10-01-2013
    Location
    spanish fork
    MS-Off Ver
    Excel 2010
    Posts
    11

    Re: Correct Vba By Macro

    The buttons work as shown I need to learn how to delete the \New G Drive out of the upper illistration by macro.

  4. #4
    Registered User
    Join Date
    10-01-2013
    Location
    spanish fork
    MS-Off Ver
    Excel 2010
    Posts
    11

    Re: Correct Vba By Macro

    I don't believe there is a way to alter a macro by macro I found a couple of instances where i came close but Excel shut me down I think it is protecting itself from Virus/hackers.

    Anyway i found a workaround i recreated my worksheet where the buttons attached to it pointed to the correct location then made a macro to import the sheet into the workbook and transfer any information previously contained on that sheet and then delete the old one-- worked out good Maybe better I changed a couple of colors on the sheet so it would be very visual if it needed updated.

+ 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. Replies: 1
    Last Post: 09-17-2012, 09:35 AM
  2. Fix Needed for Code to Send Correct Data to Correct Sheets
    By swordswinger710 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-04-2012, 03:53 PM
  3. Correct way to end a macro
    By dagindi in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-17-2010, 03:00 PM
  4. Please help correct this macro! :)
    By ninpo1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-08-2006, 03:39 PM
  5. Please correct my macro
    By famdamly in forum Excel General
    Replies: 5
    Last Post: 03-05-2006, 04:45 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