vb.net

Hello everybody, I have recently started learning Excel VBA, with an eye of making a couple of apps for myself. However, I would now be interested to make them as .exe files and standalone projects, so that I might possibly be able to sell them. So far I realize that ; - Excel VBA needs ...

I am trying to read a single cell value from a Vision add-in from an Excel file the user selects with a File Dialog, then selects an Excel cell in Excel. The user can select a range of more than one cell. however I will read only the first cell. The below is VBA code from Visio Guy adapted for...

I created a COM enabled class in VB.Net. ... <ComVisible(True)> <ClassInterface(ClassInterfaceType.None)> <ProgId("Integration.PostInvoice")> Public Class PostInvoice Public Property InvoiceNumber As String Public Property FileName As String Public Property TransType As String...

Hey! First time here so apologies in advance if I'm asking this incorrectly. I have a pretty good basic understanding of excel but I've only ever really used it for some easy to moderate formulas and a few macros I've been helped with. I'm trying to figure out where to start with a problem I...

Hi, everybody I am not sure this is the correct forum to ask my question. But any help can orient me towards the solution. I am developing a VB.NET Sub which can get data from SQL Server to my Excel Sheet at lightning speed (using ADODB connection). My Sub is written in VB.NET, not VBA. But I...

Hi All, Very Happy New Year. As my experience to learn VBA with MrExcel is outstanding. And hence MrExcel Experts are Programmers and hence you can guide me on Vb.net tutorial. Could any one have idea the simple and best link or document to learn vb.net, please.. Many Thanks..

In VB.NET, a variable is declared using the syntax Dim Foo As Integer = 10 I have just discovered that in VBA this does not work, and must instead be written as either Dim Foo As Integer Foo = 10 or as Foo = 10 Is the second of these an acceptable way of declaring a variable? If not, what...

Hi All, Can any one suggest any good books to help me move from VBA to VB.net? Want to try and learn another language and think this could be a good start.

I modified the code from this post: https://www.mrexcel.com/forum/excel-questions/765416-how-get-x-y-screen-coordinates-excel-cell-range.html I need to get X Y screen coordinates of Excel VISIBLE area. my code: Option Explicit Private Type RECT Left As Long Top...

Hello All, I am involved in a project to convert an XLA to VB.NET for Excel DNA. I have basically copied the code from the XLA and making modifications where necessary to fit the VB.NET syntax, etc. etc. Note the following screenshot: Note that the mobjHelper variable is set to a new...

Hi! I've tried reading about alternative languages to VBA on different forums, but haven't really found an answer. I know it's not a yes/no alternative here, but any recommendations is appreciated :) I want to build several userforms in MS Excel, they're built just fine in VBA, but i was...

I have two problems one is if i have empty cells it will not work and second that it does not calculate on tables when using sum column5 Thanks for any help provided Public Shared Function TotalSumToNearest(Nums As Object) As Object...

I'm sure this has been discussed many times before across the internet, however most of recent searches have turned up articles from 2 to 12 years ago so I'm posting here to get your feedback. I started learning VBA about a year ago and recently completed a rather larger project in Excel and...

Hi everybody Does somebody know how to take the value of a textbox in a form and copy it into a pdf textfield? Is it also possible take make a button with a print preview of that pdf?Thanks alot

Hi, We have a VB.2010 32 bit Windows Desktop program that has been running for years. It uses an Excel (2010 in this case) database which is accessed through a connectionless OLEDB connection string as Provider=Microsoft.ACE.OLEDB.12.0;DATA SOURCE='L:\accnt\CustomerFiles\DATABASE 2015.xlsm'...

Hi, Can someone help me to find codes to subtract current timing with given timings in Column H. And I want to display that difference of those timings in a message box. Please help me out in this.

<article>Hi Everyone, It's been a long time since I visited this forum. anyway greetings to all. I come across the idea of adding security to excel vba code particularly the addins in which we all know that it can still be easily cracked. Anyhow I don't know the codes and how to make it...

Hi All I have been looking for a long time for a solution for what I thought would be a simple issue..... In my program I am opening an Excel template via Interop populating the required information and then trying to send the file to print to a specific printer. After being unable to find a...

From a VB.NET application I start a macro in an Excel file (Windows XP, Excel 2003). Dim excAppl As Microsoft.Office.Interop.Excel.Application = Nothing Dim excWrkb As Microsoft.Office.Interop.Excel.Workbooks = Nothing excAppl = New Microsoft.Office.Interop.Excel.Application excWrkb =...

How can I make this code <code style="margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif;">For Each wb In wbC If...