I need to access Excel "Save As" programmatically (I am not a programmer)

Hello Excel forum and thank you for being here !

I receive weekly 10-20 CSV files that range from 20 to 200 MB in size (network scans)

My problem is that device creating the files I receive do not load into my ETL software (iDashboards)

What I have had to do is load each CSV file into Excel (2019 in this example) and perform

File-->Save As --> CSV (MS-DOS)

The output file loads without issue into our ETL software.
(I noticed that the process does add commas and change the file structure somewhat, so I know the data inside is being manipulated )

What I am trying to find is a way to programmatically accomplish this manual "Save As" process in Excel

How could this be done?

How can this function of excel be accessed from a command line? PowerShell? or some other programmatic fashion?

Thank you for any insight and help that can be provided

I am so sorry those did not attach.. .well I can type it out


My folder is named E:\AA
Inside that I have 2 subfolders Before and After


In module 1 I have

Please Login or Register  to view this content.

The XLSM named AutoRunFile.xlsm is store in E:\AA

I have this text below as a Script.VBS

Please Login or Register  to view this content.

I open the file up before anything else to check and enable macros

So my folder structure looks like
e:\AA
contains 4 items:
-Script.VBS
-AutoRunFile.xlsm
-After(Folder)
-Before(Folder)



When I schedule the task in task scheduler (create basic task, no arguments or start in)
I open properties and change it from "server 2008" to "windows 10" and Configure for and select "Run with highest privileges "

and then run it manually the following happens


Excel opens up with a window saying
"A file names E:\AA\AutoRunFile.xlsm already exists in this location. Do you want to replace it?
(Yes No Cancel) - No is heighlighted.

I chose "No" then---
I get Run-Time error '1004'

Cannot access 'AutoRunFile.xlsm'
(End Debug) Continued is greyed out.


I hit end and I get a windows script host error popup window:
Script E:\AA\Script.vbs
Line 6 Char 1
Error unknown runtime error
Code 800a9c68
Source: MS VB Script runtime error.


How did I cause so much chaos????

@runatyr

Administrative Note:

You need to include code tags around your code.

Please take a moment to add the tags. Posting code between [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. As you are still new here, I will do it for you THIS TIME.)

For future reference, there are instructions at the top of the page explaining how to attach your sample workbook.