'Convert XLS' FAQ

Office has detected a problem with this file. To help protect your computer this file cannot be opened.

Excel files created with the  'Convert XLS' conversion method and then are used as an INPUT file in another conversion/special process may exhibit this issue. If this is the case then: For Office 2010 (and perhaps 2007) you must add a TRUSTED LOCATION for those input files you are using.

Add a trusted location of MS Excel

1. Click the File tab.
2. Under Help, click Options; the Options dialog box appears.
3. Click Trust Center.
4. Click Trust Center Settings.
5. In the Trust Center, click Trusted Locations.
6. Click the Add new location button; the Trusted Locations dialog box appears.
7. Click Browse to find the folder; select a folder and then click OK.

I'm getting an "Object Variable or With Block not set" error

'Convert XLS' is having difficulty opening the INPUT file. There may be several reasons for this. Try opening the input file from within MS Excel to see if it gives you an error. You may have to add a TRUSTED LOCATION if the INPUT file is not in a trusted folder.

MACROs have also been known to cause issues of this sort. Try disabling or deleting the MACROs in the INPUT file to see if that helps.

How Do I take the contents of a CSV file and place it into a pre-formatted Excel (XLS) file?

@Echo off
Set ConvertXLS="C:\Program Files\Softinterface, Inc\ConvertXLS\ConvertXLS.EXE"

%ConvertXLS% /S C:\in\simple.csv /T"C:\in\simple.xlsx" /F6 /C51 /M2 /D /K /N"^^59" /L"C:\IN\LOG-FILE.LOG"

ECHO. The current errorlevel is %ERRORLEVEL%

if ERRORLEVEL 3 GOTO Label_Missing_Invalid_Arguements
if ERRORLEVEL 2 GOTO Label_Error_occurred_during_conversion
if ERRORLEVEL 1 GOTO Label_ECHO_SHAREWARE_EXPIRED
if ERRORLEVEL 0 GOTO Label_ECHO_SUCCESS

:Label_ECHO_SUCCESS
ECHO The conversion was successful
Goto Label_CLEANUP

:Label_ECHO_SHAREWARE_EXPIRED
ECHO SHAREWARE EXPIRED
Goto Label_CLEANUP

:Label_Error_occurred_during_conversion
ECHO An error occurred during conversion, Use /V or /L for more info
pause
Goto Label_CLEANUP

:Label_Missing_Invalid_Arguements
ECHO Missing required or invalid command line argument(s)
Goto Label_CLEANUP


:Label_CLEANUP

pause

Back to Top

• Set the path in your environment variables to the location of ConvertDoc.EXE

• Use the full path in the command line (with double quotes) like so: 

"C:\Program Files\Softinterface, Inc\Convert XLS\ConvertXLS.EXE" /S"C:\test\test.csv" /T "C:\test\test.xls" /C-4143 /F6 /M2 /V