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
Regards
ash
asni (BOB member since 2007-04-06)