I have a macro that pulls in data from a website. However, I want the macro to self adjust depending on which week it is (i.e. the website url changes from week to week, but I don't want to create separate macros for every week. It the only thing that changes is 'week=1', 'week=2', ect. within the website name).
Any ideas? Thanks.