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
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
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
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
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
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
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
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"
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
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 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
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
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
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
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
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
I just received an excel and see there are some formulas including some "_xlfn" and "_xlpm". What do they mean?
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?
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
I am using the code below Private Sub Worksheet_Activate() MainSh.Range("D2").Select With Selection.Validation .Delete .Add Type:=xlValidateList, AlertStyle:=xl