vb.net

Trying to access filter programatically in VB using a list of numbers. I can select from the dropdown pick list,(hovering over filter show... EQUALS+ comma separated list of values), but don't know how to provide a that list to the filter using VB. My use case would be that I am working...

I hope this is a trivial question! Given a Worksheet variable - WS, and a Single Column Range on that Worksheet - V (eg G1:G260), and an Index -- i where i is the index of the first row of interest in that range (eg 12), What is the VB or VBA syntax for setting V to be the Range starting with...

I hope this is a trivial question! Given a Worksheet variable - WS, and a Single Column Range on that Worksheet - V (eg G1:G260), and an Index -- i where i is the index of the first row of interest in that range (eg 12), What is the VB or VBA syntax for setting V to be the Range starting with...

Hi all, I've got a project where I need to calculate the time passed between an acceptable range. For example E-mail was received at 19:00 and a response was sent at 09:00 The acceptable range is 8am to 6pm so in the scenario it should return 60 mins. Another example is if the email was...

In the simplest terms I can relate, here's my problem... where I work we use a data collection system that is accessed through an xla. If that xla doesn't run, we can't get to the data. I am trying to build an application that will "hide" the excel instance running, but still be able to change...

Hi all, i am new to this forum,i have create one word document template by manually and add the table and headers in that template,i can bind the data set values to this template using vb For Each myxmlnode In Travelerdoc.XMLNodes If myxmlnode.BaseName = "WONumber" Then...

Hello I've come up with a bit of an issue when trying to programatically create workbook connections via an Excel 2007 Add-in created in Visual Studio 2008 (VB.net) My current code is as follows: Imports Microsoft.Office.Interop.Excel Public Class myForm Dim Workbook As Excel.Workbook =...

Hi all! I'm new to the forums and hope I am placing this post in the correct location. I'm having a lot of trouble automating charts from my VB.NET program. I'm simply graphing one series of data as a time series that must maintain its order as the user filters the data, deletes some data...