Results 1 to 1 of 1

Deactivate links when workbook saved by different name

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-04-2008
    Location
    West Calder, Scotland
    MS-Off Ver
    365
    Posts
    430

    Deactivate links when workbook saved by different name

    Good Morning Folk

    I have a workbook which is saved by a different name using the code below, this works well with no issues. One of the sheets in the book contains links to another workbook. Is it possible to deactivte these links after the workbook is saved under its new name

    Sub save_report_C()
    
    Dim saveas As String
    saveas = Range("F3")
    
    ChDir "C:\Compliance Information\H&S\Audit Reports\"
    ActiveWorkbook.saveas Filename:= _
    "C:\Compliance Information\H&S\Audit Reports\" & saveas
    
    
    End Sub
    Many thanks for your help

    JT
    Last edited by JamesT1; 10-01-2013 at 03:53 AM. Reason: Spelling

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Lost links if saved as new version
    By peri1224 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-03-2010, 11:22 AM
  2. Excel saved as webpage - change links font color when clicked?
    By Elegidos in forum Excel - New Users/Basics
    Replies: 0
    Last Post: 10-14-2009, 05:00 PM
  3. Replies: 2
    Last Post: 11-14-2006, 09:04 AM
  4. Values In Links Not Being Saved
    By MDW in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-28-2006, 01:35 PM
  5. How can I see a copy of a saved workbook before I saved it again?
    By Norma in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-11-2005, 06:06 AM

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