Excel Macro for Save as PDF (to a share point folder)

[drefiek2]

Hi,
I am very new to macros and would like to know how I can do the following. I have a single sheet in an excel workbook and I want a button which will:
1.save the sheet (an array of cells) as a PDF (landscape) in a particular work sharepoint folder
2. The pdf file name should be whatever is in cell C3
3. If the save is successful I want a pop up message box to say that. If it is unsuccessful I would like an error message box to say that.


Thank you in advance.

 

[drefiek2]

One way:

    Select Case MsgBox("Have you checked the date?", vbYesNo Or vbQuestion, Application.Name)
    Case vbNo
        Debug.Print "User exit"
        Exit Sub
    End Select

Place the code near the start of your macro.

This new question does not have much to do with the original topic of this thread. A thread on Mr Excel has two main purposes. The first is to help the person who created the thread and posted the question (in this case, you). The second is to help other members of the forum that might have a similar problem and are searching for posts that could help them. Changing the topic and asking questions on a different subjects defeats the second purpose, so the better course of action is to create a new thread for new and unrelated questions.

It works, thank you very much and I note your comments.