MobileMobile | Continue

Excel Bar

Excel Bar

Your excel questions will be responsed by our excel experts within 24hrs.Our service is free.

 Forgot Pass?
 Register Now
Find
Hot Search: Vlookup Match VBA
12Next
Return Post new threads
View: 596|Reply: 16

Save excel work sheet as PDF and as excel

[Copy link]

4

Topics

16

Posts

40

Integral

Member

Rank: 2

Integral
40
Post on 2-11-2017 13:42:49 | All posts |Read mode
hello guys ,
I am lost in this I know my request is silly  but any one could help me with it

any one could help me to how I can save specific excel range in my excel work sheet as pdf file  and excel file also in folder with stander name  ?

thank you in advance




Reply

Props Report

11

Topics

130

Posts

283

Integral

Conqueror

Rank: 3Rank: 3

Integral
283
Post on 2-11-2017 14:27:19 | All posts



sub creatPDF()
ActiveSheet.Range(Your range here).ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
    D:\myPDF.pdf, Quality:= _
    xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, _
    OpenAfterPublish:=True
End subChange path according to yours











Reply Support Opposition

Props Report

4

Topics

16

Posts

40

Integral

Member

Rank: 2

Integral
40
 Author| Post on 2-11-2017 15:02:52 | All posts



thank you Imarn for your replay I need one more thing how to create folder so I can in save my pdf file in it .




Reply Support Opposition

Props Report

4

Topics

16

Posts

40

Integral

Member

Rank: 2

Integral
40
 Author| Post on 2-11-2017 16:16:46 | All posts



thank you Imarn for your replay I need one more thing how to create folder so I can in save my pdf file in it .
Reply Support Opposition

Props Report

11

Topics

130

Posts

283

Integral

Conqueror

Rank: 3Rank: 3

Integral
283
Post on 2-11-2017 16:19:20 | All posts



sub creatPDF()
ActiveSheet.Range(Your range here).ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
    D:\myPDF.pdf, Quality:= _
    xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, _
    OpenAfterPublish:=True
End subChange path according to yours











Reply Support Opposition

Props Report

11

Topics

130

Posts

283

Integral

Conqueror

Rank: 3Rank: 3

Integral
283
Post on 2-11-2017 19:04:49 | All posts



Do you want separate folder for every pdf ?









Reply Support Opposition

Props Report

4

Topics

16

Posts

40

Integral

Member

Rank: 2

Integral
40
 Author| Post on 2-11-2017 19:49:53 | All posts



what I want main folder for example (Production reports) and inside it folders named by dates
the main folder has been create for the first time and today I saved the report of the today inside folder contain today date and tomorrow when I want to save my report I need to save it in tomorrow folder date .
can that happen? if not just tell me the smile way hot to create folder.




Reply Support Opposition

Props Report

11

Topics

130

Posts

283

Integral

Conqueror

Rank: 3Rank: 3

Integral
283
Post on 2-11-2017 20:02:25 | All posts



Why not simply create Folder (Production Reports) and save the today's report with todays date as name of the report like
Sub CreatePDF()
ActiveSheet.Range(your range here).ExportAsFixedFormat Type:=xlTypePDF, _
Filename:=your path here like D:\Production Reports\  Format(Date, dd-mm-yyyy)
End Sub









Reply Support Opposition

Props Report

11

Topics

130

Posts

283

Integral

Conqueror

Rank: 3Rank: 3

Integral
283
Post on 2-11-2017 20:50:12 | All posts



you will have to create main folder one time manually. Then the code will save your report as PDF
Reply Support Opposition

Props Report

11

Topics

130

Posts

283

Integral

Conqueror

Rank: 3Rank: 3

Integral
283
Post on 2-11-2017 17:55:34 | All posts



sub creatPDF()
ActiveSheet.Range(Your range here).ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
    D:\myPDF.pdf, Quality:= _
    xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, _
    OpenAfterPublish:=True
End subChange path according to yours











Reply Support Opposition

Props Report

12Next
Return Post new threads

Points policy of this forum

Archiver|Mobile|Small dark house|Contact us|Excel Bar

GMT-5, 9-21-2017 14:35 , Processed in 0.169251 second(s), 20 queries .

Powered by Discuz! X3

© 2001-2013 Comsenz Inc.

!fastreply! Top !return_list!