Joined: Apr 26, 2006 Posts: 49 Location: Vancouver, BC
Posted: Wed Aug 01, 2007 3:34 pm Post subject:
rong wrote:
I think I have figured out the problem. It is obscure to say the least. I was able to link cell on one work book to another. However, when I made a formula things didn't work. It turns out that the file name I was linking to had a ' in the name. Erik's to be exact.
Ah. The single quote in the filename was being picked up as the end of the (quoted) link to the file instead of being read as a single quote character in the filename. You can escape a single quote with a backslash, e.g.
... and then that last quote mark will be read as the end of the link to the file. This works for me, anyway. Note that you don't have to escape any space marks in the path.
All times are GMT - 7 Hours Goto page Previous1, 2
Page 2 of 2
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You cannot attach files in this forum You cannot download files in this forum