ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Relative Path in Excel to a word document (https://www.excelbanter.com/excel-programming/417456-relative-path-excel-word-document.html)

Jorge mst

Relative Path in Excel to a word document
 
Hello

I have €œword document.docx€ and €œword document.docx€ in the same directory
and I need to put a small text of a €œword document.docx€ in a cell of €œexcel
document.xlsx€.
When I move my €œexcel document.xlsx€ to another directory, the cell have to
update to the text in the new €œword document.docx€ that is in the new
directory.

Anybody can help me?
Tanks in advance


Bob Bridges[_2_]

Relative Path in Excel to a word document
 
First, did you really mean that you have "excel document.xlsx" and "word
document.docx" in the same directory? If not, I don't understand what's
going on here.

But if that's what you meant to say, then I think it depends on how you're
moving "word.document.docx" to the new directory. If your Excel program
is doing the move, then your Excel program can know where to find the
word document in its new location. But if you're moving the word
document outside of the Excel program -- manually, for example, in
Windows -- then Excel has no way of knowing the target document's new
location; it'll simply have to report that the document isn't there.

Now, if you know WHERE you're going to move it, you can tell your program
to look for it there. But if you knew that, you probably wouldn't be asking
this question, is my guess.

--- "Jorge mst" wrote:
I have €œword document.docx€ and €œword document.docx€ in the same
directory and I need to put a small text of a €œword document.docx€ in
a cell of €œexcel document.xlsx€. When I move my €œexcel document.xlsx€
to another directory, the cell have to update to the text in the new
€œword document.docx€ that is in the new directory.



All times are GMT +1. The time now is 09:36 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com