• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to export an excel file to IE as pdf

M

MalR

Member
Hi guys. On our web we daily inert a 5 page excel file. Done by saving it as a 97-2003 workbook in order to get it to display in IE and saving using the transpose function to get it to run down the web page. I manage the web using Joomla under content Management.
All that is fine and it has been working successfully except recently the file will not display in IE but does in all other browsers. My web designer says that this is because Microsoft has changed something in one of the latest updates and this has created the problem.
He suggested that I try exporting the file as a pdf.
I am having difficulty doing this and ask for suggestions. The help does not show what I want for my excel version.
I use Excel 2010 and need to export this excel file into IE.
Saving the file as a pdf then importing it from IE does not work as IE seems to only accept some file formats. I understand I have to export it from Excel into IE as a pdf but cannot find how to do this.
Does anyone have suggestions or can point me to a link please.
Thanks
Mal
 
Hi, MalR!
You can use the workbook method ExportAsFixedFormat and in the 1st parameter Type choose xlTypePDF or xlTypeXPS. This if you wanna stay within the native Excel features.
Otherwise you can download and install Adobe Acrobat complements or any other add-in that does the job.
Regards!
 
SirJB7 said:
Hi, MalR!
You can use the workbook method ExportAsFixedFormat and in the 1st parameter Type choose xlTypePDF or xlTypeXPS. This if you wanna stay within the native Excel features.
Otherwise you can download and install Adobe Acrobat complements or any other add-in that does the job.
Regards!
Click to expand...
Thanks for your help again Sir. I have been quite busy and am not able to spend much time on it at the moment but your suggestion should help.
What started my comment was that in Developer/Export, the Export icon was not open. The import icon was available. I see now that I must save the file as a CSV delaminated file to be able to export it. I was not aware of that.
I will have a play with it and use your advice. When I get it working I will come back to you to close this thread.
Thanks again
Mal
 
You must log in or register to reply here.
Back
Top