detected

Hi! I've been using the below piece of code successfully before . . . Dim myPath As String myPath = ThisWorkbook.Path & Application.PathSeparator 'Change path If IsFileOpen(myPath & "IzborQ.xlsx") = True Then MsgBox ("File is already opened")...

Is it possible in VBA to detect a system wide key or mouse movement? I need to trigger an *action* when any key or mouse movement is detected system (Windows) wide

Hello friends, Hope All is well! Going crazy! I keep getting the error msg: SQL statement is not valid. There are no columns detected in the statement. the idea is borrowed from: https://www.contextures.com/PowerPivot-Identical-Excel-Files.html it is to add data from a workbook (4 sheets) to...

Good day all. I'm working with a bunch of laboratory results that has data qualifiers for results that are not detected and flagged with a "U" data qualifier for "undetected". However, my range of cells has a mix of numbers (detections) and some are numbers with the not detected "U" value. An...

Hello, I built a pivot table with several measures that key off a single date, for which I created a disconnected table on a tab in my workbook with one column and a single date value. The purpose being, I update that one date periodically based on the period I want to evaluate. Probably a...

Morning all, I was kindly advised a code for a worksheet i am using but i would also like to use the same code on another worksheet. My issue is that i get the Ambiguous named detected message because i already have a code using the same name. This would be Private Sub Worksheet_Change(ByVal...

Hi I created a Sub name but Excel stopped the code from executed and said "Compile error: ambiguous name detected: SavingANewlyCreatedWorkbook" The sub name is below - any ideas why? Sub SavingANewlyCreatedWorkbook()