renaming copied worksheets deleting .xls]

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am coping existing worksheets needing to rename weekly tabs.
The wkshts copy over using a .xls] name.
I cannot remove this to save properly.
Any help would be appreciated.
Thanks!
 
Close excel
open windows explorer
Find that file.

I bet you have a [ or ] in the name of the file.

Rename the file to get rid of any/all those characters.

Then back to excel to test it out!
I am coping existing worksheets needing to rename weekly tabs.
The wkshts copy over using a .xls] name.
I cannot remove this to save properly.
Any help would be appreciated.
Thanks!
Click to expand...
 
dhl said:
I am coping existing worksheets needing to rename weekly tabs.
The wkshts copy over using a .xls] name.
I cannot remove this to save properly.
Any help would be appreciated.
Thanks!
Click to expand...

How are you copying the worksheets?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vlookup Function with multiple worksheets 6
copy cell from file with variable name 1
rename worksheet tabs 2
Renaming worksheet on the basis of workbook name 2
Variable to rename a tab in a worksheet via VBA 5
Macro recorded... tabs & file names changed, macro hangs 3
Making part of a formula a variable 1
VB file renaming. 2

Back
Top