VBA Solutions

Troubleshooting Solution

Macro code problem

byPeter Chan

2024-04-109

Hi,

It is having the error

to the line like

Worksheets(List1).Cells(RowID2, 8).Value = Format(Now -

…

Troubleshooting Solution

VBA Add a path to save pdf

byEuro5

2024-04-012

I need to specify the path where the pdf is saved in the existing VBA code.
Can anyone help?

Sub

…

Troubleshooting Solution

Excel VBA code to copy data from several spreadsheets to a master spreadsheet based on a criteria

bySteve Avery

2024-03-2823

Experts,

I have an Excel VBA question about copying data from 8 spreadsheets into a master

…

Troubleshooting Solution

Listing files in a folder

byexcel learner

2024-03-232

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

byEuro5

2024-03-223

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

byAPD Toronto

2024-03-218

Hi Experts,

I have an Excel file with many sheets (don't know hoow many). All sheets are named by

…

Troubleshooting Solution

Ms Word vba ignores path information in application.run &quot;path!macroname&quot;

byRobert Berke

2024-03-185

in doc1.docm document

Application.Run "'c:\aaatmp\doc2.docm'!module1.TESTSUB"

is not

…

Troubleshooting Solution

VBA code to extract unique values from more than column with unequal set of rows

byexcel learner

2024-03-185

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

bydailymeat

2024-03-188

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

byMik Mak

2024-03-154

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.

bybfuchs

2024-03-135

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

bySaqib Husain

2024-03-075

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

byAudra Breedlove

2024-03-065

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.

byPedro

2024-03-064

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

byPedro

2024-03-059

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

byexcel learner

2024-03-013

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

bynav2567

2024-02-284

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?

byMartin Liss

2024-02-279

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

byBryce Bassett

2024-02-261

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

byMitch Schwartz

2024-02-266

I've written an Access application that uses automation to generate email messages in Outlook. When

…

Explore VBA on Experts Exchange

VBA

Macro code problem

VBA Add a path to save pdf

Excel VBA code to copy data from several spreadsheets to a master spreadsheet based on a criteria

Listing files in a folder

VBA remove filter before copy/paste

Concatenate Sheet Name in Excel Formula

Ms Word vba ignores path information in application.run &quot;path!macroname&quot;

VBA code to extract unique values from more than column with unequal set of rows

DLookUp function gives a flashing #Error

Exporting an Access query gives "rolling" worksheet name in Excel

VBA code to compare two tables.

Macro to detect duplication of numeric part of a number

Help combining 3 macros into 1

return only matching numbers in cells with no errors or blank cells between results.

formula that returns all days in number format from date list

VBA code for paste blues but in same format

excel: remove text before a character in entire sheet

Why can't I autofilter for yellow cells?

Global Template in Word STARTUP folder does not work as expected

"New" outlook throws error when using VBA automation

Do more with Experts Exchange.

Explore solutions and more

VBABack to the top