Yeah, it can get confusing, especially given the skip-level naming conventions, etc. Essentially, you’ll need: Full version (not Express) of Visual Studio and the .NET version you’re targetting. One of the VSTO run times (VSTO 2003, VSTO 2005, VSTO 2005 SE, VSTO 2008, VSTO 2010). For what your asking, VSTO 2005 SE is probably your … Read more
The Select-command should look like this if you want to read A1 to D1: SELECT * FROM [SHEETNAME_HERE$A1:D1] Whole Code: OleDbConnection con = new OleDbConnection( “provider=Microsoft.Jet.OLEDB.4.0;data source=” + XLS_FILE_NAME_AND_PATH_HERE + “;Extended Properties=Excel 8.0;”); StringBuilder stbQuery = new StringBuilder(); stbQuery.Append(“SELECT * FROM [” + SHEETNAME_HERE + “$A1:D1]”); OleDbDataAdapter adp = new OleDbDataAdapter(stbQuery.ToString(), con); DataSet dsXLS = … Read more
To set a range to text: xlYourRange.NumberFormat = “@”; You can also prefix a value you put in a cell with an apostrophe for it to format it as text: xlYourRange.Value = “‘0123456”; To set a range to number xlYourRange.NumberFormat = “0”; Obviously if you want to set the format for the entire column then … Read more
You probably have one or more gigantic procedures/functions and I think VBA has a limit of 64k or something per procedure. You fix it by splitting that procedure up into multiple procedures that can then be called by the one procedure. So instead of having: Sub GiantProcedure() … ‘ lots and lots of code End … Read more
Yes, you can. You will want to look into MSDN which has a pretty good introduction to it. I might give you a word of warning, Microsoft Office interop is compatible with an API which is now more than 10 years old. Because of this, it is downright nasty to use sometimes. If you have … Read more
Since docx files are just zipped XML you could just unzip the docx file and presumably pull the author information out of an XML file. Not quite sure where it’d be stored, just looking around at it briefly leads me to suspect it’s stored as dc:creator in docProps/core.xml. Here’s how you can open the docx … Read more
Calendar delegation is a feature of Exchange, the Graph API and Outlook API do not allow the user to access the delegated calendar. Currently, the alternative workaround could be use the EWS. And here is an sample for your reference: static void DelegateAccessSearchWithFilter(ExchangeService service, SearchFilter filter) { // Limit the result set to 10 items. … Read more
This is because MS Office is using Hlink.dll component to lookup if the link is Office document or something else. MS Office expect to open the document linked within documents without the aid of external browser (using Hlink.dll component of IE6). If session cookie protects website Hlink naturally is being redirected to login page and … Read more
Since most of the documents we need to display are already hosted on the web, we opted to use an embedded web view that opens the document using google docs viewer. We still have a few locally stored documents though that this approach doesn’t work with. For these, our solution was to rely on the … Read more
There’s not a whole lot that has changed between VBA6 and VBA7. VBA7 was introduced to support 64-bit versions of both Office and Windows (see below on what those differences are). Here are the key changes: 64-bit support, primarily for API calls. This is both used to make your code work with your OS/Office version … Read more