Category "excel"

How to stop OutLook Security Message programatically : A program is trying to access e-mail addresses, Allow access for 1 Minutes [duplicate]

How to stop OutLook Security Message : A program is trying to access e-mail addresses, Allow access for 1 Minutes I want to stop this a

Excel drop down values from a SQL Server source

I am trying to get a cell drop-down values in Excel from a SQL Server. I don't want to use the method of putting all the data to another sheet and the use data

Excel 2016: Error accessing file. Network connection may have been lost

we are developing an Excel 2016 Workbook using VBA. I descrivbe the error from my side, but it occurs at several independent Computers - even at the customer's

Run-time error '1004' Insert method of Range class failed while adding column

It seems pretty easy, but not able to find workaround. Excel 2010. Aim: adding 22 empty columns starting from B Error: Run-time error '1004': Insert method o

Get sender's SMTP email address with Excel VBA

I pull the Subject, received date and sender's name with the following code: Set InboxSelect = GetObject("", "Outlook.Application").GetNamespace("MAPI").PickFo

Find certain code combinations using text (sub)string in Power Query

I had similar question (link below), but it just lets say "add-on" to my issue that I found on the way. Find all code combinations using text string in Power Qu

Find and replace not working with trackchanges

I´m trying to find and replace multiple sentences from different word files from an specific folder. The words that I´m trying to change are on two

How to list ingredients for a product if one product can have another product as ingredient

Ok, so here is my simple table, P1-P4 = Product, Ix = Ingredient +---------------------+ | A B C D | +---------------------+ | 1 P1 I1 I2 I3

Excel VBA function with Recordset (Performance issue)

I have a database in SQL Server that I'm using to feed some financial reports in Excel. I'm using Recordsets through a custom Excel Function that uses arguments

Cannot remove code modules from a destination workbook through VBA

I am running an Excel 2010 macro that opens another workbook and removes a few code modules (a form and a BAS module). After that it re-imports them as an updat

Generate sql insert script from excel worksheet

I have a large excel worksheet that I want to add to my database. Can I generate an SQL insert script from this excel worksheet?

Laravel Excel::store file empty after stored

I uploaded this excel file: myExceldocument.xlsx After uploading I want to store in a folder. I used this method: $uploadedFile = $request->file('files')[0]-

Macro to change colors of specific characters in a range

I wanted to develop a macro for my worksheet that would pick up a range and change the color of specific chars based on its color. This was similarly answered b

Userform resizing according to screen resolution

I have an Excel userform I want to resize on opening to fit the screen resolution. I get the height and the width through Application.Height and Application.Wi

How to create identity column when importing data from Excel into MS SQL Server (with Import and Export Wizard)?

I need to import great amount of data from excel into MS SQL Server, using the Import/ Export Wizard. Then I'll continue importing more data into the same table

Sharepoint Power PI Connection Requiring Input Of Credentials

I have an excel workbook with 8 Power BI queries to a Sharepoint site. The queries work, but every day I have to clear the permissions on the data source. I the

Conditional move loop - VBA excel

I just learned to use VBA in excel, I have a spreadsheet as shown, I have columns from B1:B12 containing content to search and move, I want to build code to se

Apache POI: Is it possible to use SXSSF without temporary files?

I'd like to use SXSSF (Streaming Usermodel API) from Apache POI. What I don't like is that it uses temporary files. Question: Is it possible in Apache POI to f

How to ignore the format error flag in the cell number format

My code: columns = ws.get_Range("A:F", System.Type.Missing); columns.NumberFormat = "@"; After I debug the program, there is green color flag beside my number

If a cell in range of cells in Excel 2010 contains specific text, move whole cell text into a different column

I am struggling to find an answer to this one... Each month I am provided with a spreadsheet full of clients data that is a raw extract from some sort of CRM s