Adding data filter to excel index array formula

OK, so I have a “working” knowledge of excel formulas, but I’ve confused myself a bit with this one’s complexity. I have a sorting array in “Sheet 2” that works perfectly to grab unsorted data from column “E” in the sheet “Level 4”, sorts the data, drops any blanks and returns a list sorted by […]

Get data from ListObject not made from code

In a VSTO Workbook, I would like to get data from a ListObject made from Excel. So there is not such things like DataBinding in code. What I would like to do is something like that : var rows = ((DataTable)Globals.Feuil1.MyNamedListObject.DataSource).Rows Unfortunately, here DataSource is null because, of course, it is not bound.

Excel macro / script to cut/paste text between columns

I am working in as a business developer, however the problems in our support department sometimes require me to work on clients’ CSV file i.e. Excel spreadsheet containing product catalog. Right now I have an Export CSV from an online store, where the first column is formatted in the following way: Name_of_the_product – {store category) […]

VBA Loop Through Sheets Macro Not Working

Sub DeleteBlankColumns() Dim ws As Worksheet Dim lColumn As Long Dim iCntr As Long lColumn = 500 ColumnEnd = 1000 For Each ws In ActiveWorkbook.Worksheets If ws.Name = “Auto Losses” Or ws.Name = “Auto Liquidation” Or ws.Name = “Auto Units Liq” Or ws.Name = “Specialty NCL” Or ws.Name = “Specialty Liquidaton” Or ws.Name = “Specialty […]

Is there a way to run macro every minute to merge API data onto a dataset? VBA

I’m new to VBA. I’m trying to work on a project where I have an Excel API which pulls data. Example: Price Datetime Volume 121.0078125 10/21/2016 12:20:00 AM 449 I’m trying to create a dataset on another workbook which captures the API data by the minute based on Datetime. Is there a way to do […]

Why this formula code is to be not working on future days (in date difference)?

I have the formula to be calculated the date difference(interms of hour) in between two Date/time fields but I have only calculated the number of hour in a day is to be in the 9 AM – 9 PM i.e 12 hours per day only the formula calculated and the calculated days are weekdays not […]

Activating appropriate worksheet and renaming it

I have been adding worksheets from different workbooks into one for ease, however, when I copy and paste the code into the new model in the new workbook, the code keeps on showing me an error, despite it working in the old workbook. In the code below, how can I activate worksheet “Question3” and have […]

Insert value beside imported data from Excel into SQL Server via

I am facing an issue as below: I’m creating a daily performance management tool, so I need to import Excel files into a SQL server table and I need to import these values with a specific date to be picked from a textbox control. I can import normally from Excel into the database but can’t […]

The requested OLE DB provider Microsoft.ACE.OLEDB.12.0 is not registered. If the 64-bit driver is not installed, run the package in 32-bit mode

I’m trying to run a job in SQL Server Management Studio that executes a SSIS package. The SSIS package copies data from an excel file to a database. I installed the 64-bit version of Microsoft Access Database Engine ( When I tried to run the SSIS package by itself (through Data Tools, not as a […]

Repetitive copy/pasting with a change in a only a few fields

There is a worksheet that I have to create on occasion that I need to constantly copy/paste (default info) and then only change 2/3 fields (with info from another worksheet) in order to populate the worksheet. Because of the repetitiveness I feel like there could be a macro/formula which could greatly improve the speed of […]

MS Excel Spreadsheet is the best Office Software, Excel VBA and Excel Formulas make Spreadsheet work faster.