senor pengwin wrote:You're a genius!
but...
I tried the code and it doesn't appear that the loop is working. I only get "EYMKING - Control Cash Summary" in the first cell and nothing else. The excel appears immediately. What am I doing wrong?
The amount of time it takes wouldn't be an issue, I plan on running this macro on a schedule early in the morning.
Thanks again
EDIT: OK I think I just don't know how to use Imacros, I found the play loop button, does it actually need to replay the whole macro every time? Also do I need to manually tell it how many times to loop?
senor pengwin wrote:Save report is just to save a "style" of report. If you click on .csv and hit run report it will download an excel file. The problem I have with this is that I don't know how to chose the file name and location, I don't want it to just get lost in the downloads folder.chivracq wrote: But first, hum..., I saw on the previous Page, next to the 'Create Report' that you had a 'Save Report' Button, I didn't check it (yet) content-wise, but isn't it actually more or less what you want...?
Or doing a 'SAVEAS TYPE=HTML' or similar on the Page itself...?
Is there a way I can use IMacros to export the report but chose the file name and location?
Me, "genius"...?, boah...!!senor pengwin wrote:Just wanted to update for future references. My solution to this was to export the report and use ONDOWNLOAD. Duh
But OK, yep, sorry, I didn't follow up directly after your last 2 Replies, WE's are always a bit busy for me (I'm a DJ IRL. oops...!), but yep, 'ONDOWNLOAD' is indeed the way to deal with a Download to "direct" the Location (and Name) for the Download... There are a few Threads on the Forum about "Difficulties" in some cases with '.xls' and '.pdf' Downloads, but I guess it works for you...
Thanks for sharing and for the Follow-up...