I have several macros in a workbook, one to extract data from SharePoint lists, another to sort and cleanse the data and save it as a CSV file and another to open a specified webpage in Internet Explorer then select several links to navigate to a page where the user can upload the CSV file. The below code checks if the user is already logged in (using the title of the page to determine if the user is logged in or not). It then navigates/clicks through 3 links to get to the desired page and clicks the button to open the screen to allow the user to then select which CSV file to upload (my understanding is that this part can not be automated ~ if it can please point me in the right direction).

Occasionally the code will work if I press F8 to step through each line (takes a long time due to looping through to enter the username and password). However if I play it directly then I get a 'Run-time error '424': Object required error and I cant seem to work out why this is happening? My understanding is that the code checks if the webpage has loaded successfully before each click on a link.

Can anyone see the issue and provide some guidance on how to resolve it please?

Regards.

Please Login or Register  to view this content.