So, my promles is:
I have more then 10000 xls files and I must change reference between them, because of moving this files to another disk location.
Because of count of files, I use rutine to change that references.
So i can't use clasic sheet code sheet to set up some simple event on each...
Hi,
I have a serious problem. When I want to change reference between cells in two excel files. I set cell formula reference to a non existing name of sheet (='c:\apps\[Sesit11.xls]l5'!$A$1) (sheet l5 doesn't exist in file sesit11.xls). After change confirmation of cell formula, "Select sheet"...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.