Multi tool use

Clash Royale CLAN TAG

Connection Word --> Excel with VBA

I'm currently working on a project within my company to create a link between Word and Excel. There are different cells in excel which should be visible in word. These cells need to be updated in Word whenever they change in Excel. I know, this isn't much of a problem because MS office does support this by creating a link between those two files. This works fine but the problem is all the documents are stored in a CRM system called Efficy.

A person who works for efficy created a tool so the two documents which need to be linked are opened simultaneously in a folder. The folder is called for example "Test folder - 21001".

The name of the folder changes per project in the CRM system. So if i open another project it will be called "Test folder - 21002" for example.

Is it possible to create a link between Word and Excel which is always the current folder of the Word document? The excel file always have the same file name. The only problem is that it is placed in another folder everytime by the CRM system.

Thanks in advance,
Tom

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.