automatically rename workbook with cell input

's Computer Specifications

I am trying to add a command button to save a sheet into pdf format using the
value of one of its cells for its file name

's Computer Specifications

1) What version of Excel are you in?
2) What format do you want to save it in?
3) Does the cell have the full file path or just the file name?

"mcfly" wrote:

> I am trying to add a command button to save a sheet into pdf format using the
> value of one of its cells for its file name

's Computer Specifications

I am using 2007 office and I want to save it in PDF.
I use the workbook to give customers a price quote. I have a a few
wooksheets that have a cell in them that is connected to one worksheet that
counts up when a function button is clicked, this is how I get new numbers
for each sheet when I save them as a quote.

"Barb Reinhardt" wrote:

> 1) What version of Excel are you in?
> 2) What format do you want to save it in?
> 3) Does the cell have the full file path or just the file name?
>
> "mcfly" wrote:
>
> > I am trying to add a command button to save a sheet into pdf format using the
> > value of one of its cells for its file name

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to input pictures automatically based on cell input?	bsharp	Microsoft Excel Worksheet Functions	9	30th May 2009 07:16 AM
automatically move cell data in 1 workbook to another workbook	=?Utf-8?B?R2VuZXNpcw==?=	Microsoft Excel Worksheet Functions	1	5th Nov 2006 07:35 PM
Send workbook automatically as attachment based on input from user	=?Utf-8?B?U29ueQ==?=	Microsoft Excel Programming	6	3rd Oct 2006 02:41 PM
Rename a Worksheet on Input of Value in Cell	John	Microsoft Excel Worksheet Functions	1	24th Aug 2006 05:29 PM
How do I automatically rename a sheet with the contents of a cell.	=?Utf-8?B?bWljaGFlbHNwZWFyaW4=?=	Microsoft Excel Misc	3	3rd Dec 2004 09:27 PM