Opening webpage fails in Mac version of Excel VBA

[Misthaufen]

I have some VBA code that runs fine on a PC but fails on the Mac.

I have a column of stock ticker symbols and I want to open a web page
using one of these symbols in the URL:

....
Set Symbol = Worksheets("Symbols").[A1]
URL = "http://www.investorguide.com/cgi-bin/research.cgi?name=" & _
Symbol(i,1)
Workbooks.Open Filename:=URL
....

This works fine in the PC version but in the Mac version the URL that is
passed to the Open contains garbage characters after the symbol name, as
if there is no end of data character.

Can anyone help?

 

[JE McGimpsey]

I have some VBA code that runs fine on a PC but fails on the Mac.

I have a column of stock ticker symbols and I want to open a web page
using one of these symbols in the URL:

...
Set Symbol = Worksheets("Symbols").[A1]
URL = "http://www.investorguide.com/cgi-bin/research.cgi?name=" & _
Symbol(i,1)
Workbooks.Open Filename:=URL
...

This works fine in the PC version but in the Mac version the URL that is
passed to the Open contains garbage characters after the symbol name, as
if there is no end of data character.

I've confirmed this behavior using XLv.X, and reported it to MS, but you
should too, using the Help/Feedback on XL menu item.

XL2004 comes out in a couple of weeks. You may want to check back then
to see if it's been fixed.