Brief & descriptive as possible.
I have formatted the naming of inspection photos in a manner in which contains details to be populated within a spreadsheet pertaining to their location. I'm trying to use a set of code that takes segments of the file name, transfers them into their respective cells (e.g.- columns labeled address, job number & serial number) from a designated folder & automates population of cells from a list of commonly encountered issues.
Is there a way to instantly delimit the results of this formula (listed below)? It is the only piece of the puzzle I have been able to find so far. . .for instance, if I could use the results of this formula as a reference & automate the portioning & the distributing of resulting text within the ranges needed, I would have accomplished my goal, but I just don't know much about VBA. Is there anyway to accomplish this? Thanks in advance for any contribution.
=SUBSTITUTE(CELL("filename"),RIGHT(CELL("filename"),LEN(CELL*("filename"))-FIND("@&quo*t;,SUBSTITUTE(CELL("filename")*,"\","@",LEN(CELL(&q*uot;filename"))-LEN(SUBSTITUTE(CELL*("filename"),"\",&qu*ot;"))),1)),"*")
I have formatted the naming of inspection photos in a manner in which contains details to be populated within a spreadsheet pertaining to their location. I'm trying to use a set of code that takes segments of the file name, transfers them into their respective cells (e.g.- columns labeled address, job number & serial number) from a designated folder & automates population of cells from a list of commonly encountered issues.
Is there a way to instantly delimit the results of this formula (listed below)? It is the only piece of the puzzle I have been able to find so far. . .for instance, if I could use the results of this formula as a reference & automate the portioning & the distributing of resulting text within the ranges needed, I would have accomplished my goal, but I just don't know much about VBA. Is there anyway to accomplish this? Thanks in advance for any contribution.
=SUBSTITUTE(CELL("filename"),RIGHT(CELL("filename"),LEN(CELL*("filename"))-FIND("@&quo*t;,SUBSTITUTE(CELL("filename")*,"\","@",LEN(CELL(&q*uot;filename"))-LEN(SUBSTITUTE(CELL*("filename"),"\",&qu*ot;"))),1)),"*")
