Trim a files name to a specific amount of characters using vba.

Please Login or Register  to view this content.

I marked the line where the name is changed. This line is taking a workbooks name and making it the worksheets name. However, the workbook is greater then 31 characters while a worksheet can only be 31 characters max.

Can someone show me how you limit or trim a name down to a specified amount of characters?

I know there is a trim and replace function but now how to use them in vba correctly.

Thank you.

Hi,

Can you make use of the left function?

Please Login or Register  to view this content.