Excel Worksheet

nyerel

Hello Guys

i'm seeking your help guys. I've got a report with no dataitems and i want to use Excel to analyse my data. But i don't want to add a worksheet each time i'm sending data from a different table. I want to just open a workboot with a number of template sheets. I just activate the sheet that i want to use. I tried: Worksheets('SheetName').Activate; but to no avail. This is possible in VB, but not in Navision, i think. :oops: :oops: Somebody said i can write a macro in Excel to activate and deactivate the sheets and invoke the macro from Navision. If anyone has got a different view, then you can help here.

Thanx in advance
:?: :?: :?: :x :x 8)

eromein

I'm not quite sure what you want, but maybe you can use the "Excel Column Exporter v2.1" add-on for that.

You can download it for free here http://www.mibuso.com/dlinfo.asp?FileID=207.

Hope it helps you!

nyerel

Thanx Emiel, but i think i failed to express myself. The thing is, i've got five tables:Bank Account Ledger Entry, Sales Header, Cust. Ledger Entry, Purchase Header, and Purchase Ledger Entry. i aslo created a template Excel workbook with Three worksheets: one for Bank Account Ledger Entry, the other for Sales Header and Cust. Ledger Entry, and the third one for Purchase Header and Purchase Ledger Entry. Now i want to start exporting the Bank Account Ldger entries into a the first worksheet by activating it and dummping my data, then deactivating it and selecting the next worksheet and so on. I don't want to add a new worksheet each time i move to the next table(s). So my problem is about activating and deactivating the existing worksheets.

I think it's now more to the point.

Thanx

eromein

So the problem is, that you don't know how to activate an existing worksheet?

And do you want to overwrite data (already in the existing worksheet) or do you want to add data in the worksheet?

Hanen

I have the same problem, how can I activate an existing worksheet it's a kind of selection or activation to fill with the write data. :-k

Example:

Sheet 1: if The payment is by check
Sheet 2: If the payment is by cash
Sheet 3: if the payment is by transfer
Sheet 4:...................................

Thanks for help.