Thread: Open files with a variable name in a folder get name in B1 and sav
View Single Post
  #15   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones[_2_] Norman Jones[_2_] is offline
external usenet poster
  
Posts: 421
Default Open files with a variable name in a folder get name in B1 and
Hi Ron,

Thank you!

I too have now tried to rename network
files and the code worked as anticipated.

Given that Les has read / write permissions,
I cannot immediately see any reason for the
code to fail, but I shall think again!

Thanks again.


---
Regards.
Norman

"Ron de Bruin" wrote in message
...
Both are working for me in my private network Norman

MsgBox GetValue("\\LAPTOP_VAN_RON\Public\test", "Map1.xls", "blad1",
"A1")
MsgBox GetValue("C:\Users\Ron\Desktop\MSDN article", "Map1.xls",
"blad1", "A1")




--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

Reply With QuoteReply With Quote