VBA

4K

Solutions

7

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 want to copy also the row height, from row 1 to row 6, by these codes
(CODE)If you see the attached Excel file, some rows is having short height. How to ensure the above to achieve what I expect…

2749 views
Looking for New Ways to Advertise?

Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

First Tab - Master customer data file. Tab Name = "MASTER"
Second Tab  - specific data for an individual customer. Tab Name = "13 n clark"

Goal: How do you automatically populate the 2nd tab from …

1435 views

Hi,

Don't know very much about forms so sorry if this is a roundabout way of describing my isssue.

I have a table of sales orders that includes a Yes/No field added on called 'SelectedPrint'. I'…

613 views

Hello guys i am trying to find out if this is possible, thanks again for your time and help.

On the "J" column have the Letter (Q) display no more than five times with the color of BLUE if on colum…

812 views

I had this question after viewing Clubbing C (https://www.experts-exchange.com/questions/28971936/Clubbing-C.html).

Hi Experts,

Need little change in existing macro or say troubleshoot. in atta…

33 views

I have an unbound record-search combo-box on a form that after awhile stops working when I publish the database as an accde but I dont know why. Each time it happens, replace the database with a new a…

46 views

Dear Experts:

Below Code converts Path Entries in Column 'B' to Hyperlinks. The macro works just great.

Could somebody help me to tweak this code in the following way:

The path entries cou…

27 views

I want to create a library of VBA code in Word.
Is there a way of pasting the code so that it preserves formatting, tabs etc? (and remove spellcheck!)

Thanks.

Also, I'm open to suggestions on h…

316 views

I had this question after viewing Posting C - Partial (https://www.experts-exchange.com/questions/28971419/Posting-C-Partial.html).

Hi Experts,

Will anyone help me with club this 3 Macros in to …

418 views

Hi,

New to MS Access so apologies in advance for glaring errors. I'm trying to leverage an Access template to build a database which can create and print invoices (or save as PDF).

Have a form c…

220 views
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Hello,
I have a code for wordmerge but, the match case doesnt seem to work .
I have TO:  and To: to replace and it is not able to distinguish between the cases and replaces everthing .

(CODE)

89 views

on this module i would like to create an additional request that when it finds the word (ZCOMPLETED) have it appear on column "C" (Z)
and (HOLD) Appear (H). thanks for your time and help guys.

315 views

how can I disable clipboard on Excel with VBA?

219 views

I would like to make two function work in conjunction when i click on one button. Thanks again for your time and help.

I would like to have this code from Modules

(CODE)

To work in conjunctio…

921 views

Hello and good day to all Experts Exchange users and helpers. I am trying to have this work in this way.

Search for column "G" and find all with number that has 1 on column G.

***If there is a n…

1120 views

I am trying to copy the data from one sheet to another using vba. But it copying and pasting the data with the header. Is there any way it doesn't copy the header just copy the data with the selection…

1532 views

I have a multiple workbooks which has columns to Workbook and I have standard a standard excel file. All i have to copy each workbook into standard template and save the template with cell D1 and re56…

918 views

I Receive an Input file with thousands of rows and multiple columns

Below are the steps

1: In the Input file I have columns A:R
2: I have file upload template (standard template desighne to up…

1937 views

Instead of MID which starts at the beginnng of a line of text, the formula or user-defined function that would start at the end of the text and search toward the beginning.  I need to select from the …

316 views
Course: JavaScript Coding - Massive 12-Part Bundle

Regardless of your programming skill level, you'll go from basics to advanced concepts in a vast array of JavaScript subjects including Sammy.js, Agility.js, Ember.js, Node.js, jQuery, AJAX, Extjs, AngularJS, Knockout.js, and JSON.

I have a document where question and answer have different styles assigned to each (for question "*Questions" and for answer "Normal"), answer can have multiple paragraphs or even image, so basically …

105 views

Hi Experts

I have an Excel table which I need to filter, need to copy resulting set into empty email and send it to appropriate recipient.

I tried to play with VBA in Excel, I can filter table, …

46 views

Regardless of if the filename is 10 characters or 100 characters long.

in Powershell preferably.

Thank you very much.

K.B.


ex.

BEFORE: contoso.contoso.spreadsheet.local.renameme.Data…

1225 views

When I send this to Access 2016 via ADO/VBA I get an error 'syntax error in INSERT statement'.

But when I copy/paste the same into the Query window in Access it runs OK. No error!

Am I missing s…

712 views

Hello Experts Exchange Community, trying to create a code to do the following.

Search:
search for today date.

Then calculate how many days is left for each rows, that has dates on the "B" colum…

514 views

Hello Experts Exchange, I want to add more words to these code module. The code module show two words at this time, "" and "DONE" want to add "NOW"     "THEN"    and   "ZLAST" to the one that i curren…

715 views
Show more content
201506-LO-Top-001

TOP EXPERTS

view all

RELATED TOPICS view all topics

  1. MS Excel
    (127,791)
  2. MS Access
    (214,909)
  3. Visual Basic Classic
    (163,436)
  4. VB Script
    (36,154)
  5. MS Office
    (56,840)
  6. MS Applications
    (43,116)
  7. MS Word
    (26,842)
  8. Programming
    (51,761)
  9. Outlook
    (93,919)
  10. Spreadsheets
    (5,953)