Replies

Hello Hans,

It seems to work correctly after I changed to following lines:

strOld = wshList.Range("A"  & r)
strNew = wshList.Range("B"  & r)

You used the brackets in your code, but then you are replacing the file name and not the foldername
Thanks again for your help

Cool Hans,

Thank you very much for your effort.
I will give it a test.

Hans,

Yes, there is a pattern to te movement. It is possible to create a sheet with old en new locations just by foldernames.

Thanks Hans,

Luckely 70% of the movements will be relative, but 30% will move to other locations.
Is it possible for those 30% to use a macro to correct the links?

Cool Hans,
Quick answer and it is working (ofcourse)

Steve,

Thanks for the reply.
I have made sure “Personeel” is the active sheet, I also tried your code line, it does not work
I will prepare a examplesheet tomorrow and post it

extra info:

Well if the code is not showing the correct sheet, that is no so bad, I can live with it.
But the strange thing is that I can not unprotect the sheet by code

Sheets(“Personeel”).Unprotect Password:=strWW

the programm is running this line, giving me no error and on the next line:

Range(“P1”).Value = “aangepast”

(this time a manuly made shure the active sheet is the correct one) Excel is giving me a 1004 error telling me that the cell is protected.
In de VBA editor I print the value of strWW, copy it and manuely unprotect the sheet, by pasting the strWW value… it works

Why is the code not working????

Thanks in advance for your reaction.
Patrick Schouten

Thanks Jan Karel,

You saved me a lot of time.

greetings,

Patrick Schouten
Meander Medisch Centrum

Hello Andrew,

I just saw what date the message had.
I was just looking for the same kind of problem and saw yours…..

Hello Andrew,

I that user using Word as Email editor and is the setting for hyperlinks in AutoCorrection, Autoformat disabled?

Thanks hans,

I searched the database, but problably not with the correct words.
I’m happy… have a nice weekend

Hello Sam,

I see your point here. You are right.

Hi Sam,

Sorry for the confusion, on my name Silfaar where two different replys, most from my, but one from my brother (the chemist) Olaf. He will not use my name anymore.

He told me, that for his problem the macro will work by setting caps on the third letter, because he is not using the unnamed elements. But you are right about those elements.

Well, lets try an other sollution, Put a space between every element so the macro knows where a element name starts and ends and let the macro remove the space.

Hello all,

I was just thinking (may I should do sometine else but…)
Is it not so that the letters combinations of ONE element could only be 1 or 2 characters, that means that if there is a third character this one should always be caps?

question, (btw I’m the chemist who asked my brother (siflaar) to ask you the question about the chemical formula marco. OK enough about that….

What if the formula is silicium fluorine that is SiF??
I will type sif and the macro turns it in Sif which is not correct??
please respond…….
Olaf.