[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x

VBA

10K

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

I am looking for a file browser VBA code for Excel Office 19 I had the standard code and tried to convert it to Excel office 2019 any help would be gratefully received

Declare PtrSafe Function SHGetPathFromIDList Lib "shell32.dll" _
    Alias "SHGetPathFromIDListA" (ByVal pidl As Long, ByVal pszPath As String) As Long

Declare PtrSafe Function SHBrowseForFolder Lib "shell32.dll" _
    Alias "SHBrowseForFolderA" (lpBrowseInfo As BROWSEINFO) As Long

thanks

John
0
LVL 23

Administrative Comment

by:Andrew Leniart
Hi kuasa99,

Welcome to Experts Exchange. What you done here is make a Post, which is just a way of sharing information with the EE community.

To get expert help on your issue, please use the blue Ask a Question button at the top of your browser while logged in to EE.

I hope that's helpful.

Regards, Andrew
EE Topic Advisor
0
Rowby Goren Makes an Impact on Screen and Online
LVL 12
Rowby Goren Makes an Impact on Screen and Online

Learn about longtime user Rowby Goren and his great contributions to the site. We explore his method for posing questions that are likely to yield a solution, and take a look at how his career transformed from a Hollywood writer to a website entrepreneur.

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 60

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
I want the easiest way to link a desktop access file to mysql in the web cpanel
any aides please?
0
LVL 23

Administrative Comment

by:Andrew Leniart
Hi Azad, welcome to Experts Exchange.

What you done here is made a "Post" which is just a means to share information with the rest of the EE community.

To get expert help with your problem, please use the big blue Ask a Question button at the top of your browser when you are logged in to Experts Exchange.

Hope that's helpful.

Regards,

Andrew Leniart
EE Topic Advisor
0

Expert Comment

by:Ancy Hollo
This site http://www.vanskeys.com/office-2016-c-185.html can help you solve your problem, it offers all versions of office product keys and the keys are very cheap, you can go to have a look.
0
Hello
I have a macro that prints via a drop-down list.
I want it to save in PDF on this path D: Mareno and not in .PrintOut
thanks in advance.
macro
Sub Impression()
Dim Liste As String, C As Range
With Sheets("Buisness Support")
Liste = .Range("C7").Validation.Formula1
Liste = Right(Liste, Len(Liste) - 1)
For Each C In Range(Liste)
.[C7] = C.Value
.PrintOut
Next C
End With
End Sub
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
JavaScript Best Practices
LVL 12
JavaScript Best Practices

Save hours in development time and avoid common mistakes by learning the best practices to use for JavaScript.

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 60

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 60

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 37

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
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 37

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 23

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 53

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

10K

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.