VBA

11K

Solutions

3K

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.

Share tech news, updates, or what's on your mind.

Sign up to Post

Exchange Rates and Currency Conversion in VBA


CurrencyExchange.png
When converting amounts between different currencies, you need exchange rates. This article demonstrates how to obtain these from no less than nine different sources, either for free or - for intense or demanding use - for a fee.

Exchange Rates and Currency Conversion in VBA

Code is also on GitHub: VBA.CurrencyExchange

Note, that web scraping is also demonstrated (The Central Bank of the Russian Federation), and the XE service is been included, though only a seven-day trial is for free usage.
0
Bootstrap 4: Exploring New Features
LVL 13
Bootstrap 4: Exploring New Features

Learn how to use and navigate the new features included in Bootstrap 4, the most popular HTML, CSS, and JavaScript framework for developing responsive, mobile-first websites.

ISO 4217 Currency Codes in VBA


Currency codesShould you need to maintain a table of current currency codes, here is how: ISO 4217 Currency Codes in VBA

My article demonstrates two sources:
ISO itself (the definitive source)
Currency Converter API
0
I decided to write a DatePicker replacement for the DateTimePicker control, since Microsoft no longer support it, the various solutions I found on the internet were nowhere near satisfying.

 You'll find some more detail about it here:
https://www.experts-exchange.com/discussions/221622/Looking-for-beta-testers.html.

Feel free to comment.
0
1
LVL 61

Expert Comment

by:Jim Dettman (Microsoft MVP/ EE MVE)
Very nice!

Jim.
0
I am in search of some assistance for a VBA project that I am working on. I have two tables "Table1" and "Table2". Table 1 contains a list of orders that need to be removed from Table 2. I need the VBA to start with  the first value of Table 1 search for the value in Table 2, delete entire row in table 2 and repeat for all values in table1.

Dim xlRange As Range
    Dim xlCell As Range
    Dim xlSheet As Worksheet
    Dim valueToFind
    Dim DELETE As Worksheet
    Dim DELETERANGE As Range
    Dim DELETECELL As Range
   
    Set DELETE = ActiveWorkbook.Worksheets("DELETE")
    Set DELETERANGE = DELETE.Range("A:A")
    valueToFind = DELETERANGE
   
    Set xlSheet = ActiveWorkbook.Worksheets("1386 DATA")
    Set xlRange = xlSheet.Range("B2", Selection.End(xlDown)).Select
   
   

    For Each xlCell In xlRange
   
        If xlCell.Value = valueToFind Then
            EntireRow.DELETE
        End If
    Next xlCell
   
0
0
Good Morning.
can any one give me the excel vba coding to extract email details from share email account?
0
How i can retrieve data from PDF to excel data sheet by VBA Scri
0
LVL 19

Expert Comment

by:Kyle Santos
Hi Muthanna,

You should go here and ask your question.  You'll get more replies and alert more experts by using the Q&A system.  Here you go https://www.experts-exchange.com/askQuestion.jsp
0
I have an access form, "frmCompetition" with a subform, "sfrmDogBrace." This is a database for field trials for bird dogs.   I would like to filter the contents of the subform based on selections I make in 3 separate comboboxes in the main form.  Any advice?  I've tried makeing the underlying query of the subform reference the contents of the 3 comboboxes as criteria.  No luck. Is there some vba code I could use?  My comboboxes are cboyear, cboday, and cbo brace.
0
LVL 61

Expert Comment

by:Jim Dettman (Microsoft MVP/ EE MVE)
Use the blue "Ask a Question" button in the page header.

Posts are for sharing news items.

Jim.
0
LVL 61

Expert Comment

by:Jim Dettman (Microsoft MVP/ EE MVE)
or something that you did and want to share, without writing an article or doing a video (think blog type stuff).

Jim.
0

I am using macro & pivot table  and I have variable dates and time as (06/03/2016 11:27) ,  now I want to filter data based on date & time ( for example yesterday 11 PM to today 7AM) .

Can someone give vba code for this.
0
LVL 38

Expert Comment

by:Rob Henson
You have created a Post here. You will get better responses from EE Experts if you raise a question. Use the big blue button at the top of the screen or this link:

https://www.experts-exchange.com/askQuestion.jsp
1
Introduction to R
LVL 13
Introduction to R

