Importing 2 spreadsheets with IMEX Data Task Specifications (1 Viewer)

[Danick]

I'm using the View & Edit IMEX Data Task Specifications version 2.2 found here

Is it possible to edit the import to allow two imports with one click of the "Execute Action" button? It would be essentially the exact same task but importing another spreadsheet from the same folder.

 

[The_Doc_Man]

I have moved your thread because its location was inappropriate - but it was a valid type of question.

 

[Gasman]

Why not ask the creator? @isladogs

 

[Danick]

Why not ask the creator? @isladogs

Well he posted the code in the link provided in my post, so thought I kind of was asking @isladogs in an indirect way...

 

[Gasman]

Well he posted the code in the link provided in my post, so thought I kind of was asking @isladogs in an indirect way...

Only if it interests him?
Now I have tagged him and you have as well, he will be informed. Safer option?

 

[isladogs]

@Danick
I did notice the thread because of the title but tagging works far better.

If you think about how IMEX data tasks work or look at the example XML in the article on my website...

View & Edit IMEX Data Tasks

Use to view & modify saved import/export XML data tasks

www.isladogs.co.uk

...you will realise the tasks are designed to work with one file at a time.

You can edit the file path using my code but you can't import two files on one task

You could probably write a procedure or even a macro to do two tasks in sequence if its something you need to do regularly.

 

[ebs17]

Instead of constantly editing the import specification, it will make more sense to rename files to be imported to a fixed name + path.

Name statement (VBA)

Office VBA reference topic

learn.microsoft.com