Hello all,
First off, the experts on this site have been so helpful in my VBA endeavours. I can't thank you enough. Now, my next challenge.....
I have been using the following code to pull data from various queries within my database....
Sub Get_Data ()
' pull data from the database...
I’ve been trying to find a way to change location and date from import web page and wondered if somebody could help please?
http://www.realtimetrains.co.uk/search/advanced/RAM/2018/09/26/0000-2359?stp=WVS&show=all&order=wtt
The two areas are highlighted in bold and “RAM” I was going to use a...
Hello
I am using the following code to import historical indices data for 5 different indexes in yahoo finance.
Public Sub Import_Yahoo_Finance_Historical()
Dim URL As String
Dim dateParams As String
'Date ranges from default earliest Yahoo start date (m/d/y) to current...
Legacy 266325
Thread
automate excel import
dynamicquery
html data
vba & excel
yahoo finance
My experience has been mainly SQL Server. I am working on an Access 2003 database with a simple data entry form (frmNewPatient) for inserting new records into a Patient table. Before executing the insert, I want to check that there is no matching record already in the Patient table. The form has...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.