Tip of the Week June 8, 2015

Import and print schedule in Excel.

Volgistics includes a Schedule Report feature that allows you to print customized schedules in PDF format. Help topic 8255 has information on these reports. However, there may be times you want to have the schedule in Excel format. There is not a report that is able to do this, but you can use one of Excel’s features to get the schedule information for a specific date into an Excel file. Here is what you will need to do:

  1. Select Schedule from the menu.

  2. Go to the date you want the schedule for.

  3. Click the Printable View link that appears in the upper left corner under the date.

  4. Highlight and copy the URL address in the URL address bar.

  5. Launch Excel if it is not already open. Do not exit Volgistics.

  6. Select File from Excel’s menu.

  7. Select Open from Excel’s menu.

  8. Change the file type dropdown to “All Web Pages (*.htm,*html,…).”

  9. Paste the URL address you copied in step 4 into the File name field.

  10. Click the Open button. There may be a slight delay while the information is transferred from the web page to Excel.

  11. Depending on your security settings for Excel and Windows, you may be prompted to enter your Windows login information.

  12. You can use Excel’s menu to save the file as an .xlsx file.

Leave a Reply