TransferSpreadsheet: Import Column A and C, but not B

[Ricardo]

Hi

How do I define a Range that selects only Columns A and C, but not B?

I tryed "A:A,C:C" but it doesn't work.

Can anyone help?

Thanks,
Ricardo

 

[John Nurick]

Hi Ricardo,

You can't. You can only link or import a contiguous range.

 

[Guest]

what about hiding the column in the original excel file?

 

[Yaacov Klapisch]

Run the wizard and select the columns to import.
Save the settings and then use them in your code.