Sorgu için arama sonuçları: ExportAsFixedFormat

...("sipariş no boş bırakılamaz") Exit Sub End If Set shsayfa = Sheets("sipariş") yol = ActiveWorkbook.Path & "\" & [K6] shsayfa.ExportAsFixedFormat Type:=xlTypePDF, Filename:=yol & [A1] & " " & [B2] , Quality:=xlQualityStandard, _ IncludeDocProperties:=True, IgnorePrintAreas:=False...

...= False Then MkDir Yol End If Say = fL.getfolder(Yol).Files.Count + 1 Sheets(Array("Terfi Onay Formu")).Select ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=Yol & "\" & dosya_adi & Say & ".pdf", _ Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False...

...Dim yol As String yol = ActiveWorkbook.Path & "\" & ad & " " & siparisNo & ".pdf" Sheets("sipariş").ExportAsFixedFormat Type:=xlTypePDF, Filename:=yol, Quality:=xlQualityStandard, _ IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:=True MsgBox "PDF OLARAK DOSYANIZ...

...bırakılamaz") Exit Sub End If Set shsayfa = Sheets("sipariş") yol = ActiveWorkbook.Path & "\" & [K6] shsayfa.ExportAsFixedFormat Type:=xlTypePDF, Filename:=yol, Quality:=xlQualityStandard, _ IncludeDocProperties:=True, IgnorePrintAreas:=False...

Merhaba. Aktif sayfayı kaydeder. Sub Test() Range("A1:J54").ExportAsFixedFormat Type:=xlTypePDF, Filename:= _ Environ("UserProfile") & "\Desktop\" & Range("N1") & ".pdf", Quality:=xlQualityStandard, _ IncludeDocProperties:=True, IgnorePrintAreas:=False...

...Sheets.Select DOSYAYOLUADI = ThisWorkbook.Path & "\" & ActiveSheet.[A1].Value & Format(TARIH, "YYYYMMDD") & ".PDF" ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=DOSYAYOLUADI, Quality:= _ xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, _...

merhabalar hocam, ilginiz için çok teşekkürler ancak istediğim tam olarak olmadı. totalde 3 işlem yapması gerekiyor. pdf yapmadan önce yazıcıyı "Microsoft Print to PDF" yapması (excel dosyasını vereceğim personellerde farklı yazıcı seçili olduğunda sayfa yapısı pdf yaparken bozuluyor) excel...

...Sub PDFKAYDET() ActiveSheet.PageSetup.BlackAndWhite = False ADSOYAD = [F55].Value DOSYAADI = "" & ADSOYAD & ".PDF" ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _ "C:\PDF_DOSYALAR\" & DOSYAADI & "", Quality:= _ xlQualityStandard, IncludeDocProperties:=True...

objWord.ActiveDocument.ExportAsFixedFormat OutputFileName:=Klasor & "\" & dosya_adi & " " & say & ".pdf", ExportFormat:=wdExportFormatPDF yukarıdaki bölümü aşağıdaki ile değiştir. objWord.ActiveDocument.ExportAsFixedFormat OutputFileName:=Klasor & "\" & dosya_adi & ".pdf"...

...dt_issue = Range("f14") fname = invno & " - " & custname & " - " & PIno & " - " & POno & " - " & dt_issue ActiveSheet.ExportAsFixedFormat _ Type:=xlTypePDF, _ IgnorePrintAreas:=False, _ Filename:=path & fname Set nextrec = Sayfa3.Range("A1048576").End(xlUp).Offset(1, 0) nextrec.Value =...

...dt_issue = Range("f14") fname = invno & " - " & custname & " - " & PIno & " - " & POno & " - " & dt_issue ActiveSheet.ExportAsFixedFormat _ Type:=xlTypePDF, _ IgnorePrintAreas:=False, _ Filename:=path & fname Set nextrec =...

...dt_issue = Range("f14") fname = invno & " - " & custname & " - " & PIno & " - " & POno & " - " & dt_issue ActiveSheet.ExportAsFixedFormat _ Type:=xlTypePDF, _ IgnorePrintAreas:=False, _ Filename:=path & fname Set nextrec =...

...Range(c34) dt_issue = Range("f14") fname = invno & " - " & custname & " - " & PIno & " - " & POno & " - " & dt_issue ActiveSheet.ExportAsFixedFormat _ Type:=xlTypePDF, _ IgnorePrintAreas:=False, _ Filename:=path & fname Set nextrec = Sheet3.Range("A1048576").End(xlUp).Offset(1, 0) nextrec =...

Bu satırı silin Sheet3.Hyperlinks.Add anchor:=nextrec.Offset(0, 6), Address:=path & fname & ".pdf" yerine aşağıdakini ekleyin. Sheet3.ExportAsFixedFormat Type:=xlTypePDF, Filename:=Path & fname & ".pdf"

...dt_issue = Range("f14") fname = invno & " - " & custname & " - " & PIno & " - " & POno & " - " & dt_issue ActiveSheet.ExportAsFixedFormat _ Type:=xlTypePDF, _ IgnorePrintAreas:=False, _ Filename:=fname Set nextrec = Sheet3.Range("A1048576").End(xlUp).Offset(1, 0) nextrec = invno...

...".pdf" Do While Dir(MyFileName) <> "" Counter = Counter + 1 MyFileName = MyPath & "Sayfa8_" & Counter & ".pdf" Loop ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=MyFileName, Quality:=xlQualityStandard MsgBox "Form PDF olarak kaydedildi: " & MyFileName, vbInformation End Sub...

...Sayfa6.PrintOut Sayfa7.PrintOut End Sub Sub kod() isim = "Form_" & Format(Now, "yyyymmddhhnn") & ".pdf" Sheets("Sayfa8").ExportAsFixedFormat Type:=xlTypePDF, _ Filename:=CreateObject("WScript.Shell").SpecialFolders("Desktop") & "\Formlar\" & isim, _...

...<> "" Counter = Counter + 1 MyFileName = MyPath & "Form_" & Counter & ".pdf" Loop ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=MyFileName, Quality:=xlQualityStandard MsgBox "Form PDF olarak kaydedildi: " & MyFileName, vbInformation End Sub...

Merhaba, Deneyiniz... Sub kod() isim = "Form_" & Format(Now, "yyyymmddhhnn") & ".pdf" Sheets("Form").ExportAsFixedFormat Type:=xlTypePDF, _ Filename:=CreateObject("WScript.Shell").SpecialFolders("Desktop") & "\Formlar\" & isim, _ OpenAfterPublish:=False End Sub

...& ".pdf" ' Eğer aynı isimde bir dosya yoksa PDF olarak kaydet If Dir(dosyaAdi) = "" Then ThisWorkbook.ExportAsFixedFormat Type:=xlTypePDF, Filename:=dosyaAdi, Quality:=xlQualityStandard MsgBox "Fatura PDF olarak kaydedildi.", vbInformation Else MsgBox...