C
Craig in NJ
I use Excel VBA to pull data from an internal web site database into my
own spreadsheet. One task requires a click on a web site link which
opens up its own spreadsheet and runs its own macros, after which it is
ready for me to cut & paste.
My attempts to automate this seamlessly fail, apparently because my
running a VBA macro in my spreadsheet won't let the web link-invoked
spreadsheet run. When I do it manually, the new spreadsheet prompts me
for whether I want to enable macros & then proceeds, but when I have my
spreadsheet's VBA .click on the web page link the new spreadsheet seems
to fail and doesn't appear to open at all.
Can you think of a practical way to automate the bridging of the 3
steps?:
1. My VBA takes user to page,
2. User manually clicks the link + waits for its excel vba autostart
macro to finish, then
3. My VBA copies + processes the data.
Some details: I can't edit the web site's xls (it's dynamically
generated). I also don't seem able to exit my macro fast enough after
its page link ".click" to ensure the web site's xls's macros aren't
hindered by my macro running, though I haven't tested that exhaustively
yet. I do know that the site only responds to .click or navigate's in
the webbrowser/internetexplorer window which is already at the page
containing the target link, so I probably can't fire up a whole new
browser directly with a target URL.
Craig in NJ
own spreadsheet. One task requires a click on a web site link which
opens up its own spreadsheet and runs its own macros, after which it is
ready for me to cut & paste.
My attempts to automate this seamlessly fail, apparently because my
running a VBA macro in my spreadsheet won't let the web link-invoked
spreadsheet run. When I do it manually, the new spreadsheet prompts me
for whether I want to enable macros & then proceeds, but when I have my
spreadsheet's VBA .click on the web page link the new spreadsheet seems
to fail and doesn't appear to open at all.
Can you think of a practical way to automate the bridging of the 3
steps?:
1. My VBA takes user to page,
2. User manually clicks the link + waits for its excel vba autostart
macro to finish, then
3. My VBA copies + processes the data.
Some details: I can't edit the web site's xls (it's dynamically
generated). I also don't seem able to exit my macro fast enough after
its page link ".click" to ensure the web site's xls's macros aren't
hindered by my macro running, though I haven't tested that exhaustively
yet. I do know that the site only responds to .click or navigate's in
the webbrowser/internetexplorer window which is already at the page
containing the target link, so I probably can't fire up a whole new
browser directly with a target URL.
Craig in NJ