Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Renaming Sheets | Excel Discussion (Misc queries) | |||
Renaming multiple sheets | Excel Worksheet Functions | |||
copying and renaming sheets | Excel Programming | |||
Renaming Sheets in a workbook | Excel Programming | |||
renaming sheets | Excel Programming |