![VBA]()
VBA
Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-le...
Read more- 16K Content
- 1.3K Contributors
Expert Spotlight
Senior Data Analyst
Veteran in computer systems, malware removal and ransomware topics. I have been working in the field since 1985.
Leading Experts In
Troubleshooting Solution
Troubleshooting Solution
VBA Add a path to save pdf
I need to specify the path where the pdf is saved in the existing VBA code.
Can anyone help?
Sub
…
Troubleshooting Solution
Listing files in a folder
Dear experts,
Kindly help me a vba code/macro/excel tool which can list the files in a given folder
…
Troubleshooting Solution
VBA remove filter before copy/paste
I use this code to open each excel file and copy to a compile sheet. Sometimes the data is filtered,
…
Troubleshooting Solution
Concatenate Sheet Name in Excel Formula
Hi Experts,
I have an Excel file with many sheets (don't know hoow many). All sheets are named by
…
Troubleshooting Solution
Troubleshooting Solution
VBA code to extract unique values from more than column with unequal set of rows
Dear experts,
I have in the past raised several posts for extracting the unique value from a single
…
Troubleshooting Solution
DLookUp function gives a flashing #Error
I have a form "ChismosaBuyerGuideFormWeekly" with a text field named "PrdtID", and a "Products"
…
Troubleshooting Solution
Exporting an Access query gives "rolling" worksheet name in Excel
I have a function in Access that exports a number of queries to an Excel file.
All of the exports
Troubleshooting Solution
VBA code to compare two tables.
Hi Experts,
I need to compare two identical tables, one is an Access table, and the other is a CSV
…
Troubleshooting Solution
Macro to detect duplication of numeric part of a number
In Excel I have a list in column B which looks like this
MW1-RPI-14011
MW1-RPI-14012
MW1-RPI-14013
…
Troubleshooting Solution
Help combining 3 macros into 1
Hello,
I need help with a macro.
I'm trying to combine 3 macros onto the Format ZH88 Data button
…
Troubleshooting Solution
return only matching numbers in cells with no errors or blank cells between results.
need to remove errors from list returned in R4#. Using the IFERROR function just replaces errors
…
Troubleshooting Solution
formula that returns all days in number format from date list
requesting formula that returns all days in number format from date list in cells B4#.
The attached
…
Troubleshooting Solution
VBA code for paste blues but in same format
Dear experts,
In the attached image, there is a code for copy and paste special as values.
Currently,
…
Troubleshooting Solution
excel: remove text before a character in entire sheet
I have an excel sheet which looks like this: test1.xlsx
Is it possible to remove everything before
…
Troubleshooting Solution
Why can't I autofilter for yellow cells?
I have this macro which is supposed to copy all yellow-colored cell to Range("A1") in the
…
Troubleshooting Solution
Global Template in Word STARTUP folder does not work as expected
I have a Word global template (.dotm) that creates a custom tab in the ribbon menu, from which my
…
Troubleshooting Solution
"New" outlook throws error when using VBA automation
I've written an Access application that uses automation to generate email messages in Outlook. When
…
Troubleshooting Solution
Excel VBA
I have a spreadsheet with a number of columns and rows as an exported set of values
I need to carry
…Explore solutions and more
Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.