QUOTE(djessellis @ 18 Jan, 2008 - 07:23 AM)
Hey Guys -
OK, so I use Business Objects alot for data mining and development. I am fine using it, but I know that the reports that I am designing for the end-users are pretty daunting and require a bit of manual labour on their part. I am thinking about using the macro builder within BO to automate some of the tasks.
I am used to developing macros in Excel (recording them and then editing afterwards in teh VBA studio) - but it looks like you have to solid code directly into BO.
I would appreciate any advice, tips, tricks, etc, from anyone who has designed macros within Business Objects.
Thanks
Jesse
I have some code that I have been working on in Excel - where I save the report in a specific location as a text file:
CODE
ActiveWorkbook.SaveAs Filename:= xxxxx
What do I replace 'ActiveWorkbook' with?
18 Jan, 2008 - 06:23 AM
| 