Excel "Range copy and paste"

[redrum]

Hello,

I have been trying to use the Excel copy/paste type VB statements within AuotIt to move data between blocks of cells, using the following type statements:

$oExcelDP.Range(Cells(9, 3).Address, Cells(12, 7).Address).copy destination:=$oExcelDP.Range(Cells($BDrow+1, 2).Address, Cells($BDrow+4, 6).Address)

Then I  remembered the "names" are not used in AutoIt so tried - 

$oExcelDP.Range(Cells(9, 3).Address, Cells(12, 7).Address).copy $oExcelDP.Range(Cells($BDrow+1, 2).Address, Cells($BDrow+4, 6).Address)

Also tried the above statement without the ".Address".  Tried including the Workbooks("sheet"). prior to the range definition also.

 

I changed to reading the block to an array and then writing back to the new block location - which is working fine.

However, I'd like to know if there is a way to use the Excel VB commands for copy/paste data block ranges in AutoIt.  I suspect I may just have some error in my statements above.

Thanks,

Doug

 

[JLogan3o13]

Is there a reason you're not using the built in Excel functions, like _Excel_RangeCopyPaste or _Excel_RangeInsert?

[redrum]

I did not find these Excel functions in the help.  So, I guess I need to update my Excel UDF as there must be some functions that I don't have.  Will check further on the Forum on this.

Thanks

[water]

Which version of AutoIt do you run?

[redrum]

I'm running v3.3.9.4 Beta most of the time.  Sometimes v3.3.8.1 - using this for some older scripts, but could probably use the Beta version for these also, just have not tried that.

[JLogan3o13]

AutoIt is moving forward all the time. It blows having to update for script-breaking changes, but you'll find you miss out on new features by not keeping up. I would suggest getting yourself up to 3.3.12.0 as soon as you're able.

[redrum]

OK that sounds good - now is a good time to do that as I am making significant changes to scripts. Regarding this upgrade I have a couple questions:

1.  I went to the Beta version quite awhile back because it had the com functions in it, and I was having some issues that required the com functions.  So, in the new version,are those com functions now included that used to only be in Beta?

2.  Are the new/updated Excel functions in this newer version also, or is there some specific Excel support that I also need to download and include?

Thanks

[JLogan3o13]

For the most part, Yes and yes. For a complete list of what has been added or not, I would suggest installing the latest stable version and then reading through the Change Log.

[redrum]

OK, thanks for your quick responses.