Most voted "excel" questions
Microsoft Excel is a commercial spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS X that allows advanced use of mathematical formulas and functions and statistics. For questions about programming in VBA Excel, also use the excel-vba tag. Note that non-programming issues are within the scope of the Stack Overflow, for example those involving the basic use of the tool.
Learn more…1,117 questions
Sort by count of
-
0
votes1
answer113
viewsPrevent the PROCV formula from returning an error
Is there any configuration in Excel or some way to make the PROCV formula, when it does not find the searched value, return empty ("") or 0 instead of the error "#N/A"?
-
0
votes0
answers344
viewsUSERFORM: Move Listbox item up or down
I have a Listbox in a Userform that reflects a list of the order of display of the items in a Dashboard. I want the user to be free to change the order of these items by moving them down or up in…
-
0
votes1
answer184
viewsvba Pastespecial does not work
I’m cutting the values out of one spreadsheet and moving on to the other. The clipping is done without problems, the data is going to the clipboard, but I’m not able to paste. Code Private Sub…
-
0
votes1
answer581
viewsHow to separate Text Code
Hi person good afternoon all right? I have a question I’d like to know if you can assist me, please: I have a file . txt , which contains more than 1000 lines, I need to separate the code from the…
excelasked 8 years, 1 month ago Rodrigo Hackz Exploitz 103 -
0
votes0
answers971
viewsASP.NET MVC Reports in PDF and EXCEL
Good afternoon, you guys, I would like to get references on better tools to generate reports in an MVC application that allows me to export the result to PDF and EXCEL. Currently, I am creating a…
-
0
votes1
answer4369
viewsHow to concatenate variable with formula in Excel?
It is correct that I concatenate a variable to an Excel formula? Excel complains at concatenation closure: Sheets("FATURA").Select Dim variavel As Double variavel = InputBox("Digite Valor da Tarifa…
-
0
votes0
answers471
viewsGet data from a dynamic table in Excel
I am trying to read a spreadsheet in excel and I am creating a dynamic table via programming and it is working, but I’m having trouble to get this data filtered, because it does not return all the…
-
0
votes1
answer174
viewsError message when opening exported excel file in PHP
use the following code: $this->excel->getActiveSheet()->setTitle('Matemática'); //set cell A1 content with some text $this->excel->getActiveSheet()->setCellValue('A1', $opcao);…
-
0
votes1
answer1926
viewsCount the number of selected items in a Listbox
I have a list ListBox1 in a userform configured for multiple item selection. There is some function, statement, or way to return the number of selected items?
-
0
votes1
answer458
viewsFile Download - Excel - Firefox
I have the download link to an XLS file. Every day I need to DOWNLOAD this file (I can only access by firefox), SAVE in a folder to feed my spreadsheet. ( the sheet is "linked" in this file. I need…
-
0
votes1
answer1105
viewsAuto complete when typing any part of the word
How can I self-cmplete the text when typing any part of an information inside the Listbox using VBA? Example: When typing the "Santos" all options containing that word will be listed / presented in…
-
0
votes1
answer34
viewsexcel is not recognizing the range numbers
This is the spreadsheet to calculate the tax due according to the billing: Total Gross Revenue in the last 12 months A B C D 1 Alíquota Faturamento 2 - 180.000,00 4,50% 3 180.000,01 360.000,00 6,54%…
excelasked 7 years, 5 months ago Ricardo Limonge 1 -
0
votes1
answer105
viewsHow to add a value to DBF
To read the file . DBF works as follows: I use a Tadoconnection, being the Connectionstring for: Driver={Microsoft dBASE Driver (*.dbf)};DriverID=277;Dbq=C:\_workspace\projects\DBFEditor\temp To…
-
0
votes0
answers50
viewsLabel with transparent background
I’m making a program all in VBA, in Excel (office 2016), and suddenly some components fail to work properly. The main, and essential, change was that no field gets the transparent Backstyle (it used…
-
0
votes1
answer7024
viewsPaint cell with conditional formatting using SE
I wanted to know how to paint the cell phone of a certain value: For example: I have a salary of R$100,00 in cell A1 In cell B2 goes the sum of my accounts So in cell C1 I would like to paint red if…
excelasked 7 years, 4 months ago Artur Mafezzoli Júnior 441 -
0
votes1
answer1615
viewsHow to handle EXCEL with PHP?
How do I manipulate excel cells with PHP? For example: I need to take 2 cells, in separate lines Cell 1: AB2 Cell 2: BC4 And multiply them AB2 * BC4 = ? And print this value on the screen. All this…
-
0
votes0
answers123
viewsProblems using Phpexcel cache system with Laravel 4.2
I’m trying to use the library’s cache system Phpexcel, but I am still getting memory overflow in my application. I need to use cache because I am generating reports with more than 100,000 records on…
-
0
votes0
answers751
viewsExtracting two information via Selenium and pasting into only one cell in excel
I’m trying to extract some web information Via Selenium, the point I’m catching is this: I can direct the information from Selenium searched on the internet and save it within a specific cell, but…
-
0
votes2
answers429
viewsDoes Excel convert Macro into formula?
Without using the macro editor in VB it is possible to use a simple macro line in a formula? I want to get a value of a cell always from the tab to the left of the active tab, as this could be done…
-
0
votes1
answer852
viewsSendkeys does not work with accented word in VBA - Excel
I’m developing a script in VBA, in Excel. This code will populate another program, using the data collected in the cells. But cells that contain some word that has accents, are not working. I am…
-
0
votes1
answer2356
viewsPhpexcel generates corrupted file . xslx
I want to generate a file .xlsx, with records that were not imported from another table .xlsx, but I can generate the file .xls without problems, already when I try to generate .xlsx, Excel warns…
-
0
votes2
answers1115
viewsHow to do javascript PROCV (excel) function
How to do excel Procv function in javascript; Ex: I have a table with 2 columns (name and code) and I have a list with only names, I need to go through this list with names and bring the code…
-
0
votes1
answer481
viewsFilling and importing data with VBA in excel, help in code?
Hello, the situation that I am trying to automate in excel, through VBA is the following: I have two spreadsheets (different excel files), where the two have the same header (with information like…
-
0
votes1
answer1504
viewsC# excel format column
I am trying to format an excel column for currency format. excelWorksheet.Range["S1", "S" + linhas].NumberFormat = "R$ #.###,00" But this causes it to format this way "RR$ 3500,00". In the cell is…
-
0
votes1
answer6913
viewsExcel VBA - How to use Vlookup with Letters and Numbers to Delete Queues?
Hello! I am going through great difficulty with a problem using Vlookup in Excel VBA. First of all, I am not an expert in VBA but I managed to use Vlookup but I am not having the effect I would…
-
0
votes0
answers28
viewsHow to Delete Queues with User Code?
A little while ago I did this question who has not received any answers: But I got some help from some people and I was able to evolve the code to a certain extent. My code is now like this: Option…
-
0
votes1
answer335
viewsLoad excel data on screen
I’m having a problem loading data from a spreadsheet on the screen (table). The system is done in C# MVC5 with Razor and Entity framework, I need the user to choose an excel file already filled and…
-
0
votes1
answer1395
viewsJoin data from two worksheets in Excel
I have two spreadsheets in Excel. In the first I have the following data, for example: ID | NOME -----|---------- 100 | Luiz 101 | Pedro 102 | Aline On the second spreadsheet, I have: ID | CATEGORIA…
-
0
votes1
answer219
viewsJava Poi does not download
I’m using the poi 3.15 library to generate excel on a web system, but I’m having trouble downloading the file, locally it works but when I publish it does nothing. I put it at the beginning like…
-
0
votes0
answers31
viewsExport excel using Javascript
I wonder how I do a function that exports a table to excel but does not show certain columns defined with a class
-
0
votes1
answer57
viewsProblems transferring data type from Msproject to Excel
Hello. I’m having trouble transferring some dates like Baseline Start, Baseline Finish, Actual Start, Actual Msproject Finish to a spreadsheet in excel. Here is the code snippet. Dim xlSheet As…
-
0
votes2
answers938
viewsExcel form - incompatible types
I know this should be a simple question to answer, but I’m starting to program in VBA now. The code below should transfer the data from one spreadsheet to another, should be something very simple,…
-
0
votes0
answers1102
viewsImport sheet charts to userform (excel vba)
I have to import 3 charts for a userform. I had even managed, but suddenly started to give errors, then I put the code "On Error Resume Next" (but this is not solution, just does not lock my form…
-
0
votes0
answers36
viewsAccess and excel - load parameters
is it possible to use an excel table as parameters for access queries? I currently have 4 access files to carry out the same process, but with different filters (I used 4 files to leave organized).…
-
0
votes1
answer341
viewsIs it possible to space two texts in centimeters in the same Excel cell?
As the example of the figure below. i need to tabulate in a single cell two texts so that from one cell to the other (from the same column) the texts on the right are perfectly aligned (see column…
-
0
votes1
answer604
viewsConcatenate Userform text and insert as link in a cell
I’m trying to feed a table with 3 information inserted from the execution of a Userform and, at the end, make a direct hyperlink in the cell with the information inserted. The information is as…
-
0
votes1
answer136
viewsRename a variable and update it in the rest of the project
Have some easy or automatic way to update the rest of your code when renaming a particular variable on the line Dim? What do I have: Dim ABC As String If Range("A2").Value = 1 Then ABC = Range("C2")…
-
0
votes1
answer288
viewsReset the counter every time you change line
I have the following problem: I have two counters within my code, but I want every time I change to the next line the countLinha1 (second counter) is zeroed and starts counting again, remembering…
-
0
votes2
answers2684
viewsRead . js file and write to page using javascript
I have an Excel spreadsheet that I want to export some data to upload to an HTML page. Searching the net found that this is only possible if I have this data in a file . JS (type Data.js). So far so…
-
0
votes2
answers2427
viewsSQL Query VBA Excel
Good afternoon! I have a problem with a query in Access via form. The Form is from Excel vba, which connects to the database. Below is the complete code. This is the code of the button. Clicking…
-
0
votes1
answer497
viewsData type Mismatch in criteria Expression + Excel data handling
Check to see if the logic is consistent, please. The procedure of this code is: Consult a procedure and store her data in a DataTable: private DataTable ExportPerformanceEntrega() { try {…
-
0
votes1
answer956
viewsWeb data query in Excel
work in a company and need to monitor the lifetime of printer toners daily... For this I created a monitoring spreadsheet, only I wanted a practical system, like this: When I insert the web address…
-
0
votes2
answers151
viewsHow to map an Excel column to a Database column
I needed help to do the specific mapping of a column of an excel file to a column of a database. I can read the excel file but I just can’t map the file to the column I want in the database. If you…
-
0
votes0
answers299
viewsError while trying to open an Excel file
I am trying to open a document in excel via vbScript. I am not succeeding in running, the following error is generated, without description: -2147417851 The problem occurs when executing the…
-
0
votes1
answer69
viewsformatting according to cell content
I have a spreadsheet with columns A, B, C and D, where column A, B and C is a PROCV where you search the email address in other spreadsheets of each seller and column D is the name of the…
excelasked 7 years ago Rinarikato Mekitoji 15 -
0
votes1
answer1976
viewsUse of Transferspreadsheet via VBA
I’m finishing my improvement project and there’s something that intrigues me a lot. I needed to make a report based on the result of an SQL query, which I even questioned in Export SQL query data to…
-
0
votes1
answer3105
viewsHow to assign the value of an Excel column in an SQL command
I was able to connect to my Mysql Database via ODBC, and display the information I need via SQL command, but I would like the contents of a particular cell of my spreadsheet to be in this SQL query,…
-
0
votes2
answers99
viewsFormula values do not match
I’m trying to do the Excel formula VF(future value) in PHP, but the values are not matching, IE, in Excel is a value for the column and in the calculation of PHP come out other values but almost…
-
0
votes2
answers1621
viewsPass values from one form to another
Expensive I have two A and B forms. A = Has listview and displays base information B = Need to receive form A information and display. (Information that is not displayed in form A) I need to make it…
-
0
votes1
answer3790
viewsCheck if a Listbox item has been selected
I have a list ListBox1 q a check box ChckBox1 in a Userform. I want to activate or inactivate the checkbox (CheckBox1.Enabled = True/False if an item in the list is selected. The check-box is…