Category "excel"

VBA is sometimes not recognizing Excel file that has been opened through SAP GUI script

I have a SAP GUI script running every day in VBA. In the script I am exporting some data from SAP to several different Excel files, and these are saved to a net

excel button connected to macro having runtime issue

My vba code connected to a button is crashing on runtime. It is stating sub or function not defined. I am new to vba code so I dont know how to solve this. It a

Populate combobox with unique numbers

The following code populates ComboBox on a userform in vba with unique values. I use the same code to populate two other ComboBoxes. It doesn't work when the da

Excel Formula to Replace Numbers List with Default Text

Using Office 365 Excel On a regular basis I download a csv file from a remote application, the file contains a column of unique numbers. There could be 50 rows

Get the file list of a folder with Dir

I'm trying to get the file list of a folder in VBA The DIR command acts as if the * wildcard is messing up the whole mask that I input. Here is my file list: No

Application.Match gives type mismatch

I am trying to use Application.Match however it is returning a type mismatch error:13 error. Why? Dim mySrs as Series Dim ws as Worksheet set ws Activesheet Fo

Most Reoccurring Text Between 2 Dates Excel

Got a bit of a pickle. Trying to find the most used delivery company for orders in a specific month. Say the company was in Column A, and order date was in Colu

Excel: How to add a plus sign to numbers and how to copy actual value of that cell (+876345558)

I have a subscriber list with emails and phone numbers. The row with the phone numbers are plain numbers (like 98734543). With format > custom > "+0;-0;0"

Performing Excel formula in Python

import numpy K = 1 Rmv = 26 SigS = 111.7 M = 2.050 N = 2 SigD = (-249.4) def Mittelspannung(): result = [] Y = [] SigM = [] for i in rang

Macro that needs to be more dynamic based on selection

I have this code and i find myself creating 12 times and modules since I have 12 different colleges, each with a unique names. I would like to make a bit more d

Import Excel xlsx to Python using Panda - Error Message - How to resolve?

import pandas as pd data = pd.read_excel (r'C:\Users\royli\Downloads\Product List.xlsx',sheet_name='Sheet1' ) df = pd.DataFrame(data, columns= ['Product']) pr

Using python how to take input search string from one excel sheet column and search in other excel on a specific column?

For example, take input string _TXT from col A in file 1 and search in file 2 col X. If any row contains _TXT, then for that specific row compare col B value to

VLOOKUP as a range

I have a table in a tab with columns: street_id, street_name, street_corner_1 and street_corner_2 (a street corner is the name of the street that intersects it

Trouble Connecting to SAP Through VBA in Excel Error 614

I'm trying to run a basic code I've found numerous places on here and elsewhere which should open SAP, input a command, and execute. I've gone as far as SAP ope

How to autofilter a column with values coming from a specific range

Hi all i hope you can help me with this issue since i just started learning VBA :) I need to autofilter a column of an excel sheet with the values coming from a

If sheet does not exist go to next Python

I'm writing a code that allows you to select the tables in a workbook sheet and send it by email. But it can happen that a sheet does not exist because there is

What are _xlfn and _xlpm in excel mean?

I just received an excel and see there are some formulas including some "_xlfn" and "_xlpm". What do they mean?

Can we export a react bootstrap data table to Excel instead of CSV?

I have a requirement to export data into Excel instead of CSV. Is there any possible way we can achieve this feature using the react-bootstrap-table?

"Unable to set the CurrentPage property of the PivotField Class" with Pivot Table Filtering Attempt

So I have been trying to figure out what I am doing wrong for the past two days and I can't seem to get past this error. The error is "Unable to set the Current

refreshing dropdown list when source data changes

I am using the code below Private Sub Worksheet_Activate() MainSh.Range("D2").Select With Selection.Validation .Delete .Add Type:=xlValidateList, AlertStyle:=xl