Participant

Question

Link Excell to Photoshop

Forum|Forum|13 years ago
November 20, 2012
3 replies
3373 views

Hi All..

I'm really in trouble at work and need help on linking microsoft excell tables to photoshop.

I have some excell tables. I want to import them into photoshop (not as an image) that when i changed the values in cells (excell) i want the photoshop file to update.. Should i use a script or any programes? Please help me about it. It's really important to me..

Thanks already.

Actions and scripting

This topic has been closed for replies.

G

Ghoulfool

Inspiring

Could you not make do with exporting CSV files from excel to photoshop? This would be possible, but not instantly "live" as you suggest as it would have to wait for a re-export and a re-import for the values to change from Excel to photoshop.

Tom Ruark

Inspiring

I would get all the VBScript examples and study how the connection to Photoshop occurs. I would then get the VBA editor (that's what they used to call it) running from Excel and copy/modify the examples to connect to Photoshop. Then you could watch for cell changes to run those functions. I had a project that would control Photoshop from Excel so it is all doable. I had a button you pushed in Excel to run all my scripts from there and update the cells accordingly. You will have to look up documentation in Excel to figure out how to track cell changes to fire the scripts.

The VBScript examples for CS6 are here: http://helpx.adobe.com/photoshop/kb/plug-ins-photoshop-cs61.html#id_14532 and part of the ScriptingListener Plug-in download.

You will have to modify the scripts a bit as I belive that VBA wants all the Dim statements at the beginning of a function. It has been some time since I played inside of Excel.

Dim appRef

Set appRef = CreateObject( "Photoshop.Application" )

appRef.BringToFront

I

I MBixxxxx

Participant

Where can I find the documentation (Object Model Reference) for VBScript and Java Script?

M

Michael_L_Hale

Inspiring

Photoshop does not support linking so I agree with c.pfaffenbichler that it will not be easy. I also think that you would need to do the updating from the Excel side using VBS. You might be able to use VBA if the newer versions of Excel allow you to add a COM reference.

c.pfaffenbichler

Community Expert

I want to import them into photoshop (not as an image) that when i changed the values in cells (excell) i want the photoshop file to update.

I see no immediate easy possibility for that; you may still have to trigger a Script manually for the reloading the data from a tab or comma-separated file.

It might be possible to use Script Events Manager to check for a csv file when opening the psd file (or even at other events when the file is open), but that seems inadvisable to me.

Have you read the Help chapter »Creating data-driven graphics« yet?

What is this about anyway (as far as you may divulge the issue without violating confidentiality anyway)?

Hi All..

I'm really in trouble at work and need help on linking microsoft excell tables to photoshop.

I have some excell tables. I want to import them into photoshop (not as an image) that when i changed the values in cells (excell) i want the photoshop file to update.. Should i use a script or any programes? Please help me about it. It's really important to me..

Thanks already.

I want to import them into photoshop (not as an image) that when i changed the values in cells (excell) i want the photoshop file to update.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded