VBA Macro created hyperlink problem

I have a macro which creates folders, saves current workbook into created folders and anchors hyoerlinks to those folders into specific cells.
when i run the macro for the first saving, it runs perfectly. When i run the macro for the second saving, it again works. However after creating second one when i click on the first hyperlink it does not work.

i realized that adress of the first hyperlink changes when i create second hyperlink. what can be the reason for this? any ideas?

ew03,

Could you share the code?

[]'s

I ran into some VBA hyperlink related problems the other day. I found out that deleting hyperlink (or the entire cell content, I don't remember which) before and adding a new worked better than trying to change address and stuff. I can look it up tomorrow if no one else solves it until then.

Jacc
I am not trying to change the existing cell, i am creating a new hyperlink in a different cell. This is some kind of archieve i am trying to create

here is my code

Please Login or Register  to view this content.