I am trying to create a file that can be imported into Simply Accounting. This file will have all the account numbers and name for a chart of accounts.

I have fiqured out that if I create the file in Excel and then save it as a formatted text space delimited .prn file that I can then import it into Simply Accounting.

If I just create a text file with everything else the same. Ie. the file will look visually identical to the .prn file, it won't import into Simply Accounting.

Saving as a .prn in Excell must attach something to the file in the background that Simply Accounting needs to import properly.

I need to create the file in VB, ie. write to a file on a disk. I somehow need to get VB to save in the .prn format.

I have tried all option using:
SaveAs filename:="a:\fbc_Smplychart.prn", FileFormat:=2


But I just can't get the format.

Any Ideas?

[email protected]

Cheers,