Need to Save current sheet to one of two files depending on data ( Q or I)

Hi there,

I have some code below that converts the current sheet to a PDF then uses data from B16, H8 and H10 to save as its filename, then it saves it to a certain file.

What I would like it to do is :

1) Convert active sheet to PDF.
2) Use the data from cells B16,H8 and H10 to save as the filename.
3) Check to see if cell H8 contains the letter Q if true then save file to C:\Documents and Settings\carl.walker\My Documents\Quotations\.
4) Check to see if cell H8 contains the letter I if true then save file to C:\Documents and Settings\carl.walker\My Documents\Invoices\.
5) Oh and still use the IF's and msgboxes.

I'm not really sure where to start to honest so any help would be much appreciated

Thanks in advance
Carl

Please Login or Register  to view this content.

Try this..

Please Login or Register  to view this content.

Hi Deb,

Thanks for replying, I've just ran the code but it's sprung up with a compile error (assignment to constant not permitted)?

Please Login or Register  to view this content.

Also forgot to add that I have taken away the reports folder and replaced it with a Quotation folder and a Invoice folder.


Regards
Carl

OOPS.. my appologize..

Please delete keyword Const from the 1st line, and use just Dim

Hi Carl!

Sorry.. I missed this post.. ;(

try this..

Please Login or Register  to view this content.

Try This..

Please Login or Register  to view this content.