Questions tagged as 'vb'

Tagged questions
1
answer

Query Sql to show it in a DropDownList

I want to make a selection list by means of a DropDownList but it does not generate anything, I do not know if I have any errors Protected Sub DropDownList4_SelectedIndexChanged(sender As Object, e As EventArgs) Handles DropDownList4.Sel...
asked by 29.10.2018 / 16:55
0
answers

How to pass the data from an xml to excel using Vb.Net?

Good day, The problem is that when I read the data of my xml, it does everything without problem, but when trying to send the data to an excel, it overwrites the data and only pulls the data of the last xml that read . Help. Imports System...
asked by 10.10.2018 / 23:05
0
answers

Disable Protected View in Excel from Visual Basic

When downloading the excel I have to configure the blocking options to be able to edit on the excel. Configuring the following: Click on Protected View Click on the red circle There is some property to enable from the code, so tha...
asked by 04.10.2018 / 20:53
0
answers

Know the name of the first table of an excel sheet in VB.NET by OleDB

good afternoon. I'm connecting to an xlsx excel file using OleDB, I wanted to know, in what way can I know the name of the table in the file. That is to say, every day they send me an excel file where the table changes. Then I to do the queri...
asked by 05.09.2018 / 22:10
0
answers

export a query from sql to excel but without the help of ClosedXML.Excel;

I had been using this code to pass the gridviews to excel but now I want to pass a query:  Dim dtM As New DataTable             Dim sda As New SqlDataAdapter ()             SqlStr="SPAparticipantSistance @ TYPE = 7" 'this is the query I want to...
asked by 17.08.2018 / 19:15
0
answers

Error opening excel file with VB (error with office DLL)

   Can not convert COM object of type   'Microsoft.Office.Interop.Excel2000.ApplicationClass' to the type of   interface 'Microsoft.Office.Interop.Excel2000._Application'.   There was a   operation error because the QueryInterface call in the  ...
asked by 02.08.2018 / 22:38
0
answers

How can I run a Word macro, in Word, from Visual Studio Visual Basic, not VBA

Create a macro in word that causes some markers to change places and at the same time create a row in a table, but I want this macro to be executed from the program of visual studio 2010 by means of a button, I mean that from the program I edit...
asked by 18.06.2018 / 08:44
0
answers

Signing to a web page using macros

I'm trying to do the following: I'm creating a macro that links me to a web page. Sub Reporte() Dim ie As Object Set ie = CreateObject("Internetexplorer.Application") ie.Visible = True ie.Navigate "https://paginaweb.html"...
asked by 14.06.2018 / 19:30
1
answer

Redim Arrangement VBA

I have a small problem that I hope can guide me, it turns out that I have to store an array and for each data I'm going to store, verify if it has not been previously entered, the difficulty I have is that I define an array of 10 elements. , but...
asked by 19.06.2018 / 19:00
0
answers

Avoid excel messages VB.net

I have an application that makes EXCEL imports, but I get messages that I want to prevent them from coming out. For this, I use xlsApp = New Excel.Application xlsApp.Visible = True xlsApp.DisplayAlerts = False xlsWB =...
asked by 01.06.2018 / 09:37