ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.
One of a set of tools we're offering as a way to say thank you for being a part of the community.
Course Of The Month
8 days, 18 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
VBA
6K
Solutions
20
Articles & Videos
2K
Contributors
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.
Refine results
Hi,
i need to remove all the custom formatting of all unused cells of the workbook, as it does not have much data but file size is more than 10 MB.
can anyone please help with the VBA to do …
313 views
Free Tool: ZipGrep
Hi,
I also want to capture values of M/C/O, on either Column 3 or 4 of Sheet5. How to adjust Scan_list4, of the attached file?
513 views
Good Day!Please help me on this..
1. I want to copy the data from these columns ID Code,Name,Store,Product Code, Brand,Form,Days,Category and Sales Using VBA.
2. Paste these values to another …
1823 views
- VBA
- Programming
- Microsoft Office
- Microsoft Excel
- Macros
- VB Script
Is there VBA code that will convert a mapped file path to a UNC?
Example:
P:\folder 1\myFile.xlsx
....converts to....
\\server1\group\Public\fol
415 views
in my folder C:\Flora\Downloads i have pdf files with website link with it.
i need help with powershell so that when i run it, it removes are URLs and replaces the addtional dots / with spaces.
…
1625 views
Hello,
Can I reference a table by the ID and use column 2
BgRg1 = [tblVGBadgeNumRange].[ID](
BgRg2 = [tblVGBadgeNumRange].[ID](
314 views
i have a boss, which is a old lady and does not understand excel table structured references, every time i sent her the file, she asks me to convert the formula reference back to explicit cell …
310 views
I had this question after viewing VBA how to delete all objects regardless of its type from all worksheets in workbook …
212 views
I had this question after viewing VBA to clear/put no-fill the cells background color for all sheets of active workbook …
515 views
i have received a mess, so many entire rows and entire columns background colored and text colored.
i need help with VBA that restores all of the cells background colors and font to the default. by…
525 views
Free Tool: Port Scanner
Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
I am trying to figure out how to format a text Content Control for the following alpha-numeric set.
1212-121-ABC-1212
The user should simply type all characters and the formatting or mask would …
1329 views
I would like to have Unique Customer List in Userform from Sheet (Sales) Col A
319 views
Within VBA I am trying to determine how to:
Sum Column A record Count in Worksheet A * 2 + Sum Column A record Count in Worksheet B
Compare with the Sum from Column A record Count in Worksheet C…
729 views
Good Day! I have these code below which it gives me an error of "We can't paste because copy area and paste area arent the same size".. Please help what is wrong with these code... :(
(CODE)
339 views
Hi all, anyone can help me to solve my problem. I want save my Power Point 2010 from Excel VBA? Here I attach my Workbook. I already write code for save the PowerPoint but it does not work as what I …
525 views
Hi Experts,
I've got a fairly simple recorded macro that attempts to clean up a phone number list by removing "(", ")", "-" and spaces but while it is removing the "-" and spaces, it is not …
725 views
Hi Experts,
So, I want to use VBA to color the cell in Column C of Sheet1 if 1st three numbers * (Area Code portion of the phone #) match any of the numbers in Column A (Area Code) on Sheet2. I'd …
2241 views
I was wondering if anyone could please help me with creating a userform through my pre-established workbook to allow me to add data to any worksheet of my choosing through one User Form.
Thanks for…
418 views
I have the below code which deletes a record if the cell has no value. This should be a rare event (a delete). However, for some reason when I run (click on a form button that runs the code) the …
3020 views
[Webinar] Code, Load, and Grow
![[Webinar] Code, Load, and Grow](https://filedb.experts-exchange.com/files/public/2017/4/5/f91bafda-e65e-40df-8595-dc0d8c14c6d6.jpeg)
Managing multiple websites, servers, applications, and security on a daily basis? Join us for a webinar on May 25th to learn how to simplify administration and management of virtual hosts for IT admins, create a secure environment, and deploy code more effectively and frequently.
My OS is win 10 pro 64 bit. I have Office 365 Business Essentials, and I use Access 2016. I have a application where I have a Form for data entry.
When the Form is opened, there is a command …
427 views
Dear Experts
In Access I to need to convert all the CSV files in a folder (and its sub folders) into xls or xlsx format and save then in a different place so they can be imported into the database…
1041 views
i have 3k rows in column A with lists like this
Reliance Medical,Olympus,Physiq,Bos
1425 views
Hi,
i have a data in M column of dates for example 5.19.2017 and i am replacing the . with / with a macro.
so when i run the macro the format is changing i don't know why.
Please suggest.
819 views
Hi every one, I Hope someone can help with conditionally trimming using VBA
I have a long text string will vary from time to time but only one word "Holliday" is always existed somewhere in the text …
824 views
Hi,
I am running a macro, after running the macro the date format is getting changed and its effecting the other sheet. i have attached a sample file to the question. after running the macro the …
315 views
201506-LO-Top-001
VBA
6K
Solutions
20
Articles & Videos
2K
Contributors
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.
Top Experts In
VBA
-
1
Shums74,452 points -
2
Rgonzo197137,400 points -
3
gowflow27,632 points -
4
Bill Prew26,300 points -
5
PatHartman18,600 points -
6
Subodh Tiwari (Neeraj)18,332 points -
7
MacroShadow15,645 points -
8
Martin Liss14,958 points -
9
Gustav Brock14,845 points -
10
Norie13,200 points -
11
Roy_Cox12,264 points -
12
Wayne Taylor (webtubbs)11,100 points -
13
Ryan Chong10,000 points -
14
Neil Fleming7,000 points -
15
Jim Dettman (Microsoft MVP/ EE MVE)6,171 points -
16
Mike in IT6,000 points -
17
Rey Obrero (Capricorn1)5,000 points -
18
Ejgil Hedegaard4,800 points
-
19
Qlemo4,634 points -
20
ste5an4,500 points -
21
Scott McDaniel (Microsoft Access MVP - EE MVE )4,000 points -
22
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)4,000 points -
23
Huseyin KAHRAMAN4,000 points -
24
chaau4,000 points -
25
Karl Timmermans (Outlook MVP)4,000 points