pdf

Hi, My code below currently copy/paste each row from Sheet 1 (detailsSheet) to Sheet 2 (reportSheet) and then print/save it as a PDF on my desktop, and works great! As a next step (where I would appreciate some help), I would like to copy rows as long as the value in column A is the same. For...

Hello all, It's been a long time since I've used any VBA and it's not coming back like riding a bicycle... Hoping for some help on hopefully easy task. I have a sheet with tens of thousands of rows of invoice data -- each row is a discrete invoice with various columns of information, including...

Hi, I'm trying to import pdf bank statements directly into excel on my Mac. How can this be done without paying for software such as docuclipper. Windows users seem to be able to use the Power query editor, and can also clean up the spreadsheet after conversion but this doesn't seem to be...

Hello, first post. Will appreciate any help - even just a pointer to the correct place to look. I'm struggling to word this requirement but here goes: I have a data table in excel (a proper table). Each record contains a student and several other fields of use. It also details the teacher, and...

Hi All, I know this is not necessarily Excel-related, however, it is going to be VBA related. I have created a return-to-work form in word, which is sent to managers to complete return-to-work interviews for sick employees. The document is restricted and only form fields can be completed...

I'm implementing a 'live' and self-service reporting regime. I want managers to be able to access their own area's live data and take a snapshot of it at any point in time by saving selected sheets to a pdf file on their respective Desktops. The macro I've put together runs without errors - but...

Hi all Ive had a look through the discussion board and cant quite find what i was looking for, or the codes were very different. The idea is a macro button which saves to a specific location, saves as a PDF, saves name as todays date. Please find code below. Currently it is saving the PDF in...

Hi all, Please note I am very new to VBA. I have a list of hyperlinks in Column D and I found the below VBA code. It opens a web browser and give me a pop up to save the PDF. But it seems to have just googled the text in the cell rather than opening the link itself. What i am really after is...

Hey guys, I'm trying to make a macro that can save a pdf from an active sheet to the desktop without me specifying the user. Is this possible? I'm asking as the file is going to be used by multiple people and I'll have to replicate the macro 10 times. So to avoid changing the code 100 times to...

Hello friendly excel people 🙂 I've been scratching my head all day with this issue and it's really getting to me. I have a PDF doc containing a list of; suburbs/cities along with their postal code and state, organised in 7 columns across 35 pages on an A4 page. What I'm trying to do, is to...

Hi, i have a button on my spreadsheet to save the sheet as a PDF but i can figure out how to get it to create a copy of the file in excel with the same name and save both that copy and the PDF in the location of where the file original file is saved this is my code currently: Private Sub...

Hi Thanks for the help in advance on this matter. I wanted to have a button on a landing page of a workbook to print a specific sheet named "leather letter" on the excel file. So basically I would like that when someone clicks that button a prompt shows up with the "Save as" dialog so the...

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...

Hello Thanks for the help in advance! I wanted to have a button on a landing page of a workbook to print a specific sheet named "leather letter" on the excel file. So basically I would like that when someone clicks that button a prompt shows up to select the location to print only that sheet...

Hi there. I've searched everywhere and couldn't find a solution for this :cry: I'm trying to export an excel workbook as a single file with the following conditions: - The first sheet shouldn't be exported - The second sheet should be in duplicated - The last sheet should be included or...

Hi everyone, I am trying to make a userform where each sheet has its own corresponding checkbox. The goal is to print the selected sheets into a pdf upon clicking OK button. I have managed to somewhat achieve my goal. But it feels like it is far from being optimal. I had to assign 2...

Hi, Looking to use a Macro in excel that saves document as PDF but the file name needs to be: Cashing Up Week End (Cell N4) which is a date Hope someone can help! Thanks

I have a macro that prints several pdf's for schedules from one sheet. It takes about 10 minutes for the macro to run and make the 10 pdf's. Is there a way to make this run faster? Sub Create_Schedules() Sheet1.Activate ActiveWindow.View = xlPageBreakPreview Dim Yellow As String Yellow =...

Dear Members, I am using the following code to display photo from a folder in my excel sheet. Sub DisplayMainPicture() With Sheet1 On Error Resume Next .Shapes("ReceiptPic").Delete On Error GoTo 0 If .Range("I12").Value = Empty Then Exit Sub PicPath = .Range("I12").Value 'Picture Path If...