Gareth Horton
July 12th, 2002, 01:23 PM
Dee Moore wrote:
> Nicholas Osdale wrote:
> > I am using Excel 97 VBA to automate the process of Monarch's report creation.
> >
> > I have a model with 6 filters and I can effectively loop through these filters and
> > create XL files from them, but I also need to export the full table of data. I
> > can't always guarrantee that the "No Filter" option will be set as "default".
> >
> > How can I make Monarch goto the "No Filter" option?
>
>
> If your Set Filter and Export commands are like this:
>
> MonarchObj.CurrentFilter = "Fandagos Records"
> MonarchObj.ExportTable("C:Program FilesMonarchExportFandagos.xls")
>
> MonarchObj.CurrentFilter = "No Returns"
> MonarchObj.ExportTable("C:Program FilesMonarchExportNo Returns.xls")
>
> 'You will need to add an empty CurrentFilter:
>
> MonarchObj.CurrentFilter = ""
> MonarchObj.ExportTable("C:Program FilesMonarchExportNo Filter.xls")
>
> Dee Moore
> Datawatch Corporation
> Technical Support
> 978.441.2200
Perfect!
Thanks Dee.
> Nicholas Osdale wrote:
> > I am using Excel 97 VBA to automate the process of Monarch's report creation.
> >
> > I have a model with 6 filters and I can effectively loop through these filters and
> > create XL files from them, but I also need to export the full table of data. I
> > can't always guarrantee that the "No Filter" option will be set as "default".
> >
> > How can I make Monarch goto the "No Filter" option?
>
>
> If your Set Filter and Export commands are like this:
>
> MonarchObj.CurrentFilter = "Fandagos Records"
> MonarchObj.ExportTable("C:Program FilesMonarchExportFandagos.xls")
>
> MonarchObj.CurrentFilter = "No Returns"
> MonarchObj.ExportTable("C:Program FilesMonarchExportNo Returns.xls")
>
> 'You will need to add an empty CurrentFilter:
>
> MonarchObj.CurrentFilter = ""
> MonarchObj.ExportTable("C:Program FilesMonarchExportNo Filter.xls")
>
> Dee Moore
> Datawatch Corporation
> Technical Support
> 978.441.2200
Perfect!
Thanks Dee.