Hello VB gods,
I have searched past posts but have found nothing to really help me 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 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
I have searched past posts but have found nothing to really help me 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 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
