BusinessObjects Board

How to generate Excel file even there is no data to fetch.

Hi all

i have VBA code that fulfills when user runs a report it generates the excel file in a specific directory, but my code generate excel files if it contains some data.

when there is no data to fetch then my VBA code won’t generate excel file, but my end user requirement is it has to be generate excel file even there is no data.

Why Do We Need This: because if you take one example i have an account with Bank X for the month i didn’t done any transactions but still i get the statement like wise… example given by end user

does any one have any idea or any snippet of code

Please help me

Thanks in advance


asni (BOB member since 2007-04-06)

Please see the Reporter FAQ for suppressing no data to fetch message box:

mobrien :us: (BOB member since 2004-03-03)