Microsoft Excel to Next Capture Name

Suguru Kaibara

• 27. Februar 2020 09:58

Simple question using Apple Script.
Can somebody know the way to achieve this??
What I would like to apply is below.

Copy the text in the selected cell on Excel file.
Then paste onto the next capture name (job name) of Capture One session.

Many thanks.

0

• 

  Eric Valk

  • 28. Februar 2020 17:12

  If you select a cell with the jobname in Excel, this should work
  
tell application "Microsoft Excel" to set jobName to get value of active cell
tell application "Capture One 12" to tell current document to tell next capture settings to set status job identifier to jobName
  For me the Excel value is correctly retreived, but the status job identifier is not updated and I don't get any error message.
  
  Could be because I don't have a camera tethered and I don't have tethered shooting set up.

  0
• 

  Rick Allen

  • 9. März 2020 09:03

  
tell application "Microsoft Excel" to set jobName to get value of active cell
tell application "Capture One 12"
tell current document
set {capture counter, capture name, capture name format} to {0, jobName, "[Name]-[4 Digit Counter]"}
end tell
end tell

  
  to omit the counter reset
  
  set {capture name, capture name format} to {jobName, "[Name]-[4 Digit Counter]"}
  
  I think status job identifier refers to IPTC metadata fields.

  0
• 

  Joseph Clark

  • 1. Juni 2022 14:07

  Hello! Is it possible to achieve this result when working with a google sheet and not excel?

  0

Post ist für Kommentare geschlossen.