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:
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
Bookmarks