WebFormat Table

nigelk · Apr 27, 2011

hi all,

Is it possible to set the format of a web table as a variable?

I'm currently importing several tables and sometimes I need

Code:

.WebFormatting =xlWebFormattingAll

and sometimes:

Code:

.WebFormatting =xlNone

Rather than have 7 or 8 different instances of importing tables, I'd rather have just one and change to suit.

Thanks,Nigel

John_w · Apr 27, 2011

They are integer constants, so:

Code:

    Dim wf As Integer
    wf = XlWebFormatting.xlWebFormattingAll
    wf = XlWebFormatting.xlWebFormattingNone

nigelk · Apr 27, 2011

Thanks John.

Nigel.