Discussion:
Transpose Data in an Excel Sheet using VBScript
(too old to reply)
t***@hotmail.com
2006-08-01 20:53:13 UTC
Permalink
I'm creating an Excel sheet using VBScript in an ASP page. The data I
am pulling from a back end SQL Server table. I need to take the data
that is in the table and transpose it in the Excel sheet. Is there a
VBScript equivilant for the following (which is from a VBA macro)



Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone,
SkipBlanks:= _
False, Transpose:=True

I am able to choose which cells I want, but I am not able to transpose
them the way that I would like.

Please Help!!!!

Thanks

TJD
Babu VT
2006-08-02 10:24:28 UTC
Permalink
Hi,

Try this,

objExcel.Range("A19").PasteSpecial -4163,-4142,False,True

rgds
Babu
Post by t***@hotmail.com
I'm creating an Excel sheet using VBScript in an ASP page. The data I
am pulling from a back end SQL Server table. I need to take the data
that is in the table and transpose it in the Excel sheet. Is there a
VBScript equivilant for the following (which is from a VBA macro)
Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone,
SkipBlanks:= _
False, Transpose:=True
I am able to choose which cells I want, but I am not able to transpose
them the way that I would like.
Please Help!!!!
Thanks
TJD
t***@hotmail.com
2006-08-02 17:06:44 UTC
Permalink
That did the trick!!! Thank you very much!!!!
Post by Babu VT
Hi,
Try this,
objExcel.Range("A19").PasteSpecial -4163,-4142,False,True
rgds
Babu
Post by t***@hotmail.com
I'm creating an Excel sheet using VBScript in an ASP page. The data I
am pulling from a back end SQL Server table. I need to take the data
that is in the table and transpose it in the Excel sheet. Is there a
VBScript equivilant for the following (which is from a VBA macro)
Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone,
SkipBlanks:= _
False, Transpose:=True
I am able to choose which cells I want, but I am not able to transpose
them the way that I would like.
Please Help!!!!
Thanks
TJD
Loading...