Skip to content

Instantly share code, notes, and snippets.

View chemiadel's full-sized avatar

Adel chemiadel

View GitHub Profile
@chemiadel
chemiadel / exportSpreadsheet.gs
Created October 6, 2017 10:14 — forked from Spencer-Easton/exportSpreadsheet.gs
Example on how to export a Google sheet to various formats, includes most PDF options
function exportSpreadsheet() {
//All requests must include id in the path and a format parameter
//https://docs.google.com/spreadsheets/d/{SpreadsheetId}/export
//FORMATS WITH NO ADDITIONAL OPTIONS
//format=xlsx //excel
//format=ods //Open Document Spreadsheet
//format=zip //html zipped
@chemiadel
chemiadel / ReadPDF.vb
Created August 19, 2017 02:53 — forked from Phuseos/ReadPDF.vb
Select and read PDF files (VBA / MS Access)
sub ReadPDF()
'NOTE: Adobe Acrobat Pro XI or higher has to be installed and the following references have to be active:
'Adobe Acrobat 10.0 Type Library (acrobat.tlb) Usually found in: C:\Program Files (x86)\Adobe\Acrobat 11.0\Acrobat\
'Acrobat Access 3.0 Type Library (Accessibility.api) Usually found in: C:\Program Files (x86)\Adobe\Acrobat 11.0\Acrobat\plug_ins\
'To check for active references, see Tools -> References OR use the Immediate window (ctrl + G) and type "for each r in references : debug.Print r.name, r.fullpath : next r" (minus "" quotes)
Dim AcroApp As Acrobat.CAcroApp 'We're going to use the Acrobat 'app', so point to that
Dim theForm As Acrobat.CAcroPDDoc 'Define that we're going to use a Acrobat Form (known as PDF)