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
'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.
One of our online training videos illustrates how to do this. Briefly:
The secret is to have a 'master template Excel' file, let's call it Template.XLS. Template.XLS will have all the formatting you want, even formula's if you so desire, but it will be empty of data. You'll need to do the following steps:
You could optionally do it more elaborately:
Beginning with version 6.03 (May 24th 2012) of 'Convert XLS': Conversion of XLS/XLSX files that require a significant amount of time load data content or to calculate now have a new entry in the programs ini file, CX_SearchHistory.INI. To cause 'Convert XLS' to issue a RefreshAll() command and wait x number of milliseconds add this line immediately below the [frmMain] line:
For example, to delay 30 seconds (30000 milliseconds) it would look similar to this:
Yes, you can. Use the /K switch to get an error code. Here is a sample batch file.
When using the 'Convert XLS' conversion method, some characters (i.e. diacritic marks like in Czech, Polish, Swedish, Spanish, French, etc.) are not coming out properly.
Be certain you have the properly installed/setup language settings in the Control Panels\Regional Settings.
1. Run 'Convert XLS'
"'ConvertXLS' is not recognized as an internal or external command, operable program or batch file."
Important: To use the command line successfully you must do one of the following:
"C:\Program Files\Softinterface, Inc\Convert XLS\ConvertXLS.EXE" /S"C:\test\test.csv" /T "C:\test\test.xls" /C-4143 /F6 /M2 /V
If your original file begins with the letters "ID", your file will not convert to Excel. You need to move the letters "ID" out of the position where it is the first thing in the file to another location in the file.
For example, if your CSV file looks like this:
ID1234, comma, delimited, data
removing the ID, or placing it after the 1234 will fix the problem.
Convert the worksheet first to an HTML file, and give it a *.DOC extension. For example the target file should be something like:
And the target file type should be HTML.
The 'Convert XLS' conversion method supports the following file types.
Copyright © 1999-2013 by SoftInterface, Inc. All rights reserved.