try in this http://www.vbaexpress.com/forum/
Rgds HR On Wed, Feb 17, 2010 at 8:33 AM, MSB <[email protected]> wrote: > > Ah, the data may have been inserted into the report using POI but, and this > is simething that I guess you could not have been aware of, POI cannot be > used to create or edit macros. Therefore, it is quite likely that the > authors of the original document used a template that contained those > macros > and then utilised POI to open the template a stuff data into it because > they > could not have used it to either create or edit the macros. That was why I > advised you to post the question onto an Excel forum rather than this one, > sorry if I did not make that clear. > > Yours > > Mark B > > > Patil Minal wrote: > > > > Mark, > > > > I know this forum is specifically to address issues regarding POI, > and I > > tried a lot searching on google also but with no success. However, I > > thought if anyone on this forum might possibly have answer for my problem > > then I would be grateful. Although, the web application from where we > > download the excel report in question uses POI to generate the excel > > report, I think there wouldn't be any POI's relevance in this issue. > > > > - Minal. > > > > -----Original Message----- > > From: MSB [mailto:[email protected]] > > Sent: Tuesday, February 16, 2010 10:01 PM > > To: [email protected] > > Subject: Re: event to notify excel initialisation end > > > > > > Think you may have posted this question in the wrong place; most of the > > members of this list know how to use an API to create files that are > > compatible with Excel. It seems to me that you want to post this sort of > > question on an Excel users forum and I feel confident that Google will > > point > > the way to those. > > > > Yours > > > > Mark B > > > > > > Patil Minal wrote: > >> > >> Hi, > >> > >> I have one excel report wherein I need to trigger a macro > >> which performs chart scaling once the report is fully downloaded. The > >> excel report has a lot of formulae which internally call other macros to > >> populate the excel cells on one sheet from a different data sheet. The > >> excel does not respond until the excel is fully populated i.e. all the > >> cells have there formulae executed. However, all the events like > Activate > >> or open occur quite before that. Hence, I don't get a trigger event to > >> call the macro to change the chart scaling. > >> > >> Please help. > >> > >> Minal Patil > >> > >> > >> > >> > > > > -- > > View this message in context: > > > http://old.nabble.com/event-to-notify-excel-initialisation-end-tp27609032p27611025.html > > Sent from the POI - User mailing list archive at Nabble.com. > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [email protected] > > For additional commands, e-mail: [email protected] > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [email protected] > > For additional commands, e-mail: [email protected] > > > > > > > > -- > View this message in context: > http://old.nabble.com/event-to-notify-excel-initialisation-end-tp27609032p27619989.html > Sent from the POI - User mailing list archive at Nabble.com. > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > >
