Search results for query: *

So because of the following line of code: BoRpt.ExportAsExcel (ExportFileLoc & PeriodFolder & ExportName & ExcelFileExtension) I cannot be certain that my exported document will be exported properly? I never thought that VBA for Excel would act randomly like that. I have absolutley no choice...

Hi everyone, hoping you can help with this one as I am completley baffled! I have automated business object reports, that get exported to excel (through VBA). Now, I ran the code that does this and for some strange reason, some of the exports zoom custom was set to 4294967295. Can anyone...

Hi everyone, hoping one of you experts can help me with this one. I have a VBA module that refreshes 3 business object reports. These are really big reports (60000K! each). At the moment, my module refreshes these reports one at a time, and you can imagine that this takes a very long time. I...

Hello everyone, hoping someone out there can help me with this one. Im having trouble doing the above. within VBA, I have a BO Report that gets a filter applied to it, then the data is exported to excel. This is done in a FOR statement. Once I come out of the FOR statement, I want to quit...

Hi everyone, Im looking for some help. I am currently automating a report and I need to create a new dataprovider everytime I run this report. The dataprovider is going to be based on an excel spreadsheet. How do I create this dataprovider through VB? Im really just looking for some notes on...

Steve thats great news. I didnt think you could do that. That is great news. I just wish I had the powers to be able to add an extra column to one of our tables specifying the group but Im not allowed(typical eh!). Thanks for your help :o)

Hi everyone, really need help with this one. I have a Business Object report that has over 1000 values in it that need grouped. Everytime I refresh this report, new values appear so I cant write an If Statement as I would constantly have to update it and also there are too many values to be...