How to open an Excel Online document as a PDF

0 votes
I want to link to an Excel Online file that is in a pdf format. In other words, I need a link that opens the Excel Online file's contents as a PDF document. The excel file should ideally be editable by admin users first, and then end users should be able to read the PDF version of that file since admin users are always updating it. Can this be done? I would require a link to the document's PDF version.
Oct 17 in Others by Kithuzzz
• 20,660 points
35 views

1 answer to this question.

0 votes

In light of your comment above, I think the following may help you achieve your goals.

In order to develop Macros, you must first enable the Developer Tab in Excel. A macro will be created to save the excel file as a PDF. I'm going to assume that the excel file only has one worksheet. To save the macros with the file when you enable the macros and save it for the first time, you must save it as an xlsm file. After doing this, carry out the actions listed below.

  • In Onedrive create a new folder and call it "MyPubDocs" for example.

  • In Excel open up your online Xlsm file and do a SaveAs

  • In the file, dialog Box navigate to the Onedrive folder you created and take note of the folder name. It might show...

  • In Excel go to the developer Tab, if you don't see them go to File Menu -> Options -> Customize RIbbons -> Popular Commands (left) and Main Tabs (right) and check the Developer checkbox. click OK.

  • Click on Macro Button Set the Macro name to "SaveToOneDrive" ad click create.

  • That should open an IDE where you will paste the following command.

    ActiveWorkbook.SaveAs Filename:="https://d.docs.live.net/XXXXXXXXXXXXXX/MyPubDocs/" & "MyExcelFileExportAsPDF.Pdf"

  • When creating the macro you should be able to assign a hotkey to that macro.

  • Now, whenever the admin finishes saving the excel file, they can press the hotkey or run the macro and it will save the file to the location.

  • If you want to associate the macro to the save event of the workbook, you can, but auto-save should be turned off.

  • After the first time, you saved the pdf, go to onedirve and navigate to the pdf file. Create a shareable link that you can distribute to your users. When they navigate to that sharable link it should show them the most recent pdf.

answered Oct 18 by narikkadan
• 37,660 points

Related Questions In Others

0 votes
0 answers

How to open a new tab or a new window while writing an exam in AI - Onlime Remote Proctored

How to open a new tab or ...READ MORE

Jul 20, 2020 in Others by vimalkamal
• 120 points
2,478 views
0 votes
1 answer

How to Paste JPEG as a gif in excel?

Solution  Step 1 Navigate to the folder that contains ...READ MORE

answered Oct 2 in Others by narikkadan
• 37,660 points
53 views
0 votes
1 answer

How to open a huge excel file efficiently

A good example is using PIA's/Interop or ...READ MORE

answered Oct 27 in Others by narikkadan
• 37,660 points
39 views
0 votes
1 answer

How can I convert a Word document to PDF?

This is a difficult task, made even ...READ MORE

answered Oct 31 in Others by narikkadan
• 37,660 points
50 views
0 votes
1 answer

Print chosen worksheets in excel files to pdf in python

In the simplest form: import win32com.client o = win32com.client.Dispatch("Excel.Application") o.Visible ...READ MORE

answered Sep 24 in Others by narikkadan
• 37,660 points
202 views
0 votes
1 answer

Java Spring - Writing Excel file and converting to PDF

Since you are using Spring I suggest ...READ MORE

answered Sep 26 in Others by narikkadan
• 37,660 points
222 views
0 votes
1 answer

Convert Excel to PDF issue with documents4j

MS Excel may not always be used ...READ MORE

answered Sep 26 in Others by narikkadan
• 37,660 points
178 views
0 votes
1 answer

Converting all tabs of excel sheet to PDF

Using VBA, try it like this, for ...READ MORE

answered Sep 26 in Others by narikkadan
• 37,660 points
189 views
0 votes
1 answer

How to stick an embedded document in a specific cell of an excel

Solution Select the documents (you can use the ...READ MORE

answered Oct 18 in Others by narikkadan
• 37,660 points
32 views
0 votes
1 answer

How to print an Excel Sheet using VBA with Nitro PDF Creator in Excel 2016

you can use the built-in excel facilities ...READ MORE

answered Sep 24 in Others by narikkadan
• 37,660 points
116 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP