Replacing Range Names
 

I have several .xls files based originally on a template file.
The RangeNames currently assigned in these several files
need to be totally-replaced with the current range names
in my RevisedTemplateFile.xlt file.

How can I accomplish this?

TIA,

Jim

Replacing Range Names
 

Get hold of the latest version of Jan Karel Pieterse's Namemanager, I
believe this versions supports renaming.

http://www.jkp-ads.com/OfficeMarketPlaceNM-EN.asp

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Jim May" wrote in message
...
I have several .xls files based originally on a template file.
The RangeNames currently assigned in these several files
need to be totally-replaced with the current range names
in my RevisedTemplateFile.xlt file.

How can I accomplish this?

TIA,

Jim

Replacing Range Names
 

Thanks Bob, but I was looking for a VBA solution.
Jim

"Bob Phillips" wrote:

Get hold of the latest version of Jan Karel Pieterse's Namemanager, I
believe this versions supports renaming.

http://www.jkp-ads.com/OfficeMarketPlaceNM-EN.asp

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Jim May" wrote in message
...
I have several .xls files based originally on a template file.
The RangeNames currently assigned in these several files
need to be totally-replaced with the current range names
in my RevisedTemplateFile.xlt file.

How can I accomplish this?

TIA,

Jim