XMLConverter - help
The file converter will convert Microsoft Excel files to xml-files of type
spreadsheetML. It can copy the original directory-structure to the new
location of the converted files.
- Macro Security must be set to medium or low. (>Tools >Macro >Security).
- Upon opening converter.xla press Enable Macro's.
directory to search
Specify the directory to search. Use the Browse... button to locate the directory.
The file search will include all files with the extension .xls, .xlt, .xla regardless
of the type of the file. Mind that xml spreadsheets with the extension .xml are not
included, whereas xml spreadsheets with the extension .xls are included in the search.
include subdirectories
Check if you want to include subdirectories in the search.
copy to
Specify where to save the converted files. Use the Browse... button to locate
the directory. The converted files will be saved as xml-spreadsheets with the extension
.xml. If you checked the include subdirectories checkbox the converted
files will be saved in a similar directory-structure as the original files.
create log
Check if you want a workbook report on the conversion. Will include
old path, old name, new path, new name and error messages.
Start
Start the conversion. The interface will react irresponsive while Excel
creates a list of files to convert. This action may take a while, especially if
large directory-structures are being searched. Before the conversion process
begins you wil get a chance to cancel the process. After that the conversion process
can only be interrupted by pressing Control + Break. Use this drastic measure
only in case of emergency.
The conversion process will halt upon opening password protected workbooks and workbooks with
linked data. The usual message will be displayed. During tests only workbooks containing
weird VBA-code that was set to execute upon opening deteriorated the process.
MARK THAT VBA-CODE THAT EXECUTES UPON OPENING OF A WORKBOOK THAT IS TO BE
CONVERTED CAN HARM YOUR COMPUTER AND/OR FILES!
|