expertatexcel.com

Standard VBA/Excel (60 of 1182)

	•	Game - 20 Questions
	•	Game - Board Game
	•	Game - Card Game
	•	Game - Checkers
	•	Game - Concentration - Memory game
	•	Game - Create a game
	•	Generate_deck - udf - that runs commands in spreadsheet to generate ppt slides
	•	GenerateAllExcelAndDecks - batch - run multiple SQL's and Creates multiple PPT decks
	•	GenerateExcelFiles from a db - udf
	•	Get a Random number between 1 and a Million
	•	Get Address of a Range name
	•	Get ini file - gsINIFile = Left(ThisWorkbook.Name, Len(ThisWorkbook.Name) - 4) & ".ini"
	•	GetAllSlideNames
	•	GetAnchorFromCell - udf - web
	•	GetCommandLine() - udf
	•	GetConnection - udf - db
	•	GetDataFromLink(sLink, sEpic, sDeliv)
	•	GetDataSource - udf - db
	•	GetDeliverables
	•	GetDirName(sFile)
	•	GetFileBytes - internet
	•	GetFileCreator - internet - used shell to get the name
	•	GetFileName(fullpath) - returns the file name without directory
	•	GetFirstnameFromEmail(s)
	•	GetHTML - code to get the source from a web page (doesn't work on pages that use ajax)
	•	GetJira
	•	GetLastModifiedData - gets the last modified data of a web page
	•	GetLastSlash(s) - File
	•	GetLatestVersion(sfilename) - get the file with the latest version
	•	GetMacroCode
	•	GetNextRow - filtering udf
	•	GetNextVersion - udf - passed file and returns the next version of the file
	•	GetParameters - udf - Report engine
	•	GetRecodset (sSQL, Optional maxRecords) as ADODB.Recordset '
	•	GetRegionalTopNames 6 parameters - udf - get a chart of top n based on CE or PE
	•	GetRester
	•	GetSignature - gets a number based on the number of formulas + number of rows * cols
	•	GetStats - udf
	•	GetSystemVar - udf - db - Retrieves a System Variable from a table
	•	GettheVersion - opens workbook and finds the version and date by searching the sheet
	•	GetUsersEmail
	•	GetUsersEmailAddress() - udf - internet
	•	GetVersionForECMTemplates - goes thru a directory and get the last mod and size of each file
	•	GitHub
	•	Global variables and variable scope
	•	Go to First or Last Sheet
	•	Goal spreadsheet
	•	Gosub routine_name
	•	GoTo
	•	Goto Dialog - Ctrl+G
	•	Goto Loop
	•	GoTo next_for
	•	goto retry_it
	•	gotolabel:
	•	GotoSheet - udf - for shortcut creation
	•	GotoXYZ - Shortcut key will go to the XYZ system and substitute the #
	•	Group/Ungroup/Outline
	•	GTOD - GetTypeOfDate - e e-system C c-system
	•	GTODList(sStype, aOffsets) - date Get Type of Date list format "3,6,12,15" a list of prev offsets
	•	GTODList(type, string of offesets - ex. "0,1,2,3,6,9,12"