Exporting File as PDF w Excel - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Exporting File as PDF w Excel

Diana Sanchez

6 years ago

I have a form that I added a link to a simple excel file. Do you know of a way to export the form data in pdf along with the excel data? I am able to export it in pdf but I have no idea how to pull in that excel file data into that same pdf file.

	Alex Hedley @Reply 6 years ago
Export Reports to PDF One Click http://599cd.com/blog/display-article.asp?ID=1349 How are you linking to the Excel file? Is this just a field in your Table? You could link/import the Excel data into Access and add that to your Report and export it along with the other data.

	Diana Sanchez OP @Reply 6 years ago
I used a command button and added the address under "hyperlink address" section inside the property sheet. I put that button on my Form not a table. We need to add data in the excel file before saving it to PDF everyday and it needs to be in that specific format that the Excel file is in.

	Alex Hedley @Reply 6 years ago
Could you pull the data you need from Access into the excel file? Otherwise youd need some way to merge two PDFs

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View