.NET Excel parameters

[Guest]

I've set a reference to Excel and Imported Micorosoft.Excel. In the code
snippet below I get a squiggly line under the items starting with "xl". How
do I reference them?

.Selection.Sort Key1:=Range("C2"), Order1:=xlAscending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom

 

[Simon Jefferies]

Hello,

You need to place the following at the top of your file:-

Imports Microsoft.Office.Interop.Excel

and your line of code would become:-

..Selection.Sort Key1:=Range("C2"), Order1:=XlSortOrder.xlAscending,
Header:=XlYesNoGuess.xlGuess, _
OrderCustom:=1, MatchCase:=False,
Orientation:=Constants.xlTopToBottom

Hope this helps,
Simon Jefferies
simon(nospam)@cooltoolsonline.co.uk