Need Help on a Project at work

[projecthelp]

Hey Guys,

At work, I have a report that is essentially just copy and pasting our volume from our SAP/BI website and pasting it into an excel sheet. I feel like this can easily be done with Excel Macros, but whenever I try to search youtube videos on how to do it, I get confused. I go to the developer tab, press record data, go to the data tab, press import from web, go to the website, import the data. After I do that, I press stop macros, however when I try to run the macros again I get the macro name of personal.xlsb in front of the macro name and it doesn't run.

Can someone please help?
Thanks

 

[projecthelp]

Whenever I try to run the macro it gives me a run-time error '5':
Invalid procedure call or argument

 

[MARK858]

For the macro name, when you go to record the macro a dialog box appears and near the bottom is a box which says "Store macro in" and in the input box by the dropdown it probably says "Personal macro workbook".

Click the dropdown and change it to "This workbook" then re-record your macro and try running it, then post back with any issues.

If you get the same error post the code in the thread and state what line is highlighted.