I am using the excel get worksheet.vi in the report generation toolkit to set my current worksheet. With the vi, you can either use the workshee index or the worksheet name to set the current worksheet. Sometimes, using worksheet name doesn't work. Why is that? I am certain that I type in the correct worksheet name. Has anyone expereienced that problem before?
I've only seen this with incorrect name, most of the time a invisible character like a space at the end. I now use the trim whitespace function to make sure there is no such character. You can also check "limit to single line" when you right-click on the input name string control, you can then avois to have a hidden line.