Retrieve Data Bug

[Ryuusenka]

Hi, so the guy before me at this firm used to run this VBA to retrieve data from other files. What it does is take a number from a separate file every day and then list it for the month.

I personally have limited knowledge of VBA. Today when I ran it (making no changes to the code) I got a 1004 error where the path name and date pulled was wrong. In debug, I highlighted the problem code in red. Any help would be much appreciated, thank you!

Please Login or Register  to view this content.

[FDibbins]

Hi and welcome to the forum

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

I will add them for you - this time

[Ryuusenka]

Thanks, sorry I didn't read the rules.