.pdf

Hello, I have a database that stores attachments (not too many - 150 total). I am not familiar with VBA code - I only know enough to be dangerous. I've heard there is a way to export all my 150 .PDF attachment to a directory on my C:/ drive. My database name: Property Information Database...

I have a number of sheets that need to be exported as a .pdf but when all the print settings are defined (there does need to be an option to print via Excel as well) the actual .pdf output doesn't match the Excel print. As this .pdf is to be shared externally with clients it needs to be bang on...

I have 70 sheets in a workbook (Named LP01-LP70). This amount may increase to 150. Every month, I have to save these sheets as pdf's in a folder name that matches the current month: 17_08. Now, I have the following line-by-line instruction, in which I manually replace the month number every...

In the following macro i want to have an option save individual letters in .pdf format. I want save individual .pdf files in a particular folder with a file name of a cell in range, Can you please help me on this. Sub PrintForms() Dim StartRow As Integer Dim EndRow As Integer Dim...

Hi, I would like to generate individual .pdf files by using a data available in excel. It's like using a employee ID as file name create pay slip in a particular format. Please let me know if it can be done through macros, Thanks in advance.. Kind Regards, VK

Trying to make a macro to open a .pdf file whose file name contains the selected "Item number" in a spreadsheet. It will open in Internet Explorer. I'm getting close, I can open a file if its entire file name is the item number: Sub OpenPDF() Application.DisplayAlerts = False...

I'm building a report that uses slicers to select up to 258 different sets of data (3 slicers with mutiple selections each). I am hoping to write a macro to print all possible combinations of data selected via these 3 slicers. Does anyone have a macro that does something similar? Basically need...

Hi, I'm a newbie...just to state that up front, please don't throw rocks! ;) I'm a creative designer by trade, but have been getting into more 'expanded' requirements by clients. Anyways, here's my question, I have an ongoing monthly gig that I'm supplied with a spreadsheet that includes...

Good Morning Folks!:) I am trying to converts several worksheets into a .pdf document and have spent a few hours surfing and have come up with this so far: Sub PDFPrintNSave() Application.ScreenUpdating = False 'Sheets(Array("Sheet 1", "Sheet 2")).Sheet1 , , 1...

I was creating a form in Excel: BusinessName:___________________________________ Address:___________________________City:__________ (etc) I'll be compiling the results into a larger spreadsheet or table. ...and I realized this would be better as a .pdf form (that's an option, since I have both...

I am trying to open and search a .pdf using VBA in Excel. Ultimately, I want to search the pdf and put the first five characters following the found text from the .pdf in a cell in Excel. However, I am having issues with doing anything with the application. More details on the error I encounter...

Hello, I'm new to this forum and what better way to test the effectiveness / use of this place than to ask VBE questions! Essentially, I'm trying to write a code which will take multiple sheets with a workbook and save them individually as a .pdf displaying only that sheet. Some background: I...

Hi! I have a sheet with several hyperlinked documents. With using a filter function I can get a list of documents that I want to print out. So I need a macro to look at each hyperlink and find the filepath and name, copy the file to a destination folder like C:\test\ There is something with...

I have run across an odd behavior of Excel 2003. (This is also true in Excel 2000). I use a printer driver type of .pdf converter (pdf995) and it works perfectly with Word. I have a large workbook with many different worksheets. If I select several worksheets and print them to a printer, they...