upobDaPlaya
asked on
Batch file to convert a xlsx file to csv
I used the below link (Batch Rename) to create a .bat file and rename a xlsx file to csv. The problem as expected is the file is all gibberish since it did not go thru a proper conversion. Unfortunately the server where the xlsx files are landing does not have MS Office loaded and it appears that may not be allowed (loading office on the server). Thus, I need some way to get these xlsx files into a proper .csv file as the vendor software I use on the server can only handle csv or txt files. My hope is I could create some other .bat file to run on the server that would do a proper conversion. Would the second link (VB Code) work even though office is not loaded onto the server. Would I have the .bat file execute the vb file.
I know the easiest solution would be to have the people sending the file send a csv file, but that is not possible.
Batch Rename
VB code
I know the easiest solution would be to have the people sending the file send a csv file, but that is not possible.
Batch Rename
VB code
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER