How do I specify a sheet within a excel workbook i.e. I would like to do a dderequest on a data on one of the worksheets of the workbook in excel.

Abate

how do i remove trailing spaces returned from a value I am getting from an excel cell using dderequest. Is there a special character other than space that I need to use to remove these trailing spaces. Because when I tried to use blank space to remove them Macro Schedule doesn't recognize them. In t...

the dderequest return variable i get from excel retrieves only the first digit i.e if the value in the cell is 10 it retrieves 1 instead of 10. It drops the 0. Is there something I need to do to get the whole 2 digits.