Dialogue prompt required when running macro.

[X82]

I have recorded a macro which put simply, goes to a website, takes the information from the page, puts it into a spreadsheet and formats it.
The site address is like this: \\website.com\Amber\Documents\File-215.htm
The bold above are the 2 factors which will change.
Ideally, I would like to press the macro button and a dialogue box with 2 elements appear. One with a dropdown(?) which will allow me to change the amber string. So Green, Amber or Red. The second part, 215, would be an input box, so I could enter 3 digits myself.
Upon pressing the button I could select green and type in 332, so the file it tries to grab would be:

\\website.com\Green\Documents\File-332.htm

Obviously I have had to change the actual url for security reasons and my job longevity.

Here is what I currently use:

Please Login or Register  to view this content.

Majority of it is taken up with formatting. But any help on this would be amazing. Currently I have 3 sets of buttons (Green/Amber and Red) for site 215 and then I have to copy the macro over again and again for other sites. Buttons, buttons everywhere.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[X82]

Wow, that looks like it is working great. One thing however, I stupidly left out a vital bit of information.
While the Amber and site does change depends on the user input, I need it to import 3 files with one press instead of one.
At the moment it will look for
"\\website.com\" & x & "\Documents\"

But for our reports we need 3 files, located in the following locations. The first one, Documents is perfect. There is also another but not in a directory (same naming structure) and a third for recycle bins. Here is the file layouts:

Please Login or Register  to view this content.

Sorry, I forgot this information previously. I could just duplicate the macro 2 more times and tweak it myself, but I was hoping for an all in one solution.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[X82]

THanks for that.
However the macro does error
It will say the document File-215.html is already open when it gets to the line:

Please Login or Register  to view this content.

[JOHN H. DAVIS]

That's what I thought you were asking for in Post #3 to open those additional files by macro?

[X82]

After using your initial code, a lot of googling and some guess work, I managed to make a script which does everything I need.

1. It takes all 3 html files
2. Copies only the areas I want
3. Opens a blank pre-formatted excel sheet
4. Pastes that into the correct tab and cell
5. applied some formatting to the pasted text
6. closes all other files
7. and saves the blank file as a new file, appending the filename with the date and site number.

I know it is probably a complete mess, code wise and a lot can be tweaked and trimmed, but for a first go, I'm happy with it.

Please Login or Register  to view this content.

In an ideal world, I would like a form to pop up, rather than an input box, where is a dropdown for the colours and an area to input the 3 digit code, with an GO and cancel button. Currently if I run the script and wish to come out, I have to cancel out of errors etc. Not an issue for me but if I want to hand it to the troop here, it will be a headache.