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...
Hello,
Ultimately, I am trying to have my excel sheet saved as a PDF and then emailed. I have figured out a way to do that, however once I started tweaking it, I realized I am way out of my league.
I need to also be able to:
(1) save the file as the value in cell A40 of the current sheet...
Hello all.
I am trying to save one worksheet from a workbook of many sheets as a pdf to a different destination. I found a code in this forum that works according to the thread. I will post it here:
Dim Path As String
Dim SaveAsStr As String
Path = Sheets("Combined...
Hi all,
I currently have this code, which saves my sheet (entitled "Sheet3") as a PDF:
Option Explicit
Sub SaveFileWithMacro()
Dim Path As String
Dim fn As String
Path = "S:\Path\PDF files\"
fn = Range("A63")
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=Path & fn & ".pdf"
End...
Hi all,
I currently have a macro that converts my excel sheet into a PDF and saves it in a designated folder. However, I only want it to save the first sheet as a PDF, and ignore my other sheets, which it will not do at the moment.
My code looks as follows:
Option Explicit
Sub...
code
excel
ez win 16-0
ezz
ezzus sverkus
fast
haha ez win guys
help
jonas svaerke
macro
pdf
roessel
sanoj ekrævs
saveaspdf
svorktallica
vba
vba code
vlookup
Hi all,
I have this overview at the moment:
If I manually choose to save my file as a PDF, it works fine and I get just 1 page with the overview above.
However, I have the following VBA code to save my file as a PDF:
Option Explicit
Sub SaveFileWithMacro()
Dim Path As String
Dim fn As...
I have data in Sheet1 in Column A & B, I want 5 Rows from Sheet 1 to copy into Sheet 2.
For example I want the data from Sheet 1 A1:A5 to copy into Sheet 2 A8 to A12 and B1:B6 to copy into C8 to C12 of Sheet 2 and save the page as PDF in desktop then continue the process till last row of...
I think I am close on this, but it is not quite working as intended. The first version of this VBA was originally created to loop through a list on the "CertData" sheet and print the output as a defined range on sheet "Certificate". This worked perfectly, but I would rather have it loop...
Hi all,
I currently have the following setup:
I have marked everything that I want to be exported into a PDF, which works when I manually save the file as a PDF.
However, I do also have a macro ("Save file to folder") as seen above, which saves the file (albeit as an Excel file) to my...
'This method Saves each of the worksheets of current
'Excel file as individual PDF File using Excel VBA
Sub SaveEachSheetAsPDFFileED()
Dim wsA As Worksheet
Dim wbA As Workbook
Dim WS_Count As Long
Dim strFile, myfile As String
Set wbA = ActiveWorkbook...
Hi all,
I would like to make a button on each sheet of a workbook which will save the sheet (excluding the button) as a PDF to the desktop.
Each sheets starts off as a blank sheet, the blank sheet is copied and data entered, sheet renamed as needed.
The data on each sheet will be reviewed...
I have 27 sheets in an Excel file and file name is blank.xlsm. Except the sheet name COUNT and RAW DATA, I want that all other sheets to be save as PDF in the address
C:\Users\jyotirmaya\Desktop\Macro by using file name as Sheet name, all other 25 sheets have unique names. I have data from...
I want to save certain sheets as a PDF file with a specific path, have a default file name with the option to edit the file name which also opens the PDF file.
Seems to work with desired path and option to change default file name, but the PDF file is never saved and the code continues to the...
I am running an excel macro that saves it as a PDF. I want it to pop up with a default file name and ask the user if they want to overwrite it. If they say yes, then overwrite, but if they say no, then they should be prompted to change the file name. It does this, but if the user selects save...
Good Morning!
I have vba that purges data for public posting, then saves each tab (named range) as a separate pdf to combine & post to the web. I'm getting a Run-time error '1004' "This formula is missing a range or a defined name" on Named Range(Table_7), on Tab "Table 7", when trying to save...
Hi everyone I am trying to make a excel file with vba codes. Plan is that file save datas, choose information daily, open an existed word object (.dotm) change bookmarks I create and save it. All is fine till save as a .pdf and send e-mail via outlook app. I already do this in excel with active...
Hi,
I would like to create a macro which does the following:
1) Write a string in cell J16 in "worksheet1". The first string is taken from cell B2 in "Worksheet2". Step 1-3 should be repeated for the range B2-B292 in "Worksheet2" (290 times)
2) The string in cell J16 is used by other cells in...
Hi All,
i'm not having much luck with vba for word so i'm trying a work around.
is there a way to save a copy of a word document AS a pdf with the name being a cell value in excel?
let me give you my exact example. I have an excel with a few command buttons, one command button opens a...
hi all,
i'm trying to create a command button in word and attach a macro that automatically saves the doc as a pdf to a specified folder with file with the name coming from 2 bookmark references with a space and dash in between name.
here is what i have so far:
Private Sub...
Hi,
I have the following code for saving as PDF:
Private Sub LagrePDF_Click()
Application.DisplayAlerts = True
If Sheets("Lister").Range("BQ3").Value = "x" Then
If Sheets("Rapport").Range("AE6").Value = "" Then
Call PdfGnrBnr
Else: Call PdfGnrBnrFnr
End If
Else...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.