R is considered the predominant language for data scientist and statisticians. Learn how to use R for your own data science projects.

I seem to recall that it is possible to get instant help from an expert via Experts Exchange.  Is that still the case?  What I need is MSAccess VBA and SQL.
0
LVL 22

Expert Comment

by:David Atkin
1
LVL 19

Expert Comment

by:Kyle Santos
Hi Biggles1,

You are correct and the two comments above mine are where you would need to go and create a new request to get 1:1 help.  =)
0
Hi,
Every week, I need to run 7-8 reports from external software for same week period for almost 8 branches, is there any VBA codes which can help me to automate the process, where it saves all reports automatically from external software on network directory just by adjusting dates? Your help will be appreciated.
0
LVL 27

Expert Comment

by:Brian B
You have entered this as a post, but it looks like it is a question. To get the best response from the Experts, you should probably re-submit this as a question using the "ask a question" button at the top of the screen, or this link: https://www.experts-exchange.com/askQuestion.jsp

Please see here for further details: http://support.experts-exchange.com/customer/portal/articles/756544-how-to-succeed-at-ee-as-an-asker
0
LVL 27

Expert Comment

by:Brian B
0
HI I would like to make a simple excel vba to create outlook e-mail. I basically know what to do but I want to know how I can setup "sender".  I would like to set sender different address but not me. would you please help?
0
LVL 38

Expert Comment

by:Rob Henson
Hi Luke, you have created a Post rather than raise a question. For better responses from Experts, please use the big blue button at the top of the screen to raise a question.
0
how to find the hanging space in the n number of bullet text i.e. show the space in between text and bullet for each paragraph and also find the font size in the bullet text in power point all slide using VBA.  Any help me that it is very useful in my environment?
0
LVL 28

Administrative Comment

by:Andrew Leniart
Hi Satishkumar,

Welcome to Experts Exchange.

What you have done is made a "Post" here.  To get expert help, you need to "Ask a Question" so that more experts are able to see that you need help. Click the Big blue button near the top of your screen.

Ask a Question

The following link also explains more about asking for help at Experts Exchange..
http://support.experts-exchange.com/customer/portal/articles/336330

Hope that's helpful.

Regards,
Andrew
EE Topic Advisor
0
I had a need for a “colour picker” for the nice original Windows Phone colour palette. The codes are impossible to remember, so I was looking for a method to point and click to copy a value for later to be pasted into a property pane.

As I wanted all values presented in the three often used formats for CSS, VBA, and as hex values - and had the colour values as an enumeration – I also needed some converter functions. Not much, and with a simple loop all field values could be set.

However, writing code for 63 fields looked like a daunting task. This is where WithEvents came in and solved that with a few handfuls of code.

I wrote it all up here as there are so few examples found demonstrating WithEvents:

    https://www.experts-exchange.com/articles/29554/Create-Windows-Phone-Colour-Palette-and-Selector-using-WithEvents.html

with a reference to John Colby’s old tutorial on WithEvents for the interested reader. The only principal difference to John’s example is, that I didn’t use 63 variables but a collection (as I learned from Shamil Salakhetdinov) to hold the controls.

The colour palette of Windows Phone I have previously used here:

    https://www.experts-exchange.com/articles/17684/Modern-Metro-style-message-box-and-input-box-for-Microsoft-Access-2013.html

/gustav
3

Expert Comment

by:Daniella Barion
That's great. I am sure it will help a lot of people.
0
Helen Feddema is one of our resident Microsoft Access experts.  She just published two new articles today.  If Access is something you're interested in knowing more about, then follow Helen!
https://www.experts-exchange.com/members/Helen_Feddema.html
2
New member today got a solution today.

After searching the net for help it became apparent that there were professional contributors on your site willing to provide expert advice. The advice given was very fast and first class.

Fred
This was their question that was answered.
https://www.experts-exchange.com/questions/29012797/Create-Dynamic-Range-Via-VBA.html
3
4
LVL 55

Expert Comment

by:Jackie Man
You need to install software like sophos intercept x in computers inside your network to block it.
3
LVL 7

Author Comment

by:Brian Matis
Personally, I'm just avoiding opening any Word docs from anyone I don't know... And to some extent, even from people I do know... Most of my document usage these days is with Google Docs, so it's pretty rare that I need a Word doc!
1

VBA

11K

Solutions

3K

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.