I
iambalrog
Hi All
I need to run a VBA macro in Business Objects that saves an excel file
under a certain name - based upon todays date (i.e.
filename&todaysdate&.xls) then opens that same file, and does a few
basic formatting things to it in the background (i.e. removes all grid
lines, zooms out to 85% etc).
Whenever i try to do anything like this it seems to have problems with
being an active application, or also when i record a macro and use the
code from that to change zoom levels, it does that with the active
window, and i dont know how to make excel the active window (id prefer
not to have to make it active, and have it working in the background)
Any suggestions would be brilliant.
Thanks!!!!
I need to run a VBA macro in Business Objects that saves an excel file
under a certain name - based upon todays date (i.e.
filename&todaysdate&.xls) then opens that same file, and does a few
basic formatting things to it in the background (i.e. removes all grid
lines, zooms out to 85% etc).
Whenever i try to do anything like this it seems to have problems with
being an active application, or also when i record a macro and use the
code from that to change zoom levels, it does that with the active
window, and i dont know how to make excel the active window (id prefer
not to have to make it active, and have it working in the background)
Any suggestions would be brilliant.
Thanks!!!!