Excel spreadsheet has 2 parts of directory path

It would help if you posted the actual error message you're getting. There's a surprising amount of detail in there, if you know how to read it. At the very least it would identify what data your script is trying to work with.

It would also help to show your source data so we can understand what you're working with.

From what I can see, you're trying to build a directory path. However, nowhere in your script is files_source defined. Either that's an error in your script, or there's more to your script that you haven't posted.

Other than that, your structure doesn't make sense - presumably since you've been editing and commenting/uncommenting parts to try to get different things to work.

Most notably, your line:

set target to (files_source & theItem & ":" as string)

is doomed to fail, not only because files_source is undefined (see above), but so is theItem since that's your list iterator that is currently empty:

repeat with theItemintheList

end repeat

Also, and a major contributor to your problem, may be the way Excel returns the value of a range.

Assuming that you have 50 rows in your database, the command:

set theList to get valueofrange ("A2:C" & rc) as list

will return a list of 40 items - one per row - where each item is itself a list of three values corresponding to the three columns in the range.

To extract the specific values from this, you need another level of indirection.

Finally - and this is the kicker - target is a reserved keyword in the Finder's dictionary (it's a property of a window), so you're running into dictionary term conflicts.

Here's a reworked version of your script that might help get you straight:

tell application "Microsoft Excel"

tell active sheet

tell used range

set rc to count of rows

end tell

set theList to get value of range ("A2:C" & rc) as list

logtheList

end tell

end tell

tell application "Finder"

repeat with theItem in theList

set colA to item 1 of theItem

set colB to item 2 of theItem

set colC to item 3 of theItem

set target to (colA & ":" & colB & ":" as text)

logtarget

-- other commands go here

end repeat

end tell

tell application "Finder"

set target to "FileData:GPS_VAN_Jobs:Amazon Fresh:5000234-01"

Result:

You need the full path to the data. This isn't. This will get you to your home folder:

Use the log statement for debugging. I put a log statement after about every assignment statement.

(* 

It is easier to diagnose problems with debug information. I suggest adding log statements to your script to see what is going on.  Here is an example.


    Author: rccharles
    
    For testing, run in the Script Editor.
      1) Click on the Event Log tab to see the output from the log statement
      2) Click on Run

 *)


on run
    -- Write a message into the event log.
    log "  --- Starting on " & ((current date) as string) & " --- "
    --  debug lines
    set desktopPath to (path to desktop) as string
    log "desktopPath = " & desktopPath
end run

To a fellow sunflower; good work.

R