Export Worksheets As Separate Tab Delimited Text Files

I have a workbook with about 20 sheets in it that need to be exported as tab delimited text files. I was able to find a couple variations of a VBA code to do this, but they both yield errors when I try to run them.

The first code I tried was:

Please Login or Register  to view this content.

On that I get the error:

Run-time error '429':
ActiveX component can't create object

Does anyone know why this code isn't running properly on my computer? Perhaps it is because I am running a Mac?

I am attaching a test file with a few sheets of dummy data and the VBA code for convenience.

Hi !

Yes, CreateObject is only for Windows ActiveX !
Just replace it with the plain text destination folder or mod directly FileName codeline …

Thanks for that clarification! I put a file path in quotes which seems to fix that part of the problem. Now I am receiving another error:

Run-time error '1004':
Method "SaveAs" of object "_Worksheet" failed

Any idea on this?