Of late, I have been doing a lot of work in MS-Access manipulating Excel Spreadsheet.
I think I have mastered doing this using late binding. The only inconvenience seems to be that I have to look up each Excel VBA constant and define it in the App. Has anyone created a module that has all of the Excel constant codes, such as the following:
Code:
Option Compare Database
Option Explicit
Public Const xlPasteFormats = -4122
Public Const xlSortOnValues = 0
Public Const xlAscending = 1
Public Const xlSortNormal = 0
Public Const xlYes = 0
Public Const xlTopToBottom = 1
etc...