Category "excel"

Runtime error 1004 Method OnKey of object '_Application' failed

the following code causes runtime error '1004' Method OnKey of object '_Application' failed! Any suggestions? Sub MyAchieve() Dim col As Integer Dim row As

VBA in Outlook to pull specific data into excel

I need some VBA code in outlook to save specific lines of data from emails as per below into an excel folder - see sample excel table below. I need the code to

Process to Import specific text in excel with VBA

I'm trying to import many tables into excel (with fixed width option selected) and I would like it to paste it to certain areas as a function of "i", see below:

finding cell value and delete it in excel vba

I want to return the value of the cell it's found in VBA and clear all of it's content with another 3 rows below it as well, but I'm currently stuck. I can find

Excel Time Conditional Formatting

I have exported a csv list with start tine and end time. After that I have created a new column with the duration differences. How can I make the cell red for &

Saving xlsx file in csv tranform simple quote to triple quote (since today)

Since today, excel interprets the data of my xlsx file to add additional quote in the csv file. It's anonying since I want only one quote for some columns and n

How can I call a subroutine after an error?

I'm working on user-proofing a VBA app in Excel and I realized I'm constantly rewriting a lot of the same code to create specific error messages that are fed st

Office add in excel- Combination of task pane and udf

i created an office add in for excel (office.js / 365). The add in creates a sheet with a form. The user put values in the sheet, clicks on the button in the ta

How to parse a JSON/dict-like value from an Excel sheet and copy over to another column?

I have an Excel sheet, where data is entered in this format: {"id":"03CD2B3C22558D83","imp":6667, floor:7777} How can I in python read and extract a certain va

Iterate through rows and columns, compare dates and if statement true sum and print in new column

this is my first question here and i can't find a solution that works for me. I have a set of data. i need to compare the date displayed in cell 2,2 (until 2,10

Count/Sum a column but exclude #N/A

Currently using the following forumlas to count the number of records in all of column Z that does not have #N/A but it does not work. All the rows in Column Z

Excel Chart not updating correctly with VBA

So I have made a macro to export a chart and then import it into a userform as picture. Import/export is working fince, byt the chart is not updating when the d

How to upload whole Excel range of data to SQL server using VBA (without Wizards or looping row by row)?

I am trying to upload a range of data in excel (same structure as target SQL table) to a table in SQL server using VBA. I do not want to loop row by row but tra

VBA - Macro Copied Workbook, Pivot Data Source not Updating, Error with Pivot Cache?

I'm writing a macro that takes a master file, takes a list of sales people, and for each sales person (RSL) creates individual copies of the master file and edi

How to find the Consecutive Days from a list of dates or data frame

I need to find consecutive days from the data frame but I am having some trouble trying to find them. I tried R, Excel, and Python but still couldn't find the s

Can i make a RapidPro flow automatically by importing a Json file in it? How?

I had build rapidpro flow manually till now , now i want to automate it . What i want to do is convert a excel sheet (provided to me by my organization ) to jso

Creating column chart in Excel with Secondary Axis

The following are 3 tables I have in my excel file. Gender Participants (n = 200) % Female 160 80 Male 40 20 Area Participants (n = 200) % Rural 80 40 Urban 1

Copy Pasting Data from a column to a free column, removing empty lines

I was not looking at VBA for a while, and I would really appreciate your help. Private Sub EvaluateButton_Click() Dim r As Long Dim x As Long Worksheets("tests

Export excel data into new workbook

With some of the success of other automations, I am looking to see if it is possible to move rows of data from my excel workbook into a new one based upon the v

Return result on conditional format

Im working on a excel script, that will import a CSV file, analyse the result and create a report based on the analyse. The CSV file contain up to 12 measuremen