{"id":"https://openalex.org/W652498693","doi":null,"title":"Excel 2002 VBA Programmer's Reference","display_name":"Excel 2002 VBA Programmer's Reference","alternate_titles":[],"publication_year":2001,"publication_date":"2001-09-26","ids":{"openalex":"https://openalex.org/W652498693","mag":"652498693"},"language":"en","primary_location":{"id":"mag:652498693","doi":null,"is_oa":false,"landing_page_url":"https://ci.nii.ac.jp/ncid/BA6378396X","pdf_url":null,"source":null,"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":null},"parent_works":[],"lineage":["https://openalex.org/W652498693"],"child_works_count":0,"type":"book","is_traditional":true,"indexed_in":[],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5037375259","display_name":"Stephen Bullen","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Stephen Bullen","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5060716064","display_name":"John Green","orcid":"https://orcid.org/0000-0002-2315-5326","observed_orcids":["https://orcid.org/0000-0002-2315-5326"]},"institutions":[],"countries":[],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"John Green","raw_affiliation_strings":[],"raw_orcid":"https://orcid.org/0000-0002-2315-5326","affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5073442322","display_name":"Rob Bovey","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Rob Bovey","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"last","author":{"id":null,"display_name":"Robert Rosenberg","orcid":"https://orcid.org/0000-0002-0459-4630","observed_orcids":["https://orcid.org/0000-0002-0459-4630"]},"institutions":[],"countries":[],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Robert Rosenberg","raw_affiliation_strings":[],"raw_orcid":"https://orcid.org/0000-0002-0459-4630","affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.3496,"has_fulltext":false,"cited_by_count":7,"citation_normalized_percentile":{"value":0.76008493,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":87,"max":92},"biblio":{"volume":null,"issue":null,"first_page":null,"last_page":null},"is_retracted":false,"is_pulled":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T13197","display_name":"Spreadsheets and End-User Computing","score":0.9901999831199646,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T13197","display_name":"Spreadsheets and End-User Computing","score":0.9901999831199646,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T13681","display_name":"Engineering and Information Technology","score":0.009100000374019146,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T13820","display_name":"SAS software applications and methods","score":9.999999747378752e-05,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/microsoft-excel-2002","display_name":"Microsoft Excel 2002","score":0.9110000133514404},{"id":"https://openalex.org/keywords/visual-basic-for-applications","display_name":"Visual Basic for Applications","score":0.9520000219345093},{"id":"https://openalex.org/keywords/vba-programming","display_name":"VBA programming","score":0.7799999713897705},{"id":"https://openalex.org/keywords/range","display_name":"range","score":0.7630000114440918},{"id":"https://openalex.org/keywords/pivot-tables","display_name":"pivot tables","score":0.7910000085830688},{"id":"https://openalex.org/keywords/charts","display_name":"charts","score":0.6909999847412109},{"id":"https://openalex.org/keywords/user-forms","display_name":"user forms","score":0.8640000224113464},{"id":"https://openalex.org/keywords/add-ins","display_name":"add-ins","score":0.8989999890327454},{"id":"https://openalex.org/keywords/windows-api","display_name":"Windows API","score":0.6679999828338623},{"id":"https://openalex.org/keywords/internationalization","display_name":"internationalization","score":0.5649999976158142}],"concepts":[{"id":"https://openalex.org/C115199736","wikidata":"https://www.wikidata.org/wiki/Q667566","display_name":"Visual Basic for Applications","level":2,"score":0.775143027305603},{"id":"https://openalex.org/C2778514511","wikidata":"https://www.wikidata.org/wiki/Q1374194","display_name":"Programmer","level":2,"score":0.7540302276611328},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7150131464004517},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.6659666299819946},{"id":"https://openalex.org/C2781238097","wikidata":"https://www.wikidata.org/wiki/Q175026","display_name":"Object (grammar)","level":2,"score":0.49798035621643066},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.4717995226383209},{"id":"https://openalex.org/C2777212361","wikidata":"https://www.wikidata.org/wiki/Q5127848","display_name":"Class (philosophy)","level":2,"score":0.4482743740081787},{"id":"https://openalex.org/C187018787","wikidata":"https://www.wikidata.org/wiki/Q662200","display_name":"Component Object Model","level":3,"score":0.41735124588012695},{"id":"https://openalex.org/C121684516","wikidata":"https://www.wikidata.org/wiki/Q7600677","display_name":"Computer graphics (images)","level":1,"score":0.41398167610168457},{"id":"https://openalex.org/C199639397","wikidata":"https://www.wikidata.org/wiki/Q1788588","display_name":"Engineering drawing","level":1,"score":0.33837664127349854},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.18400493264198303},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.1623341143131256},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.1480783224105835}],"mesh":[],"locations_count":1,"locations":[{"id":"mag:652498693","doi":null,"is_oa":false,"landing_page_url":"https://ci.nii.ac.jp/ncid/BA6378396X","pdf_url":null,"source":null,"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":null}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":1,"referenced_works":["https://openalex.org/W2970248174"],"related_works":["https://openalex.org/W3184100625","https://openalex.org/W7096110022","https://openalex.org/W2915332554","https://openalex.org/W2555040063","https://openalex.org/W1601583012","https://openalex.org/W609453918","https://openalex.org/W2894087694","https://openalex.org/W2338379205","https://openalex.org/W2913158659","https://openalex.org/W2554977006"],"abstract_inverted_index":{"Chapter":[0,5,11,16,21,25,29,32,36,40,44,48,54,57,61,65,68,75,78,85,91,97,101,106],"1:":[1],"Introduction":[2],"to":[3],"Excel.":[4],"2:":[6],"Primer":[7],"in":[8],"Excel":[9,93,115],"VBA.":[10],"3:":[12],"The":[13],"Application":[14],"Object.":[15],"4:":[17],"Workbooks":[18],"and":[19,52,72,94],"Worksheets.":[20],"5:":[22],"Using":[23,27],"Ranges.":[24],"6:":[26],"Names.":[28],"7:":[30],"PivotTables.":[31],"8:":[33],"Filtered":[34],"Lists.":[35],"9:":[37],"Generating":[38],"Charts.":[39],"10:":[41],"Event":[42],"Procedures.":[43],"11:":[45],"Adding":[46],"Controls.":[47],"12:":[49],"Office":[50,83,126],"Files":[51],"Folders.":[53],"13:":[55],"UserForms.":[56],"14:":[58],"Command":[59],"Bars.":[60],"15:":[62],"Class":[63],"Modules.":[64],"16:":[66],"Addins.":[67,74],"17:":[69],"Automation":[70],"Addins":[71],"COM":[73],"18:":[76],"SmartTags.":[77],"19:":[79],"Interacting":[80],"with":[81,89,109],"Other":[82],"Applications.":[84],"20:":[86],"Data":[87],"Access":[88],"ADO.":[90],"21:":[92],"the":[95,104,110],"Internet.":[96],"22:":[98],"International":[99],"Issues.":[100],"23:":[102],"Programming":[103,108],"VBE.":[105],"24:":[107],"Windows":[111],"API.":[112],"Appendix":[113,119,124],"A:":[114],"2002":[116],"Object":[117,122,128],"Model.":[118,123,129],"B:":[120],"VBE":[121],"C:":[125],"XP":[127]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W652498693","counts_by_year":[{"year":2013,"cited_by_count":1}],"updated_date":"2026-11-16T12:05:36.265796","created_date":"2016-06-24T00:00:00"}
