Hi All,
My requirement is basically external parties will be submitting excel files on our file server. We need to pick these excel files and read them create documents with it's data. But as you know that open dataset does not work with excel file we will need to convert these excel files to tab delimited text files. All this can be run through background job too.
Following is the approach we are thinking but running into issues.
We have a VB script which will open the excel file on server and then save it as text file. Attached is the VB script code for reference.
Then we have a batch file which will have command to execute this VB script file.
Foll is the code in batch file
cscript \\avenger\temp\xlfileconvert.vbs %1 %2
Now the above files run fine when I execute them directly from command prompt on my local machine. But when I create an external command(SM69) I get following error message
"Microsoft VBScript runtime error: ActiveX component can't create object: Excel.Applicatiion"
I cross checked that excel application is installed on the server on which we run the external command. Does anyone know what could be causing this issue?
Let me know also if you know of any alternate approach to handle this requirement.
Regards