Search results 59

Sorted from new to old.

Hiding chart in Excel

How to hide a full chart in Excel. By treating it as shape, not as chart.

2020Dec31

Generate_PowerPoint

Creates PowerPoint slideshow file from Excel range(s) with slide per sheet (or ...

2020Dec22

Save Excel range (or shape) to picture

This is an interesting approach to export a range of cells into picture using ...

2020Dec21

ExitTool and DoNothing

My way of Exiting tool in case or error, also another sub that basically does ...

2020Oct31

CellSave and CellRead

Reads a cell or Saves value into certain cell, in certain sheet and workbook. ...

2020Oct31

ANStrSort2

Sort list of strings in ascending or descending order using pure VBA, no ...

2020Sep24

ListBox_Excel_Sort

Sort items in Fm20 Listbox using Excel spreadsheet Sort function. Can decide ...

2020Sep21

FolderSize_Swift

Gets total of folder size in bytes. With some tweaks, you can modify it to use ...

2020Apr20

DB_Connect

VBA-Excel function to connect to SQL Database server, in addition to ...

2020Mar20

Auth_User

Find the user name (and domain) for logged in user for in an internal intranet ...

2020Feb23

CountArrayCol

Returns the count of array fields, given the dimension, using UBound ...

2019Aug9

IsThere_Remote

Checks if a file can be reached online or no Same as

2019Jun7

VBA vs ASP Classic

Differences between coding in VB in Classic ASP (aka VBScript) and VBA (aka ...

2019Jun2

Unprotect sheet or workbook

Unprotect worksheet (and workbook) using VBA code

2019Apr25

Porting Excel/VBA into OpenOffice Calc

PDF document on what needed to import VBA from Excel into OpenOffice Calc Basic

2019Feb8

DBMySQLVBA API

An API to allow connecting to MySQL database from VBA (or VB6), found it a ...

2019Feb3

1 2 3 4