I was using something like this but once I changed 31 to 30 it worked fine.
// If str > 31 then it is passed to this function which returns the truncated string
Public Function truncName(ByVal name As String) As String
name = Mid(name, 1, 31) <-- Had to be changed to 30
truncName = name...
I am working on a project that consists of importing several CSV files into an Excel workbook, then for each worksheet creating custom charts based off the numerical data in the worksheet. Everything works fine until I encounter a CSV file with a name longer than 31 characters in which I use to...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.