Hello VB gods,
I have searched past posts but have found nothing quite suited to help with my macro solution.

In essence, I want a macro that I can attach to a button that will;

a) Select a range of values in Active Sheet (eg. A4:A67)

b) Save to a Txt (.txt) file with a specific name from cell "A1" in active sheet

c) Prompt the user as to where he/she wants to save this file (desktop, documents folder,...etc)

d) and Once the txt file is saved, the macro will prompt the user if they want to email to a specific address. if the user select yes then it activates the default email program and attaches the file with the subject header "Gas Log file" and emails to a specific address e.g. "gaslog@gmail.com"....if the user select no, then it only just saves the txt file.

Pls help excel gurus/gods. Much appreciate it in advance!!!