Script not identifying excel files?

[mlf84]

Hi all,
I have written the script below. The goal is open each .xls file in a folder, then save it to another folder as a .txt file. It works perfectly on my Windows 7 (64 bit) laptop, but I tried using it on an XP computer today, and it's not working. Both machines are running Excel 2007. The script doesn't error out, it just acts as if there are no Excel files in the Process folder (which there are). The problem is not the folder path (that problem was fixed first). I am a total amateur at this, so forgive my ignorance... any help would be greatly appreciated!

Thanks,
Monica

Here's the script:

Please Login or Register  to view this content.

[Leith Ross]

Hello mlf84,

Welcome to the Forum!

The code is correct up to where the new workbook is saved. You declare the file format as xlText which is an invalid file format constant. You can use: xlCSV, xlTextMac, xlTextPrinter, or xlTextWindows (click here for a full list of 2007 file formats). The most commonly used text file format is xlCSV.