Array problem converting from VBA to VSTO

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Waxaholic - 04 Mar 2007 18:20 GMT

I am having an issue trying to convert this VBA code to VSTO
compatibility. It is complaining about the =Array part. I am creating
a sorting rule within excel to speed up sorting of an imported .csv
file.
App.AddCustomList(ListArray:=Array("UAR", "PD", "TES1")

Has anyone solved a similair issue or can point me into the right
direction?

Thanks,

Reply to this Message

keremskusmezer@gmail.com - 05 Mar 2007 12:34 GMT

> I am having an issue trying to convert this VBA code to VSTO
> compatibility. It is complaining about the =Array part. I am creating
[quoted text clipped - 6 lines]
>
> Thanks,

Hi,

Use the following code:

Dim tpsheets() As Object
ReDim tpsheets(2)
tpsheets(0) = "UAR"
tpsheets(1) = "PD"
tpsheets(2) = "TEST"
App.AddCustomList(ListArray:=tpsheets)

this should solve your problem possibly.

Reply to this Message

Waxaholic - 10 Mar 2007 04:06 GMT

On Mar 5, 6:34 am, "keremskusme...@gmail.com"
<keremskusme...@gmail.com> wrote:

> > I am having an issue trying to convert this VBA code to VSTO
> > compatibility. It is complaining about the =Array part. I am creating
[quoted text clipped - 19 lines]
>
> this should solve your problem possibly.

This worked perfectly. Thank you.

Reply to this Message

Array problem converting from VBA to VSTO

Free Magazines