Excel Sheets in Separate Tabs

[ojcitt]

Hi,

Would it be possible to have data comparisons for excel workbooks launch a separate tab for each corresponding worksheet? That is, assuming two workbooks to be compared have matching worksheet names, I'd like to see each one compared side-by-side in a different tab in BC3.

Thanks,
ojc

[Aaron]

Multisheet comparison is on our Wishlist, but is not currently supported in BC3's Data Compare. To compare multiple sheets, you can use our Text Compare additional download:
http://www.scootersoftware.com/downl...oreformats_alt

Alternatively, after installing that additional download, you can create a custom Data Compare file format that uses the same conversion process. This will not separate the data into separate tabs, but would throw all of your rows into a single large spreadsheet.
Here is a KB article discussing how to setup a custom External Conversion:
http://www.scootersoftware.com/suppo...rnalconversion