+ Reply to Thread
Results 1 to 2 of 2

SaveAs, i don't want to overwrite and IF condition

  1. #1
    Registered User
    Join Date
    08-06-2014
    Location
    Italy
    MS-Off Ver
    2013
    Posts
    2

    SaveAs, i don't want to overwrite and IF condition

    Hi everyone....
    First, i'm very new to macros.. and to programming in general..
    Second, i'm italian and i am very basic with english, so.. be patient..
    i have some trouble writing this, imho, simple macro...

    i have in a folder, 2 workbook
    in WB1, column A is a list
    WB2, we can call it a "template"

    my idea is to open WB1, select a cell, then launch the macro
    which save a WB2 copy (in Folder2) with a name from the selected cell, then make an hyperlink to link the cell to the new WB(WB3)..
    First of all, check if the "WB3" already exist, if exist, DO NOT overwrite, but hyperlink.
    If do not exist, open WB2, save as, then hyperlink

    i came up with this:

    Please Login or Register  to view this content.
    Problems:

    It Works.. but
    if the file exist will be overwritten ( and i don't want it) then, it makes a hiperlinked cell in WB2 too (and i don't want it)

    then, i would need another macro doing the same job, with all the cells on column A without selecting them one by one..

    thank you in advance
    Last edited by disturbed87; 08-06-2014 at 04:03 PM.

  2. #2
    Registered User
    Join Date
    08-06-2014
    Location
    Italy
    MS-Off Ver
    2013
    Posts
    2

    Re: SaveAs, i don't want to overwrite and IF condition

    There's any suggestions?

+ 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. Need a formula or macro to solve problem with different percentages
    By prdsrain in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-05-2013, 11:32 AM
  2. Please Help to solve this issue using MACRO's
    By rpriyadharsini1987 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-02-2013, 12:59 AM
  3. pls solve this, need excel macro
    By sujithy007 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-03-2012, 02:01 AM
  4. Help required to solve rounding problem with macro
    By sarath25 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-31-2011, 05:36 AM
  5. Solver does not solve when called from a macro
    By mjd918 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-19-2006, 10:55 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