Saving A File Name Of A Cell

R

radicalrom

I am currently running Excel 2003. I have 2 questions that I reall
hope someone could help with.

Actually it is a 2 part question, dealing for me with the same area.

What I am looking to do is create a button which I understand how t
do, but what I would want this button to do is first look at a specifi
cell to get a name. Once it has the name, save the file off under thi
name. So let's say I have cell A1 and the value is "RadicalROM"
eventhough my current file name is "Testing" it would do a save a
"RadicalROM". Ok that is the first part. The second part of th
button (this needs to be one button, FYI also, so I need to figure ou
how to tie both of these things into it) needs to send as an attachmen
which I understand how to do but were I am drawing a blank is how do
automatically pass over an email address to outlook so the user doe
not have to enter an email address?


Thank you for all your help!

RadicalROM
[email protected]
 
J

Jerry W. Lewis

A good way to learn to program tasks that you can do manually is to
record a macro while you do it. This usually explicitly controls many
default items, so you can make the code more compact by editing.

In the case of Save As, this will get you to
ActiveWorkbook.SaveAs (fname)
where you can get fname from say B3 as
[B3].Value

Someone else will have to field the second question.

Jerry
 
R

radicalrom

Wow, thank you folks for a quick reply. Let me read up on this and
will go from there. Thank you again
 
Top