Linking Word cells to Excel without DDE (or a solution to DDE issues)

%3CLINGO-SUB%20id%3D%22lingo-sub-1300044%22%20slang%3D%22en-US%22%3ELinking%20Word%20cells%20to%20Excel%20without%20DDE%20(or%20a%20solution%20to%20DDE%20issues)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1300044%22%20slang%3D%22en-US%22%3E%3CP%3EGot%20a%20specific%20question%20(or%20two)%2C%20and%20a%20more%20general%20one%20that%20isn't%20quite%20as%20important.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFirst%2C%20is%20there%20a%20way%20to%20link%20the%20contents%20of%20a%20Word%20cell%20to%20an%20Excel%20cell%20without%20using%20Dynamic%20Data%20Exchange%3F%20I'd%20need%20changes%20to%20the%20Word%20cell%20to%20update%20Excel%20--%20vice%20versa%20wouldn't%20hurt%2C%20but%20it's%20not%20required.%20Slapping%20a%20Word%20object%20in%20there%20doesn't%20seem%20to%20help%20me%20for%20my%20purposes%2C%20since%20it's%20not%20being%20entered%20into%20the%20cell%20--%20just%20in%20a%20floating%20object.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CEM%3EAlternatively%2C%3C%2FEM%3E%20is%20there%20a%20relatively%20easy%20way%20to%20use%20DDE%20links%20without%20having%20to%20entirely%20open%20up%20the%20permissions%20(which%20MS%20explicitly%20cautions%20against)%3F%20It%20worked%20like%20a%20dream%20when%20I%20first%20set%20it%20up%2C%20but%20now%20it%20keeps%20throwing%20errors%20saying%20it's%20unsafe%20whenever%20I%20try%20to%20open%20it%20again.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20for%20the%20general%20one%20--%20first%2C%20some%20background%3A%20My%20overall%20goal%20is%20to%20set%20up%20a%20user-friendly%20environment%20for%20creatives%20(e.g.%20not%20a%20spreadsheet)%20to%20store%20and%20showcase%20text%20and%20image%20assets%20for%20making%20social%20media%20ads%20--%20one%20that%20can%20either%20automatically%20update%20an%20Excel%20spreadsheet%20(a%20preformatted%20template%20supplied%20by%20the%20social%20network)%20or%20easily%20export%20said%20data%20with%20minimal%20complexity%20so%20they%20can%20be%20uploaded%20to%20the%20platform.%20I%20would%20use%20Access%20for%20its%20front-end%2C%20but%20this%20needs%20to%20be%20both%20Mac%20and%20PC%20compatible.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20my%20general%20question%20is%3A%20Is%20there%20a%20different%20tool%20in%20this%20suite%20that%20might%20suit%20my%20purposes%20better%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20so%20much%20for%20your%20help!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E(Also%2C%20I%20know%20the%20simplest%20solution%20is%20to%20simply%20use%20the%20social%20media%20network's%20platform%20to%20create%20the%20ads%20which%20avoids%20the%20upload%20issue%20entirely%2C%20but%20that's%20not%20an%20option%20in%20my%20situation.%20It's%2C%20uh%2C%20complicated.)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1300044%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Visitor

Got a specific question (or two), and a more general one that isn't quite as important.

 

First, is there a way to link the contents of a Word cell to an Excel cell without using Dynamic Data Exchange? I'd need changes to the Word cell to update Excel -- vice versa wouldn't hurt, but it's not required. Slapping a Word object in there doesn't seem to help me for my purposes, since it's not being entered into the cell -- just in a floating object.

 

Alternatively, is there a relatively easy way to use DDE links without having to entirely open up the permissions (which MS explicitly cautions against)? It worked like a dream when I first set it up, but now it keeps throwing errors saying it's unsafe whenever I try to open it again.

 

As for the general one -- first, some background: My overall goal is to set up a user-friendly environment for creatives (e.g. not a spreadsheet) to store and showcase text and image assets for making social media ads -- one that can either automatically update an Excel spreadsheet (a preformatted template supplied by the social network) or easily export said data with minimal complexity so they can be uploaded to the platform. I would use Access for its front-end, but this needs to be both Mac and PC compatible.

 

So my general question is: Is there a different tool in this suite that might suit my purposes better?

 

Thanks so much for your help!

 

(Also, I know the simplest solution is to simply use the social media network's platform to create the ads which avoids the upload issue entirely, but that's not an option in my situation. It's, uh, complicated.)

0 Replies