What is the conventional way to write this Excel VBA?

Question

Is there a more compact and/or conventional way to write this?

With ActiveSheet.QueryTables.Add(Connection:="URL;http://carbon.brighterplanet.com/flights.txt", Destination:=Range("A2"))
    .PostText = "origin_airport=MSN&destination_airport=ORD"
    .RefreshStyle = xlOverwriteCells
    .SaveData = True
    .Refresh
End With

Is there a reason that Connection is written on the first line while PostText is on the second line?

I don't know if I really love doing this in the first place, but you could use line continuation (_) to make this fit on the screen better... With ActiveSheet.QueryTables.Add( _ Connection:="URL;http://carbon.brighterplanet.com/flights.txt", _ Destination:=Range("A2")) (Split the lines at the _ since this does not come out correctly in comments...) — Gaffi
– Gaffi, Commented Jun 22, 2012 at 16:58

Gaffi · Accepted Answer · 2012-06-22 16:00:24Z

4

Connection and Destination are required arguments to the Add function, while PostText (etc) is a property of the QT. The Add function will neither work without the Connection nor with the property passed as an argument.

See this and this for additional reference.

answered Jun 22, 2012 at 16:00

Gaffi

4,3758 gold badges47 silver badges73 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

What is the conventional way to write this Excel VBA?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related