Hi All,
I am new to macros in Impromptu 7.1. I have a question.
How do I export the Impromptu report to Excel with format. In
Excel the first line should have a text. Ex: "Report By Date" in
bold. The 2nd line should have the dates from the prompts I use
for the .imr report and the third line should have the report data
from .imr. And also the sheet name should be given using a macro.
Is this possible? I mean to say how can I insert the report data
from .imr to excel exactly on the 3rd line ( cell A3)? Since the
contents of the list frame does not get exported to Excel. I would
like to insert the text exactly on the first line of Excel through
macro.
Please help. Your help is greatly appreciated.
Swathi
I am new to macros in Impromptu 7.1. I have a question.
How do I export the Impromptu report to Excel with format. In
Excel the first line should have a text. Ex: "Report By Date" in
bold. The 2nd line should have the dates from the prompts I use
for the .imr report and the third line should have the report data
from .imr. And also the sheet name should be given using a macro.
Is this possible? I mean to say how can I insert the report data
from .imr to excel exactly on the 3rd line ( cell A3)? Since the
contents of the list frame does not get exported to Excel. I would
like to insert the text exactly on the first line of Excel through
macro.
Please help. Your help is greatly appreciated.
Swathi