I don't see a reason why not, at least as of now. There are some things a user would have to check manually, but the macro can signal the need to do that, so that would be ok. How would you go about it? Something like an inputbox that would star the macro? A userform of some kind?
The thing is there's no *list*. There's 1 account per form delivered, each form delivered on different time, and each one needs to be processed immediatelly upon delivery and then sent to a different recipient (mostly via e-mail).
I could, not but that's not currently possible due to how and when (as in not on the same time) the accounts are delivered and how fast they need to be processed. I'm working on changing that input method in the future, so that the task could be fully automized.
That's actually not that big of a no-no. The macro has to be run seperately for each (at least at this point in time) from a number of accounts, daily (200 or so), which I thought might have been a problem. I actually gave it some more thought, though, and I do not believe closing / reopening...
Thanks for the warm welcome :)
I've already written that part of the macro. I'm using the getstring function to get the export the data I want into excel. The macro checks for the last page and continues to scrape the data I need until it hits the last page. It then arranges (using excel vba...
Hey guys, I've been lurking around these forums for a while and steadily increasing my knowledge thanks to it, but now I need some direct help. I'm fairly new to vba and coding in general, so I have some trouble understanding pieces of code I find here and on other forums that I then try to...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.