All Questions
2,928
questions
0
votes
0
answers
36
views
VB.NET: Cannot overwrite Excel file located in My Documents\Source
My program is used to save data read from the Excel file EmployeeMgmt.xlsx. I want to automatically close the form after successfully saving the data to MySQL, delete all lines except the title in the ...
0
votes
1
answer
37
views
Type Conversion in VSTO VB.NET from Range to Range?
I have a VSTO Excel project with the following code:
Dim start_row As Integer = 5, start_col As Integer = 1
Dim start_cell As Range = Cells(start_row, start_col)
Hovering the Cells function gives it ...
0
votes
0
answers
28
views
reading excel file not working on web-server using ClosedXML
I have an application where I open an excel file and populate a listbox with the headers. I am using ClosedXML and have the ClosedXML NetGet Package installed and just tried the ClosedXML.Signed ...
0
votes
0
answers
26
views
Find the address of the hyperlink in a cell in excel with the VB code?
I am using following code to find the address but am unable to find the cell reference
For i = 5 To lastRow ' Assuming row 1 is header
' Get the cell containing the hyperlink in column S
Set ...
0
votes
0
answers
25
views
return all instances of a string in a specific Excel column when they are grouped in a pivot table
I am trying to get the cell address of all cells in a crosstab column that contain specific text. The problem is only the first cell in the group has the string. The preceding cells in the group are ...
0
votes
1
answer
47
views
UnauthorizedAccessException while saving a SpreadsheetLight file with images
I'm using SpreadsheetLight 3.5.0 to create an Excel file which includes images. Saving the Excel causes an exception.
This code
If OpenDialog.ShowDialog() = DialogResult.OK Then
Using pDoc = New ...
-1
votes
1
answer
399
views
How to get handle on an open excel file in vb.net with .net 8.0.2.?
I am using vb.net and .net 8.0.2. App is running on Windows 11.
I have been trying for hours to point to an excel file which has already been opened by the user.
I tried:
Dim app_excel As Microsoft....
1
vote
2
answers
89
views
Registering COM Object on Windows 64-bit For Use In Excel-32 Bit Is Failing
I have an Excel application that uses a COM object.
The COM object is VB.net and compiled in Visual Studio targeted to "Any CPU".
I am registering the COM object for the current user only. ...
0
votes
1
answer
28
views
How can I test for Excel blank cell in SSIS dataflow source Visual Basic script
I need to read a collection of "forms", each of which is the first sheet in an individual Excel document. These documents are all collected together in a folder. I pick certain cells from ...
0
votes
1
answer
104
views
Through VB.NET, how do you add and edit code modules of an Excel file using Microsoft.Office.Interop.Excel?
I am updating company software written in VB.Net. Our data is stored in MYSQL. One of the features I am trying to update is the ability to create reports. Now these reports are to be generated as ...
0
votes
0
answers
111
views
ChangeLink in Workbook takes to many time
I am working with a workbook that has several links to other workbooks, but I noticed that if I use the Workbook.ChangeLink() method, it takes too long to finish. However, if I manually use the Excel ...
0
votes
0
answers
34
views
Excel VBA Adding Parentheses around Column Name in formulas [duplicate]
I have this very basic code in VBA:
Activecell..Formula2 = "=XLOOKUP(RC[-100],'[" & wbState.Name & "]" & wsState.Name & "'!B:B,'[" & wbState.Name &...
0
votes
1
answer
644
views
System.Data.OleDb.OleDbConnection is not working in new project
The code to read the content from an Excel file does not work in my new program, see attached image.
It works without problems in another older program I made a while ago with .NET Framework 4.0.
The ...
0
votes
0
answers
43
views
Why is my formula not being evaluated in Excel VSTO Workbook using VB.Net
My Code is entering the formula in the cell correctly, but it is not evaluated unless I either double click the cell and hit Enter or go to the formula bar and hit enter. The formula is a dynamic ...
0
votes
0
answers
45
views
Auto-click using vb.net code a button that lies on a cell in a macro-enabled excel
I have a macro-enabled excel created by other company, it's protected and its password cannot be shared to me hence I cannot view the code. The objective is to auto-populate it with data before ...