gtg430i
05-07-2014, 08:17 AM
Hello - This is a continuation of a previous problem which I successfully solved on my own. Basically this is what I need:
1 - I have a list of website that I want to open (Done)
2 - Each website may or may not have an Excel file to download. I want the code to try to open this file (Not completed).
3 - If a file is found, I want the data to be automatically downloaded in an Access Database if possible (Not completed).
Example of a website with an Excel file to download is below. The file if found on the top right of the middle table (arrow pointing down):
https://www.oceanschedules.com/schedules/schedule-search.do?&originId=216646&destinationId=170041&weeksOut=6&date=06-May-2014&origin=Miami, Florida,UnitedStates(USMIA)&destination=Beirut,Lebanon(LBBEY)&searchType=0&searchSort=2&showSurroundingPorts=Y&lad=05/06/2014&dad=06/17/2014&isp=1&PInUserRole=SchedulesInquiry&PInUserType=Public&PInINTTRAProduct=&carrierScac=
Example of a website with NO Excel file to download:
https://www.oceanschedules.com/schedules/schedule-search.do?&originId=211776&destinationId=1005497&weeksOut=6&date=06-May-2014&origin=Anchorage, Alaska,UnitedStates(USANC)&destination=Tanger Med, Tangier, Morocco (MAPTM)&searchType=0&searchSort=2&showSurroundingPorts=Y&lad=05/06/2014&dad=06/17/2014&isp=1&PInUserRole=SchedulesInquiry&PInUserType=Public&PInINTTRAProduct=&carrierScac=
I really appreciate your help and support.
Thank You,
1 - I have a list of website that I want to open (Done)
2 - Each website may or may not have an Excel file to download. I want the code to try to open this file (Not completed).
3 - If a file is found, I want the data to be automatically downloaded in an Access Database if possible (Not completed).
Example of a website with an Excel file to download is below. The file if found on the top right of the middle table (arrow pointing down):
https://www.oceanschedules.com/schedules/schedule-search.do?&originId=216646&destinationId=170041&weeksOut=6&date=06-May-2014&origin=Miami, Florida,UnitedStates(USMIA)&destination=Beirut,Lebanon(LBBEY)&searchType=0&searchSort=2&showSurroundingPorts=Y&lad=05/06/2014&dad=06/17/2014&isp=1&PInUserRole=SchedulesInquiry&PInUserType=Public&PInINTTRAProduct=&carrierScac=
Example of a website with NO Excel file to download:
https://www.oceanschedules.com/schedules/schedule-search.do?&originId=211776&destinationId=1005497&weeksOut=6&date=06-May-2014&origin=Anchorage, Alaska,UnitedStates(USANC)&destination=Tanger Med, Tangier, Morocco (MAPTM)&searchType=0&searchSort=2&showSurroundingPorts=Y&lad=05/06/2014&dad=06/17/2014&isp=1&PInUserRole=SchedulesInquiry&PInUserType=Public&PInINTTRAProduct=&carrierScac=
I really appreciate your help and support.
Thank You,