March 10, 2006 at 10:50 am
I'm working on an ActiveX script in DTS that does some editing to an Excel sheet before importing it into SQL. I have successfully created a formula to parse the date from the title in row 1 into a new column (requires a formula). I have selected the range and have it copied but I don't know how to use the PasteSpecial method in the ActiveX script. It's not the same as in VBA.
For example - what would normally have been
Set myRange2 = Range(myRange, myRange.End(xlDown)) needs to be written as Set myRange2 = myworksheet.Range(myRange,myRange.End(4)) - the 4 apparently being equivalent to fill down (figured this out by trial and error, 3 is xlUp).
Anyhow...I'm thinking that Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False requires a similar change but can't figure it out.
Can't find any help by googling...
TIA!
Erin
March 13, 2006 at 8:00 am
This was removed by the editor as SPAM
March 13, 2006 at 8:41 am
Not to worry - figured it oout...if anyone is interested - this is what I had to do...
myRange3.PasteSpecial(3) (the 3 is apparently equivalent to Paste values - couldn't find any documentation on this though).
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply