Tricky-Need to populate multiple cells with text from file name of photos. Xl2010/Win7


New Member
Aug 24, 2014
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.


Forum statistics

Latest member

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...