Note: these same steps can also be used to access cells in files whose names are created dynamically. Use the INDIRECT() function to access the CellPathName that you created in step #4. Use the LEFT function to extract the full path name of the directory that contains your current file.Ĭoncatenate the directory path name found in step #3 with the name of the file, the name of the worksheet, and the cell reference that you want to access. Use the SEARCH() function to find the start of the SheetName string of your current excel file and the sheet. Use the CELL("filename") function to get the full path to the current sheet of the current file. I had a similar problem that I solved by using the following sequence:
0 Comments
Leave a Reply. |