Save as Macro named content of cell

[josullivan601632]

Hi can anyone help me write a macro. I'm all good with excel and basic recorded macros, but VBA and the more advanced stuff I always fail at!!! I am working on a spreadsheet with one main tab called "InternalQuote" which feeds information into various other tabs and I want to be able to click on an image (which I will assign to the macro) whilst in the "InternalQuote" tab to;

Save the whole workbook as a new xlsm. document named the contents of "K9" and "K7" of another tab called "Quotation"

I also want to click on another image (which I will assign to the macro) to save the tab titled "Quotation" as a PDF, named also as the contents of "K9" and "K7" which also will open once created for the user to check.

Is this possible? And would anyone be able to spare some precious time and send me something to perhaps (cheekily) copy and paste?

 

[josullivan601632]

Alas still returns the 400, painstakingly checked spelling. This is the code I have now

Can you re-check what I have?

 

[JW00]

I just tested it with both "Quotation" & "Panama 3 H203 D75 Brochure" & it worked fine, sorry I just don't get why you are getting the error.

 

[josullivan601632]

Maybe I need copy over into fresh sheets and re-try on Monday. Your help has been really appreciated and its probably a corrupt worksheet.

Have a lovely weekend

 

[JW00]

Monday sounds good, you have a good weekend too.