Browse by Tags
All Tags »
VSTO »
English Related (
RSS)
I was writing a ClassLibrary to COM Interop and this one came up. This was original whiten to use with JET (VBA and VB6) C# public object DAvg( string connectionString, string expression, string domain, string criteria) { var strSQL = "Select "...
public string ConvertFieldToUpper( string MyTable, string MyField) { Access.Application oAccess = ((Access.Application) (Marshal.GetActiveObject( "Access.Application" ))); try { string strSQL; strSQL = String.Format( "UPDATE {0} SET {1...
/// <summary> /// /// </summary> /// <param name="hideNavigationPane"></param> /// <param name="myUIName"></param> /// <param name="myUIXML"></param> /// <returns>True...
public bool ConvertReportToXPS( string myReport, string XPSFileName) { Access.Application oAccess = ((Access.Application) (Marshal.GetActiveObject( "Access.Application" ))); try { oAccess.DoCmd.OutputTo(Access.AcOutputObjectType.acOutputReport...
public bool TablesAreEqual( string MyTableSource, string MyTableToCompare, string MyIndexField) { try { OleDbConnection cnn; using (DataSet ds = new DataSet()) { OleDbDataAdapter da; string cs = oAccess.CurrentProject.Connection.ToString(); string strSQL...
Access.Application oAccess = ((Access.Application) (Marshal.GetActiveObject("Access.Application"))); // ---------------------------------------------...
/// <summary> /// /// </summary> /// <param name="MyPath"></param> /// <returns>True/False</returns> public bool GenerateLogDatabase( string myPath) { CatalogClass cat = new CatalogClass(); string strSQL;...
According with Kevin Boske, Microsoft VSTA Program Manager, "there's been some discussion on this thread on Slashdot, ( updated ) which started from this article in The Register UK . To be clear, Microsoft is not replacing VBA with VSTA or VSTO...
#1 How Do I: Create a Word Document Using the SDK for Open XML Formats? (17 minutes 10 seconds ) #2 How Do I: Use WPF Controls Inside an Excel Actions Pane? (11 minutes 0 seconds ) #3 How Do I: Interact with Web Services from Microsoft Excel? (25 minutes...