I'm trying to Open an URL using Excel VBA in MAC and I want to close the Window after it loads. I'm currently using this piece of Code so that I uses the Default browser to open the link, but need help on how to close the browser. ActiveWorkbook.FollowHyperlink ' ' Sub test() Dim h As Hyperlink With Worksheets(1) Set h =.Hyperlinks.Add(Anchor:=.Range('A1'), _ Address:=' ') h.Follow h.Delete.Range('A1').Clear End With End Sub Both the above code open the link on the Default browsers. I can ask users to use Safari or Chrome in case I get to know the way I can close the browser instance. Basically I want to open an URL where the browser windows doesn't show up the user and fetch the output.

Learn how to launch macros with keystroke shortcuts and buttons, record a formatting macro and alter VBA code, and expand macro functionality with If statements and interactive techniques.

I'm in the process of writing a Function need help. Thanks for your help in Advance (',')/ I'm trying to run the Code on Mac using Excel 2016.

If you're using the default browser, I don't think there's any way you can tell which specific application that is, and therefore tell it to perform some follow-on action. In my experience, VBA is geared at driving itself, but not so good at managing external applications. If you want to drive external apps, consider using the Macscript command. Depending on the URLs you're accessing, you might even be better off not using a GUI browser at all, but driving something like curl via a shell/system command.

AbhishekDK wrote: Basically I want to open an URL where the browser windows doesn't show up the user and fetch the output. I'm in the process of writing a Function need help. By 'fetch the output' do you mean perhaps either 'fetch the source at the URL' or 'fetch the results of an API at the URL'? If so you consider something like this (this example fetches CSV data returned by Yahoo!). This approach works well in Excel 2016 for Mac.

It doesn't open a browser. ' Request the data from Yahoo! And put the returned CSV in rows in dDest's column With ActiveSheet.QueryTables.Add(Connection:='URL;' & Y_API_URL, Destination:=dDest).Refresh BackgroundQuery:= False.RefreshStyle = xlOverwriteCells.SaveData = True EndWith Here the URL is in the form ' '. Your URL most likely will be in a different form.

Mac address for kindle fire. Apple Footer • This site contains user submitted content, comments and opinions and is for informational purposes only. Apple may provide or recommend responses as a possible solution based on the information provided; every potential issue may involve several factors not detailed in the conversations captured in an electronic forum and Apple can therefore provide no guarantee as to the efficacy of any proposed solutions on the community forums. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the.

Hi Ashicacchi, I am writing VBA code. I open Excel locally Yes I can see the VBA coding using both 2010 and 2013 Excel 2016 32 bit is my architecture. Here is something interesting.after this writing and upon exploring the Personal.xlsb, I found the personal was installed in two places. I am not sure if that was the actual problem, but after removing one of the personal files, I was able to use the function I created.

And I was able to record and find that macro as well in the viewer. Have you heard of that happening after an upgrade of one version to the other? In my case 2013 to 2016. Thanks for responding.