{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Instructions","Example","Example2","MyLinks"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":19,"n_cols":3,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,null,"Online Instruction Page"]
[null,null,"Excel VBA Save as PDF Files"]
[]
[null,null,"Related tutorials"]
[null,null,"Send emails from Excel with PDF attachment"]
[null,null,"Code, Copy to a workbook"]
[]
[null,null,"Related Excel Product"]
[null,null,"Contextures Excel Tools Add-in"]
[]
[null,null,"Notes"]
[null,null,"See instructions on the Example sheets"]
[]
[null,null,"Get weekly Excel tips, tutorials, videos, and news"]
[null,null,"Contextures Excel Newsletter"]

{"sheet":"Example","index":1,"n_rows":15,"n_cols":2,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"This is a sample worksheet that can be exported as a PDF file"]
[null,"NOTE: Works in Excel 2010 and later"]
[]
[1,"Select one or more worksheets"]
[2,"On the Ribbon, click the View tab"]
[3,"Click the Top part of the Macros button, to open the Macros window"]
[4,"In the list of macros, select PDFActiveSheet"]
[5,"Click the Run button, to export the selected sheets to a PDF file."]
[]
["•","A default name is created, based on sheet name, and a time stamp"]
["•","The macro will open the Save As window,"]
[null," where you can enter a different file name and choose a folder"]

{"sheet":"Example2","index":2,"n_rows":20,"n_cols":3,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["My Test"]
["Summer"]
[{"$f":"YEAR(TODAY())","v":2019}]
[null,null,"This is a sample worksheet that can be exported as a PDF file"]
[null,null,"NOTE: Works in Excel 2010 and later"]
[]
[null,1,"Select one or more worksheets"]
[null,2,"On the Ribbon, click the View tab"]
[null,3,"Click the Top part of the Macros button, to open the Macros window"]
[null,4,"In the list of macros, select PDFActiveSheetNoPrompt\nor select PDFActiveSheetNoPromptCheck (see notes below)"]
[null,5,"Click the Run button, to export the selected sheets to a PDF file."]
[]
[null,"•","The macro will create a file name from the values in A1, A2 and A3"]
[null,"•","The file will be saved in the current folder"]
[]
[null,null,"PDFActiveSheetNoPrompt"]
[null,null,"• Overwrites the existing file with that name, if one exists"]
[null,null,"PDFActiveSheetNoPromptCheck"]
[null,null,"• Checks for existing file with that name"]
[null,null,"• Prompts to overwrite, or enter new name or location"]

{"sheet":"MyLinks","index":3,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Contextures Products"]
[null,"Pivot Power Premium Add-in","Time-saving tools for pivot table power users"]
[null,"UserForms for Data Entry ebook Kit","Step by step instructions and videos"]
[null,"Contextures Excel Tools Add-in","Make instant backups, sort sheets, and many more tools"]
[null,"Data Entry Search Popup","Makes data entry easier when choosing from long list"]
[null,"Data Entry Popup","Select single or multiple items from a listbox, to enter in a single cell"]
[null,"30 Excel Functions in 30 Days eBook Kit","Sample workbook and easy to follow user guide for key Excel functions"]
[]
[null,"Contextures Sites & News"]
[null,"Contextures Excel Newsletter","Weekly Excel tips, tutorials, videos, and news"]
[null,"Contextures Excel Tips Website","Hundreds of tutorials, tips and sample files"]
[null,"Contextures Excel Blog","Read the Excel tutorials and share your comments"]
[null,"Excel Pivot Tables Blog","Pivot table tutorials and tips, with comments and questions"]
[]
[null,"Other Excel Products"]
[null,"Contextures Recommends","Other Excel tools and training, recommended by Debra"]