I am attempting to automate the download & processing of spreadsheets from a web-based system, using MS Access 2007, Windows 7 (64-bit)
I've found on the web techniques for automating the save As dialog box, but I suspect these techniques relate to older versions of IE.
In particular, the techniques rely on finding the dialog window using FindWindow("#32770","Save As")
For me this always returns 0 instead of the hWnd.
Is the class name "#32770" still correct (I imagine so!) and can someone tell me what the new window name is? Or is there an alternative (not using SendKeys)?