Questions tagged as 'excel'

Tagged questions
1
answer

Reduce code that references the same object?

Here the code, would you have any way to reduce it? (For learning purposes only) worksheet.Row(1).Style.Font.FontColor = ClosedXML.Excel.XLColor.White; worksheet.Row(1).Style.Font.Bold = true; worksheet.Row(1).Style.Alignment.SetHorizontal(XLA...
asked by 17.10.2016 / 01:19
1
answer

Search for substring in column

What I need is almost procv. I have a cell with one word and I need to search for that word in a column on another worksheet. But in the cells of this column there are several words. For example, I want to search in column A on which line 'grape...
asked by 22.09.2016 / 21:56
1
answer

How to return the data handling in Matrix passed as parameter to routines in VBA / Excel?

I need to pass distinct arrays to a routine that sorts its elements and receives other treatments, and then I want it to return those sorted and treated values to the original array ; for example, I passed out-of-order values and some fractio...
asked by 05.07.2016 / 19:53
1
answer

number even, odd, zero and greater than 10 how to find it? [duplicate]

For g = 1 To 10 For f = 1 To 10 Cells(f, g) = Int(100 * Rnd()) k = Cells(f, g) If Int(k / 2) - k / 2 = 0 Then pares = pares + 1 Else Impares = Impares + 1 End If If k = 0 Then Zeros = Zeros + 1 If k...
asked by 09.07.2016 / 19:48
1
answer

Exporting the Listview to Excel (.xls) from a populated list by LINQ, WPF (C #) project?

Good ... I need to export the data of the Listview populated by the LINQ method of a SQL Database ... I can not get the Column Headers in Excel ... Can anyone help? Reference: link Export Class: using System; using System.Collecti...
asked by 17.07.2016 / 06:02
1
answer

How to make a public routine for all forms without being attached to a form?

I have several forms in my application, and I can initiate the call by some of them in partial execution for tests (not necessarily START by main form). In addition to the public variables that are in a module, I tried to do the same with rou...
asked by 12.12.2015 / 19:58
1
answer

How to drag some objects and forms in VBA / Excel and prevent the dragging of others?

I'm having trouble trying to control "dragging forms" and "dragging objects" in VBA / Excel. For example: I have the main form that I do not want to be moved, a second form is called from the main and can be moved, and I have certain objects...
asked by 08.12.2015 / 14:11
2
answers

Fill in value on the Internet page

So I want to put a value on a web page, but before that I log in and I'm directed to another page, there I navigate to a different page, and I took a look at the page code and where I want it put the information has the name part, at first it wou...
asked by 15.07.2015 / 18:57
2
answers

How do I get the file path and insert it into a table?

I need to create a MySQL statement that takes all the file paths of the files in a specific folder and inserts them into a MySQL table. For example, if my folder is called PastaTeste , I need to have something in my table like this: C:\P...
asked by 05.05.2015 / 15:30
1
answer

Problems with Error '9': subscript out of range

I am creating a customer registry, and every time I will debug when it arrives at: totaldelinhas = Worksheets("bancodedados").UsedRange.Rows.Count + 1 caixa_Localizar.RowSourceType = "bancodedados!a2:a90" & totaldelinhas It's a mistake,...
asked by 29.04.2015 / 15:39