Renaming sheets
 

I use the macro "Testfile(6)" form http://www.rondebruin.nl/copy3.htm.
It copies the first sheets coorrect. The macro also should rename the sheet
the same as the workbook name.
Some names are correctly renamed, others not.
What causes this and how can I fix it?

--
Kind regards
Adri

Renaming sheets
 

Hi Adri

Can you give example

If the name already exist the on error will avoid a error
and the sheet will not be named for example

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Adri" wrote in message ...
I use the macro "Testfile(6)" form http://www.rondebruin.nl/copy3.htm.
It copies the first sheets coorrect. The macro also should rename the sheet
the same as the workbook name.
Some names are correctly renamed, others not.
What causes this and how can I fix it?

--
Kind regards
Adri

Renaming sheets
 

Hello Ron,
The sheets taht are not renamed correctly get names like rapp(15), rapp(16).
The files in the directory have all different names. I copy in a workbook
with only one sheet. In my opinion the name can't already exist.
Adri

Ron de Bruin wrote:
| Hi Adri
|
| Can you give example
|
| If the name already exist the on error will avoid a error
| and the sheet will not be named for example
|
|
| "Adri" wrote in message
| ...
|| I use the macro "Testfile(6)" form
|| http://www.rondebruin.nl/copy3.htm.
|| It copies the first sheets coorrect. The macro also should rename
|| the sheet the same as the workbook name.
|| Some names are correctly renamed, others not.
|| What causes this and how can I fix it?
||
|| --
|| Kind regards
|| Adri

Renaming sheets
 

Can you send me a test workbook Adri

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Adri" wrote in message ...
Hello Ron,
The sheets taht are not renamed correctly get names like rapp(15), rapp(16).
The files in the directory have all different names. I copy in a workbook
with only one sheet. In my opinion the name can't already exist.
Adri

Ron de Bruin wrote:
| Hi Adri
|
| Can you give example
|
| If the name already exist the on error will avoid a error
| and the sheet will not be named for example
|
|
| "Adri" wrote in message
| ...
|| I use the macro "Testfile(6)" form
|| http://www.rondebruin.nl/copy3.htm.
|| It copies the first sheets coorrect. The macro also should rename
|| the sheet the same as the workbook name.
|| Some names are correctly renamed, others not.
|| What causes this and how can I fix it?
||
|| --
|| Kind regards
|| Adri

Renaming sheets
 

Ron de Bruin wrote:
| Can you send me a test workbook Adri
|
I find the solution. The length of the files that did not rename well, were
bigger then 31 signs.
I renamed them and everything went ok.
Thanks,
Adri

Renaming sheets
 

Thanks for posting back

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Adri" wrote in message ...
Ron de Bruin wrote:
| Can you send me a test workbook Adri
|
I find the solution. The length of the files that did not rename well, were
bigger then 31 signs.
I renamed them and everything went ok.
Thanks,
Adri