![]() ![]() Symbols = Left(Symbols, Len(Symbols) - 1)ĭim URL As String: URL = "" & Symbols & "&f=snl1hgc6m3m4m5yr"ĭim Resp As String: Resp = http.ResponseTextĭim Lines As Variant: Lines = Split(Resp, vbNewLine) Symbols = Symbols & W.Range("A" & i).Value & "+" Below is the coding script:ĭim Last As Integer: Last = W.Range("A1000").End(xlUp).Row ![]() ![]() Can anyone take a look and see if it is possible to write a script for the same functions that is compatible on both PC and Mac? I believe part of the problem is because the Mac does have the available reference Microsoft WinHTTP Services, Versionĥ.1 and so the GET URL function of the code does not work. However, when I open my spreadsheet on a Mac with microsoft 2011 I get a bunch of error messages throughout the coding It downloads from the Yahoo Finance website. ![]() I have recently created a live market feed to my excel spreadsheet on my PC using VB coding. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |