Report to Excel. Help Please

[yuriyman]

Hi guys and gals,
I need help with the following:

Original Data:

Name​

Bank Name​

George​

Citibank​

George​

Wamu​

George​

BankofNY​

John​

Chase​

John​

Wamu​

Victor​

Dime​

Processed data:

Name​

Bank Name​

George​

Citibank, Wamu, BankofNY​

John​

Chase, Wamu​

Victor​

Dime​

OK so I did all of this.
The original data is stored in a table, I used VB code (found on this site) to process the data and put it into a report. Now I need to export the report into an Excel spreadsheet, I tried many different ways even with VB code (found on this site) but I keep on getting the same error, Subscript out of range

Anyone have any ideas???

 

[sfreeman@co.mer]

The toolbar has an option to export to Excel. Does that work?

Please post the relevent code.

 

[yuriyman]

i tried to do that but it was giving error as i mentioned before "Subscript out of range ". is there any way to use the vb code in excel to get the data in the table in the required pattern as mentioned above.

 

[sfreeman@co.mer]

Follow this link. Sorry I can't be more help.

http://www.access-programmers.co.uk/forums/showthread.php?t=22255&goto=nextoldest