Hi all,
I've got a lot in one post really. I know what I want, but not the best way to go about it. I'm trying to eliminate the whole copy and paste procedure when creating reports.
There are Red, Amber and Green scores for each section and an overall percentage score. When items get a "Red"...
Hi All
I have a problem where I need to export 3 worksheets as a single PDF file.
I had one doing it as 3 seperate PDF files, which is below:
Sheets("Campaign Summary").Select
pdfName = ActiveSheet.Name
ChDir ActiveWorkbook.Path & "\"
fileSaveName = ActiveSheet.Name...
Hey everyone,
First time posting here, I was hoping I could get some help with a small piece of code. I have a folder full of invoices and each invoice is a separate excel workbook (totaling over 400 files). The prepared invoice is the first sheet titled "Summer Invoice" of each workbook. What...
Hi, I've situation like this.
In "Data" sheet i'll have data like below list
<colgroup><col><col><col><col></colgroup><tbody>
Emp. No
Name
Category
Amount
12236
ABCD
Telephone
$2100
12243
EFGH
Medical
$4200
12256
IJKL
Telephone
$1566
</tbody>
The above data should come in the...
Hi Guys,
I have a VBA code that cycles through my pivot filter and prints the file to PDF. It filters the vendor number and I print a summary for each vendor. The problem is one vendor has 4 different summaries and each pivot is on a different worksheet. When I run the below Macro, it saves 4...
Trying to open a PDF that has a fillable text field and link it with a cell, this is the best i have found, but it just seems to be opening my PDF and not adjusting the text.
Sub AcrobatFindText2() <o:p></o:p>
<o:p></o:p>
'variables<o:p></o:p>
Dim Resp 'For message box responses<o:p></o:p>
Dim...
Hi! This is my first time posting here although I've used a several examples to help me write basic macros.
I am completed stumped on a project that I thought would be fairly easy. I have an excel file that contains a worksheet for each site (location) that was included in a survey. I found...
Hi Excel world,
Been looking for a solution for this for hours and my eyes hurt.
I have a worksheet that is an individual program that is set up with Vlookup's etc that feed into this worksheet. On the worksheet (labelled "Program") there is a drop down menu with the name of the person in cell...
My IT dept uninstalled and reenstalled Excel on my PC the other day. Every since then I have had trouble executing some of the code I use. I seem to get an error when it gets to the part were its saving it to a PDF.Im using 2007. Thanks as always
Sub job_send()
If Dir("H:\") = "" Then...
Hi,
I have a tool that produces a set of outputs in the form of a quote in a tab called "SalesQuotation".
On this worksheet, i have a button which when clicked runs the following VBA
Sheets("SalesQuotation").Range("A1:J70").ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
"C:\Users\"...
I found this macro code VBA code to convert excel to pdf and email it as attachment
that PDFs an excel sheet, attaches it to an email and sends it out. And it works great.
I'm looking for one modification. I want my recipient list to be of email addresses in range B46:B60 that are on a sheet...
Hi,
I have just started a new job recently and have given given the task of creating the excel of all the pdfs brochure they have. now i can copy paste the things from pdf to excel but that is really cumbersome and boring, can anyone please help me converting the pdf to attached excel format, i...
I am needing to print multiple pdf files by file name that is in a list. These files will be in the same folder as the excel file. For example MMR1234, MMR1235, MMR1236 and stop on next blank cell. Then I am needing it to close Acrobat after printing.
Hey guys!
I'm fairly new to VBA so forgive me if I sound all confused. I have a worksheet in excel which I need to print out as a PDF file. Is there any way I can do this? Is there a function I can use to output the information on the sheet as a PDF file in VBA?
Please let me know!
Thanks...
Some excel files give me a problem saving as a PDF file, especially longer named files, it just does not convert them to PDF no errors/warnings. I can have a file that I want to save to PDF as xxx; xxxx; 2009(10).pdf and it will not save, but it might save as simply 1234.pdf. As far as I can...
I am LOST! I have created a form in excel 2010 with multiple grouped Option buttons. I need to now save this form in pdf format but still want my Option buttons to work. Is this possible? If so, please help me in BASIC, SIMPLE steps. Thanks Excel peeps!
Hi All
I have been reading some posts on here regarding macros that can be written to force an excel sheet to save as .PDF. This is along the lines of what I am looking to do, but I require a slightly more complex solution.
I have a report that is generated daily, by up to 10 different...
Hi there, hoping someone can help. I've been searching and experimenting for weeks with no luck so far.
For my work I was tasked with coming up with an electronic system to gather data from the field. I created a spreadsheet form weighing in about 2mb to be run off a touch Tablet with an atom...
I'm working for a campaign and we have an invite mailer going out. I was told to get the list to the girl handling everything with the printers. Of course, last minute, I realized that the Voter Vault list was PDF and I want to make it easier for the household names/addresses to be used by the...
Hi,
I need to copy the text of 620 pdf files in one folder to excel. The task involves: open one pdf file from the folder, select all, copy and paste the text to the column of excel. Close this pdf file and then open another pdf file, select all, copy and paste the text to the next column in...
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.