I have developed an interactive application that uses web query to send and receive data with a web site (a LAMP stack) protected with basic authentication.
On my primary platform, Excel 2004 (Mac), everything works fine. The first web query automatically (i.e., Excel does this, not my code) triggers a dialog box to enter the username and password.
On my alternative platform, Excel 2010 64-bit, Excel doesn't pop up the dialog box. Access to the web site is thus denied, and Excel fails with a "the hyperlink cannot be followed to the destination" error.
Is there a cross-platform way around this?
On my primary platform, Excel 2004 (Mac), everything works fine. The first web query automatically (i.e., Excel does this, not my code) triggers a dialog box to enter the username and password.
On my alternative platform, Excel 2010 64-bit, Excel doesn't pop up the dialog box. Access to the web site is thus denied, and Excel fails with a "the hyperlink cannot be followed to the destination" error.
Is there a cross-platform way around this?
