Macro Additions

[stangz71]

I have a macro that will allow me to pull down information from a website and all I need to do is modify the serial number which is on two lines (FA150) and the URL (https://Site.com/srPos=0&srKp=02i) and URL ID (srPos=0&srKp=02i_1). Each serial number will be different and the URL and URL ID will be different, is there an easy way to automate the addition of this information into the Macro with a list of serial numbers and URL and URL ID on a separate sheet?


***Lines to change *****

Please Login or Register  to view this content.

[rcm]

My suggestion is to use dropdpwn lists lets say in B2,b3 of a given sheet

Please Login or Register  to view this content.

[stangz71]

So the idea is to make all the additions I am looking to make to the Macro but have each addition reference one sheet but different cells, is that correct?

[rcm]

I understood that you wanted to partially automate the changing of the sheet name and URL.

So I suggested that the known names be place in droplists preferably in another sheet to facilitate the input of them.

Is that what you want? It can be further automated so after you have selected the names it runs...

[stangz71]

I will try it tonight and see how it works, thanks.

[stangz71]

The issue is that I have individual sheets with the serial number as the name so I would have to find a way to reference the information from another page and then delete the content on the corresponding serial name sheet and then copy the data. Any ideas?

[protonLeah]

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



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)