Description: Make all the data in the sheet change location by swapping Cell and Row numbers.
Parameters:
TransposeSheetData(sPathOriginal As String, sPathTarget As String, sSheet As String) As Long
|
Parameter |
Meaning |
|
sPathOriginal |
The source workbook file |
|
sPathTarget |
Can be the same as sPathOriginal, otherwise a new workbook is created |
|
sSheet |
Sheet in sPathOriginal whose data will be transposed |
Return Values:
0: Success
-3: Unable to create Excel Application. Is it installed?
-4: Unable to destroy Excel Application.
-200: Excel reported an error.
-201: Shareware Expired.
-208: Target Path folder does not exist, even after attempting to create it.
-213: Invalid or missing sheet specified.
Example Code: