Hi everyone Im trying to capture soem info contained in a document , the problem is that this doc. is protected and I only can introduce a name to obtain the info contained in that field , I want to know if there is any way to insert those names from other document using this macro:
For x=2 to 452
sheets("ctrl fin").cells(2,4)=(x,1)
sheets ("infopiv").cells(x,2)=sheets("ctrl fin").cells (40,14)
next x

as you can see this only works in the same document, is there any way to call that info from other document? tanxx