Hi
Im trying to simplify a task in excel, and i need to copy text from cell A “purple” and paste this inn cell N m:\path\to\picture\server\purple.jpg
cell A2 contains: “purple”
cell N2 is empthy and ends up with: m:\path\to\picture\server[b]purple[/b].jpg
cell A3 contains: “blue”
cell N3 is empthy and ends up with: m:\path\to\picture\server[b]blue[/b].jpg
cell A4 contains: “black”
cell N4 is empthy and ends up with: m:\path\to\picture\server[b]black[/b].jpg¨
I have the copy from cell to cell giong, but how do i insert my clippboard betwene "server/ and .jpg
Help please?
Belatedly, to my mind, this is better suited to applescript than automator but assuming that your workflow already has the workbook open and the worksheet active, then you could probably add a ‘run applescript’ action which contains the following applescript code.
on run {input, parameters}
tell application "Microsoft Excel"
tell active sheet of active workbook
set lString to "m:\\path\\to\\picture\\server\\"
set rString to ".jpg"
set aRg to range "A2:A4"
set nRg to range "N2:N4"
repeat with x from 1 to count of cells of aRg
set value of cell x of nRg to lString & value of cell x of aRg & rString
end repeat
end tell
end tell
return input
end run
There isn’t likely a need to use the clipboard for this type of task. Just determine the strings —note that each backslash in the path requires its own backslash— and then loop through the ranges to assemble the final strings and place them into the appropriate cell.
What happens with each cell is this:
[format]set value of cell 1 of range “N2:N4” of active sheet of active workbook to “m:\path\to\picture\server\purple.jpg”[/format]