Too few parameters. Expected 4. - Error occurs during export ot text but not to Excel

[Welshgasman]

Now works for me if I follow @June7's tip in post #14.

[canyonraven]

That solved it. Thank you June7 and Welshgasman. Thank you to everyone who contributed to thread!!

[Welshgasman]

I would have a Combo that shows what options are available. Then use specific code depending on what is selected if this DB is not just for you.
I would probably do it if it was just for me, just to make life easier. A bit of work up front save a lot of work further down the line.