Thanks a lot for your help & time Norman, much appreciated. I'm off home now,
18h15pm here now.. :-0)
--
Les


"Norman Jones" wrote:

Hi Les,

Our last two posts crossed with each other!

Your ability manually to rename a file from
the network folder confirms your permissions.

As indicared earlier (and then confirmed by
you), the code works without problem on a
local folder.

I have not tested the code on a network
folder and it will be his evening, before I
shall have the opportunity to do so.

If it transpires that there is an insuperable
problem to thr use of John Walkenbach's
GetValue function, I will post alternative
code.


---
Regards.
Norman


"Les" wrote in message
...
Hi Norman,

I do have read and write access, but not "Full Control"

The error is in the statement below

' Execute an XLM macro
GetValue = ExecuteExcel4Macro(arg)
--
Les


"Norman Jones" wrote:

Hi Les,

In faqct, if your error is encountered in the
function, the renaming of the file is not
immediately pertinent to your problem'

Do you have full access, read and write
permissions for the network folder of interest?



---
Regards.
Norman

"Norman Jones" wrote in message
...
Hi Les,

==========
Hi Norman, it works perfectly on the "C" drive, but mine are on the
network.

I am assuming it needs something extra ??
==========

Are you able to rename any of the network
files of interest manually?


---
Regards.
Norman