Open website and open excel book vba

[Alpacino]

Hi peeps.

How would I start to do write this???

 

[TiaXL]

sub show()
dim Newsite as object
Set NewSite = CreateObject("InternetExplorer.application")
NewSite.Visible = True
NewSite.Navigate "http://yoururl.co.uk/
 
workbooks.open("Your filepath")
 
end sub

 

[Alpacino]

Thanks for that.

As the macro ran prompts came up with open or save I like to bypass this by just saying open and enable macros how Do I do that???

 

[TiaXL]

Thanks for that.

As the macro ran prompts came up with open or save I like to bypass this by just saying open and enable macros how Do I do that???

just use application.displayalerts = false before the code runs

 

[Alpacino]

I have tried this but prompts still appear.