List All Pages
Backup module that create the necessary Access tables for holding query and table, via ADOX, then populates each with relevant infromation. In addition, create a backup folder with a subfolder for...
Access import module that makes the the improt process an object, with parameters for the following:
Properties
Staging Table
Master Table
Report Data value (process creates this and requires...
An Excel add-in that provide numerous functions, some built-in and some unque, but via a toolbar.
Features:
Print Formatting with Form (options for paper size, orientation, as well as defaults...
Listing of ASCII character representation by number, as well as appearance if formatted as W*Dings in Excel.
Right-Click to Save Target As: ASCII.xls
An AutoSave feature for Excel, done entirely in code. Includes a procedure for adding a dropdown menu to a toolbar.
Excel_AutoSave.txt
Search By Tag
Tag Cloud
Access
Excel
Class
SQL
Search By Form
This Site
List all pages
Recent changes
All WikiDot Sites
Other Sites
Code || VBA, SQL, X/HTML
Contact Me
A VBA module that can be used in Excel or Access, to calculate the value and greeks for a European option.
- Please note that Gamma is not calculating correctly.
Properties
OptionType (Enum for...
Checks the current version and returns a string, and should work with versions from 97 to 2007.
Excel_CheckVersion.txt
eMail
Working with Access, I needed to calculate business days between dates, excluding holidays, and with an eventual conversion fo the DB to SQL Server, rewrote the VBA into an SQL function, below:
set...
A class module for Excel or Access, that encapsulates a specific implementation SQL Server data:
Properties
Most properties are constants within the class, to separate the data interaction from the...
Captures a Shift+Click on a pivot chart, enabling drill down into the underlying pivot table. It has three (3) components, one a class module, one contains code for ThisWorkbook, and one is a...
Listing of ASCII character representation by number, as well as appearance if formatted as W*Dings in Excel.
Right-Click to Save Target As: Excel2007OM.chm
Form Resizer For Microsoft Access (By Jamie's Software): The Form Resizer allows you to resize your program's forms to fit the current screen resolution. It is intended for Access developers with...
Provides over 1500 long values as user-memorable names for Excel as a late-bound object.
Right-click to Save File As: Access_Globals_Excel_Late-Binding.txt
Who can join?
Anyone willing to freely share VBA code or Excel/Access tips.
Join!
So you want to become a member of this site? Tell us why and apply now!
Or, if you already know a "secret...
An Excel class module used to perform basic logging:
Properties
DeleteFile (Public)
OutputFolder (Public)
FileName (Public)
multiple private variables for internal processing
Methods
LogAction...
A module which improves upon the MkDir function, such that it verifies and creates an entire path; MkDir only creates a new directory on an existing path. Please note that this module was create by...
A function to send a Notes e-Mail with attachment. This is common-code provided by others, but rewritten to be reusable as a function.
Parameters
Subject
Recipient
BodyText
Attachment (path,...
Tag Cloud
Two example procedures for creating pivot tables in code. One simply create a pivot table with an internally-specified worksheet, while the other works as a function, accepting various...
An Access DB that queries the domain for objects, e.g., user ID's, along with the related account fields. Requires that you modify code to specify a domain.
Details
Download all user's domain...
Find Code
Search: Tags and Discussion
Search: Google My Sites
See All Recent Updates
Updates & Commentary
Page Tags
List all pages
Other Sites
Code || VBA, SQL, X/HTML
About This Site
How...
Members:
Moderators
Admins
Access code to backup stored procedures from SQL Server. Code checks for table's existence and creates if necessary. Requires modification of module level variables to fit your...
A place for the admin to drop files for transfer between systems…
To save the position of your toolbars
Unzip the file and save it to a drive
Open it; enable macros
Position your toolbars the way you'd likethem.
Run macro Toolbar_SaveSettings
Close workbook; it...
MS code to transpose an array, possibly used in conjunction with GetRows.
VBA_TransposeArray.txt
About This Site
My initial VBA code site, Code || VBA, SQL, X/HTML, while useful for sharing code, makes updating awkward, in that I need to then work with my back-end MySQL server to make...
Class that can be used to calculate target dates, taking into account a date and hours/days of work, compensating for weekends, but not holidays:
Properties
StartDate, a date
Increment, number of...
Function that can be used to calculate target dates, taking into account a date and hours/minutes of work, compensating for weekends, but not holidays:
Variables:
StartDate, a date
Increment,...
Access class module, although should work in Excel with minor modification, that automates zipping files, with parameters for the following:
Properties
Output Name
Output Path
File Names (paths as...
