+ Reply to Thread
Results 1 to 13 of 13

Save in PDF a excel sheet

Hybrid View

  1. 07-26-2013, 09:58 AM #1
    bisho01
    bisho01 is offline
    Registered User
    Join Date
    07-26-2013
    Location
    paris
    MS-Off Ver
    Excel 2007
    Posts
    6

    Save in PDF a excel sheet

    Dear all,

    I am a brand new user on the forum, thus HELLO everyone !

    I encountered an issue to create a macro allowing to save a excel sheet 2007 in PDF format.

    Particularity of my sheet "Site PROFILE :
    In the cell B5 of "Site PROFILE" I have to type a code which allow to consult the results of each code ("sheet1").
    To sum up I have only one sheet "Site PROFILE" for several results.

    Request
    I tried to create a macro which type every code containing in the "sheet1" and save each code in my DOCUMENTS folder for instance, but Its not working at all...So, someone could kindly help me?

    Many thanks for your help and advice in order to help me to build my Macro "Module 8" in the file attached.

    Kind regards,
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 07-27-2013, 05:32 AM #2
    blue.chio
    blue.chio is offline
    Forum Contributor
    Join Date
    03-14-2012
    Location
    location
    MS-Off Ver
    Excel 2007
    Posts
    170

    Re: Save in PDF a excel sheet

    perhaps something like this
    Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("b5")) Is Nothing Then
Application.DisplayAlerts = 0
Dim oRange As Range
Dim oCht As Chart
Dim oImg As Picture
Set oRange = Range("a1:k171")
Set oCht = Charts.Add
oRange.CopyPicture xlScreen, xlPicture

oCht.Paste
oCht.Name = ActiveSheet.Name
oCht.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
        ThisWorkbook.Path & "\" & Sheet2.Name & ".pdf", _
        Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:=False
        
        oCht.Delete
        Application.DisplayAlerts = 1
End If
End Sub
    and welcome to the forum!
    Last edited by blue.chio; 07-27-2013 at 05:37 AM.
    blue
    Reply With QuoteRegister To Reply
  3. 07-29-2013, 05:18 AM #3
    bisho01
    bisho01 is offline
    Registered User
    Join Date
    07-26-2013
    Location
    paris
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Save in PDF a excel sheet

    Hello,

    Thank you for you reply Blue, but unfortunatly I dont know how to use your macro...When I incorporate your code witihn my Macro Its not working at all. I suppose I missed something important.

    If you could help me with it will be great !

    Many thanks,
    Reply With QuoteRegister To Reply
  4. 07-29-2013, 05:48 AM #4
    blue.chio
    blue.chio is offline
    Forum Contributor
    Join Date
    03-14-2012
    Location
    location
    MS-Off Ver
    Excel 2007
    Posts
    170

    Re: Save in PDF a excel sheet

    see the file attached
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  5. 07-29-2013, 06:56 AM #5
    bisho01
    bisho01 is offline
    Registered User
    Join Date
    07-26-2013
    Location
    paris
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Save in PDF a excel sheet

    Blue,

    When I click on the shape "Save pdf whole sheet" I can see that creates a spreadsheet "chart1" with the code 7508 only, but after that I have the message error 5 "Invalid procedure call or argument".

    Thanks
    Reply With QuoteRegister To Reply
  6. 07-29-2013, 07:11 AM #6
    blue.chio
    blue.chio is offline
    Forum Contributor
    Join Date
    03-14-2012
    Location
    location
    MS-Off Ver
    Excel 2007
    Posts
    170

    Re: Save in PDF a excel sheet

    not sure, I have yr file on my desktop and it creates a pdf (on desktop too) named as sheet name
    Reply With QuoteRegister To Reply
  7. 07-29-2013, 07:31 AM #7
    bisho01
    bisho01 is offline
    Registered User
    Join Date
    07-26-2013
    Location
    paris
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Save in PDF a excel sheet

    You created the macro on the module 4 ? I
    Reply With QuoteRegister To Reply
  8. 07-29-2013, 07:42 AM #8
    blue.chio
    blue.chio is offline
    Forum Contributor
    Join Date
    03-14-2012
    Location
    location
    MS-Off Ver
    Excel 2007
    Posts
    170

    Re: Save in PDF a excel sheet

    yes, in module 4 you find this piece of code, also you can find it in worksheet module, so if you change the value in cell b5 the pdf shold be created, but as you said it did not work for you.
    read this http://msdn.microsoft.com/en-us/libr...ffice.12).aspx and try to do a test using the below code
    insert a new module, copy/paste this code and then from meniu-macro run pdf
     Sub pdf()
  ActiveSheet.ExportAsFixedFormat pbFixedFormatTypePDF, "asdf.pdf"

End Sub
    Reply With QuoteRegister To Reply
  9. 07-29-2013, 08:20 AM #9
    blue.chio
    blue.chio is offline
    Forum Contributor
    Join Date
    03-14-2012
    Location
    location
    MS-Off Ver
    Excel 2007
    Posts
    170

    Re: Save in PDF a excel sheet

    this is your sheet saved as pdf using that code.
    perhaps someone else has another approach to save it as pdf.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  10. 07-29-2013, 08:39 AM #10
    bisho01
    bisho01 is offline
    Registered User
    Join Date
    07-26-2013
    Location
    paris
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Save in PDF a excel sheet

    First of all, thanks you so much for the time spend to help me.

    Secondly, I saw when I change the code, the macro creates a chart1 sheet as a picture format but not saved in my desktop and with the message error 5...

    My request was, could we automticly save all the code including in the sheet 1 in PDF in the desktop for instance? Because with your Macro we have to type each code no?

    Many thanks,
    Reply With QuoteRegister To Reply
  11. 07-29-2013, 08:51 AM #11
    blue.chio
    blue.chio is offline
    Forum Contributor
    Join Date
    03-14-2012
    Location
    location
    MS-Off Ver
    Excel 2007
    Posts
    170

    Re: Save in PDF a excel sheet

    just record a macro saving the activesheet as pdf...but your charts won't be there!
    I am sorry, I have no other idea!
    Reply With QuoteRegister To Reply
  12. 07-29-2013, 09:00 AM #12
    bisho01
    bisho01 is offline
    Registered User
    Join Date
    07-26-2013
    Location
    paris
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Save in PDF a excel sheet

    OK thanks for your quick reply.
    I'll conitnue to investigate how could I get all my codes saved in pdf format.
    I'll post my resolution if I'll succeed,

    Bye,
    Reply With QuoteRegister To Reply
  13. 07-29-2013, 09:02 AM #13
    blue.chio
    blue.chio is offline
    Forum Contributor
    Join Date
    03-14-2012
    Location
    location
    MS-Off Ver
    Excel 2007
    Posts
    170

    Re: Save in PDF a excel sheet

    Thanks for the feedback and I am really sorry I can not help you!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. save another sheet of excel
    By makhdoomliaqat in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-03-2013, 10:53 AM
  2. save excel sheet as an xml file
    By CELTICTIGGER in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-13-2011, 11:16 AM
  3. I have code to save a string as UTF8 - I need to save an entire Excel SHEET as UTF8!
    By schnide in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-16-2011, 11:49 AM
  4. Excel 2007 : Cannot save my excel sheet . . .
    By eng_mohammedmostafa in forum Excel General
    Replies: 2
    Last Post: 06-11-2010, 08:15 AM
  5. save from template to excel sheet
    By ELZNHS00 in forum Excel General
    Replies: 0
    Last Post: 08-02-2006, 12:55 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1