Convert vbscript? to COM

[randallc]

Hi,

Can anyone help convert this? - How do we move around in Excel file?

Thanks, Randall

Cells(Rows.Count, "A").End(xlUp).Select

or

    Intersect( _

      Cells.Find("*", Cells(1), xlValues, xlWhole, xlByRows, _

        xlPrevious).EntireRow, _

      Cells.Find("*", Cells(1), xlValues, xlWhole, xlByColumns, _

        xlPrevious).EntireColumn).Select

or

Selection.SpecialCells(xlCellTypeLastCell).Select

EDIT; answer for going to last cell;

    .Application.Selection.SpecialCells(11).Select ;$xlCellTypeLastCell=11

    $AddressExcel = .Application.activecell.address

Edited July 24, 2005 by randallc

[DaleHohm]

Randall,

A big part of your problem is that your examples are full of eNum values. All of the items starting with xl are actually numeric constants and they are unknow to AutoIt. Check out this post to get their values and include them in your code:

Get Application eNums

Dale

Hi,

Can anyone help convert this? - How do we move around in Excel file?

Thanks, Randall

or

or

<{POST_SNAPBACK}>

[randallc]

Hi,

Thanks!

That "include" generator in vbs just gives me an error.

Can you generate it and post?

Can it be included in "ie.au"

Thanks, Randall

[DaleHohm]

Hi,

Thanks!

That "include" generator in vbs just gives me an error.

Can you generate it and post?

Can it be included in "ie.au"

Thanks, Randall

<{POST_SNAPBACK}>

No, but I'd like to find out what the errors are so that I can try to make it work for everyone.

[randallc]

Hi,

Now it is I who does not understand!

Are you saying that you do not get any errors when you run the vbs script to generate the "include"?- If so, I would think you would have the file and could post it.

If not, then you can see the errors!

What is the problem?

Best, Randall

[DaleHohm]

I'm sorry you don't understand.

Dale

[randallc]

OK!

Here is first error.

best, Randall

constantsError.JPG

[DaleHohm]

OK!

Here is first error.

best, Randall

constantsError.JPG

<{POST_SNAPBACK}>

Thanks Randall.

I've updated the basenote for the Enum extration topic to include information on the dll dependancy. Please check it out and let me know if you continue to have trouble.

Dale

[randallc]

Hi, Dale,

Same problem.

I have Office 2003 but not that file; imported from the Web to directory where I have the .au3 file; but perhaps it need s to be registered or something?

No luck.

But i have the ONE only constant Ineeded for my script, from the website for excel constants, so it doesn't matter to me. (excel com script working OK)

Let me know if you need me to test it some other way...

Best, Randall

[DaleHohm]

I've attached sample output for Excel to the post with the VBS Enum script.

Please try registering the dll and see it it resolves the problem. If so, I'll update the instructions.

Dale

Hi, Dale,

Same problem.

I have Office 2003 but not that file; imported from the Web to directory where I have the .au3 file; but perhaps it need s to be registered or something?

No luck.

But i have the ONE only constant Ineeded for my script, from the website for excel constants, so it doesn't matter to me.  (excel com script working OK)

Let me know if you need me to test it some other way...

Best, Randall

<{POST_SNAPBACK}>

[randallc]

Hi Dale,

Yes, I was surprised!

"regsvr32 tlbinf32.dll" in "Run" succeeded, the "vbs" script produced the constants file!

Best, Randall

[DaleHohm]

Hi Dale,

Yes, I was surprised!

"regsvr32 tlbinf32.dll" in "Run" succeeded, the "vbs" script produced the constants file!

Best, Randall

<{POST_SNAPBACK}>

Thanks for sticking with this and testing Randall. I'll update the original post.

Dale