vb.net

  1. P

    Reduce size of Range - Syntax question

    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...
  2. W

    Calculating time passed in a range and retuning minute within a macro.

    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...
  3. C

    A question about excel .xla , ado and vb.net

    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...
  4. V

    How to inserr a row in word document template as dynamically using vb.net

    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...
  5. M

    (ADV?) Excel VSTO - Creating Connections

    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 =...
  6. F

    VB.NET Excel Automation of Charts with Named Variables

    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...

Some videos you may like

This Week's Hot Topics

  • Date update overflow error ‘6’
    Dear MrExcel community, I have a project search & update & add & delete can do. There are 32 column and 5 of them is date. When I search date...
  • Highlight Row and Column on cell selection
    In the following I have some code I need modified to see if I can do the following: 1) Only have this work when selecting a cell inside a couple...
  • Need Numbers Inputted and Deleted
    Thanks for your help. Not sure if there is even an = equation for this. Please see attachment. If there is a solution, please respond with = So...
  • Worksheets(x).Select Error
    Hi, I am trying to select multiple sheets using the following code. [CODE=vba] Dim x As Integer ThisWorkbook.Worksheets(3).Select...
  • myFind Range not working
    Please can someone say why this myFindRng goes red in the code? [CODE=vba]Private Sub Model_Chose_Change() With ThisWorkbook.Worksheets("Job...
  • How to identify the last page break in a sheet
    How can I find the position of the last page break in my sheet? There may be multiple pages and I want to know how to find the position of the...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top