Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
You are subscribed to this thread Changing reference between sheet
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...- jirkax
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
You are subscribed to this thread Changing reference between sheet
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"...- jirkax
- Thread
- Replies: 3
- Forum: VBA Visual Basic for Applications (Microsoft)
