Link a print and Save As Code to one button?

**countryred** · 02-05-2011, 06:53 PM

I am trying to make a button with two codes in it I have been reading but I can't seem to find what I am looking for.
I have a save as code and a print code but I want it to go to one button. Is this possible.
I am just learning this Macro stuff and want to learn more so please explain how to do this if possible.
Thank You

**TMS** · 02-05-2011, 07:37 PM

It would help if you posted a sample workbook with some typical data and the code you have developed and someone will help you to bring them together.

Regards

**JBeaucaire** · 02-05-2011, 07:38 PM

If your two codes are already working, then your button code can simply call those other macros.

Please Login or Register  to view this content.

**countryred** · 02-05-2011, 07:59 PM

Ok here are the codes that i have used and maybe I need something different. Like I said I am just learning.
Sub MySave()
ActiveWorkbook.SaveAs "C:\MyPath\MyFile.xls
End Sub

Sub My Print()
ActiveSheet.Printout
End Sub
I have these on seperate modules and they do work individually but I would like them to work together on one button.
Thanks for the help.

**john55** · 02-06-2011, 09:07 AM

hi countryred,

try this

Please Login or Register  to view this content.

john

**BleuDrache** · 07-02-2014, 05:27 PM

Hey john55, I'm trying to use that code to save and print as well, but there's one tiny little detail: I want to create the file for my virtual record, but how could I code it in order to get a different name everytime? Maybe to include a date number after the name (MyFile.xls in your sample), taking it from one of the cells in my workbook, so everytime it will look like: (MyFile02142010.xls) and the day after: (MyFily02152010.xls).

I would appreciatte your help so very much!

o

**Fotis1991** · 07-03-2014, 02:29 AM

Welcome to the forum.

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.