I'm getting a strange #N/A error excel/vlookup. I have a database connection with sql query returning a lot of rows ~40k. I have a field with two data values se
When I send mail free from attachment, works truly. But when I using the .Attachments.Add ActiveWorkbook.FullName parameter, it does not send and been pending
I'm new with PHP, I'm developping a WEB application that display a table with informations from an SQL server DATA BASE, the problem that I want to add a button
Context I've written some code in VBA to subclass a userform so that ultimately I can intercept WM_TIMER messages being dispatched to it. I'm doing this instead
I have two pivot tables, each with two columns. One column is a range from 0 to 6.5, grouped by .5 and the other column is the percentage of the whole column th
I have a set of values that I want to find the average for. The values are in different cells, not near each other. The value of zero should not be considered.
I am trying to get data from specific cells in a row in SAP, into an excel table using VBA. When I record a macro of me clicking the 5-6 items I need, it only g
I'm trying to run a macro that replaces data in a table in Excel, when the data might initially be filtered. The code should remove the filter first, then run
I have this kind of column in my Excel: A B gbgdf, dsfsd, gdgdf, TC-EVTgfdsfs, gdfgd, I am willing to copy every cell that is NOT starting with
I'm attempting to pull contact information from an Outlook.ExchangeUser object using VBA in Excel. However, so far I've only been able to get the primary SMTP a
I have written a code in R which is supposed to retrieve certain information from a website and import it into an Excel file. I have used it for one website and
I'm using PhpSpreadSheet and I need to save the sheets contained in a workbook as individual CSV files. I've tried to use $reader->setLoadAllSheets(); but
I try to take a table and create a pivot table adjacent to it. This macro needs to work on separate worksheets so the table and pivot table names need to be ge
I am getting unexpected results when passing a boolean() array to a variant type (the variant type resides inside a class module). I expect to get a value of tr
I have a DataTable with 200,000 rows. I want to export DataTable in excel file. But it gives System.OutOfMemoryException error. using (ExcelPackage objExcelPa
I am trying to create a formula that returns the concatenation of two arrays of different lengths. I need this concatenation for part of anoth
I'm trying to accomplish that if you click on a hyperlink (in column P), it would copy the cell in the same row but in column B to another cell (A3). I'vre trie
I am new to Excel VBA. With reference from a search engine I have created the above code but stuck at one point. My requirement is to sum data in the range of s
I'm using MS Excel O365 Business in version 1905 (compilation 11629.20196). In this case i have created two sheets: 1) "Orders" 2) Order_status NUMBER_ORD
I am trying to update an existing Excel file with many formulas. I can't use evaluate-function ( Excel-file contains a function not supported by Apache POI )