Using agrument in Sub as Table name

Anonymous — Wed, 28 Oct 2015 09:57:34 GMT

Hi All,

I am writing a sub to import data.

However, instead of pre defining the name of the table, i would like to make it a specified field.

i.e.:

sub Import(Dir,Table_Name)

Table_Name:

Load * ...

From filelist( Dir& '/*.xlsx')

However, the table will always be named "Table_Name" no matter what string i used in the argument.

Please kindly advise.

Thanks!

Cheers,

Re: Using agrument in Sub as Table name

sebastianlettner — Wed, 28 Oct 2015 16:16:13 GMT

Hi,

use

$(Table_Name):

LOAD

...

Regards

Sebastian Lettner