[EDITED] VBA: Cannot Create Task Scheduler Task Object (.job)After Moving from 2010 to 365

EDIT: When saving in Excel 2010, you could choose to save the file as a "Text (tab delimited)" to which would cause the file to save as a .job file. But now, when I select that file type, it saves it as a standard .txt that is not read by my batch & print program. I can only assume there is something with the VBA not moving correctly from 2010 to 365.

Hey guys,

I wasn't sure what the best category this question fit into so I'll just post it here. I have been using the attached spreadsheet to paste in file locations for PDF drawings my shop uses for manufacturing. When you click on the tab that says "Export," you can then save that tab as a Scheduler Task Object (.job) to use with a Batch & Print Program. However, I am switching computers so my Excel programs are switching to 2010 to 365. Now, when I follow those same steps, I can't get the export tab to export to anything but a .txt file, which is not working for my needs. Any help is appreciated! I have attached the .txt and the excel spreadsheet, but the .job is not supported. Hopefully this makes sense.

Thank you!

EDIT: Perhaps this screenshot will help.
Annotation 2020-01-06 094622.png

Is this a VBA question?

Possibly? I'm not sure, that's why I am asking here

I ask because you have attached an .xlsx file, but what you seem to be describing would require code and therefore need to be in a macro-enabled workbook (.xlsm).

I am going to move this thread to the VBA sub-forum.