Search:

Type: Posts; User: vds1; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.05 seconds.

  1. SQL query works in MS Access but doesnt when called from excel VBA

    Hi Gurus -

    Thank you for looking into my problem.

    Below query works when i execute in MS Access. Its a standard query which i plan to call in Excel using ADO.


    select * from...
  2. Replies
    1
    Views
    1,371

    Where is Andrew Poulsom - MrExcel MVP ?

    Hello Folks,

    Andrew Poulsom - MrExcel MVP last activity shows May 21st, 2017. He was my guru in Excel with Total post of 73,092.

    I was wondering if anyone knows about his well being.
    ...
  3. How to set password to multiple pdf files on a given folder using excel VBA?

    There are multiple pdf files in a folder. Please help me with VBA code which will loop through all the PDF file and save with a password.
    I have Acrobat distiller installed in my system.
  4. Replies
    9
    Views
    322

    Re: Find whole number in string

    Any thoughts on why wouldnt MATCH formula wont work?

    For example,


    =MATCH(2213,A1:A10,0)
  5. Re: adding text to two different cells and highlighting row

    Please post some example table in column S,D,E with expected result.
  6. Replies
    4
    Views
    224

    Re: Paste excel doc to many folders

    You can call that procedure and run for different folder.. like this
  7. Re: How to automate searching certain values and moving them to another sheet?

    First format the sheet1 data as Table. You can then Create pivot table for sheet1 Table in every new sheet and filter by specific color name. This way you can refresh the data everytime new data set...
  8. Replies
    4
    Views
    224

    Re: Paste excel doc to many folders

    This can be achieved using VBA. Try FileCopy function.

    https://www.rondebruin.nl/win/s3/win026.htm
  9. Replies
    3
    Views
    240

    Re: Set of amounts that sums to zero

    Hello

    I am trying to find code for my above issue. Can anyone please explain how to use this code posted here?

    https://www.mrexcel.com/challenges/accounts-receivable-challenge/
  10. Replies
    3
    Views
    240

    Re: Set of amounts that sums to zero

    Oh boy that requires some understanding to do.. Thanks Gerald
  11. Replies
    3
    Views
    240

    Set of amounts that sums to zero

    <tbody>
    ID_SPAR
    ID_ITOR
    AMOUNT
    DESIRED OUTPUT


    3221876
    4448945
    -51471.74
  12. Re: VBA Code to Make Separate PDF for each Worksheet in the File

    Try,



    Sub Splitbook_pdf()
    Dim xPath As String
    Dim xWs As Worksheet
    xPath = Application.ActiveWorkbook.Path & "\"
    Application.ScreenUpdating = False
    ...
  13. Replies
    3
    Views
    174

    Re: get all text value from sheet

    What is your motive behind concatenating large set of cells assigning into one variable ?
  14. Replies
    4
    Views
    218

    Re: IF statement is not working

    Excel formula in D2,


    =IF(A2="",IF(B2="",IF(C2="","Can't Determine",C2),B2),A2)
  15. Replies
    4
    Views
    251

    Re: Hide Rows on All Sheets Based on Value

    Try the below code,




    Sub Hide_Zero_Rows()
    Dim Rng As Range
    Dim Sht As Worksheet
    For Each Sht In ThisWorkbook.Sheets
    Sht.Range("A5:A100").EntireRow.Hidden = False
  16. Re: excel vba about sum up number of multiple words

    If the first column is A and Result in Column B then try the below code :


    Sub countBlueRed()
    Dim i As Long
    Dim j As Long
    Dim Counter As Long
    Dim...
  17. Replies
    3
    Views
    195

    Re: VBA Return Last Text from a String

    Assuming the value is in cell A1 then you may try this below VBA code in immediate window:




    split([A1],"_")(len([A1])-len(replace([A1],"_","")))



    or
  18. Replies
    11
    Views
    547

    Re: Max and VLookUp together? Or is there another way?

    If risk name is in column B and # analysis in column C then try the below formula,


    =MAX(IF($B$2:$B$6=B2,$C$2:$C$6))

    This should be confirmed by ctrl+shift+enter (Not just enter) since its...
  19. Replies
    3
    Views
    220

    Re: How do I get rid of the #N/A?

    Try,


    =IF(E2<>"",IFERROR(INDEX(TRAVEL!$B:$H,MATCH(E2,TRAVEL!$F:$F,0),4),""),"")
  20. Replies
    4
    Views
    760

    Re: Remove hyperlink from pictures

    Select the picture and press "Ctrl + A". This will select all shapes. Keep the selection and go to VB Screen and then go to immediate window (Ctrl +G). Paste the below code and press enter


    <code...
  21. Thread: VB: Add Zero

    by vds1
    Replies
    7
    Views
    323

    Re: VB: Add Zero

    Number format will be used to display the number on excel cell. If you still want to show "0" on function/Formula bar then your code will work. If you are then doing calculations using column "c" you...
  22. Thread: VB: Add Zero

    by vds1
    Replies
    7
    Views
    323

    Re: VB: Add Zero

    Hello,

    Will this work for you?




    Sub Add_Zeros()
    Range("C16", Range("C" & Rows.Count).End(xlUp)).NumberFormat = "00000"
  23. Replies
    13
    Views
    708

    Re: Sheet suddently slow

    I would suggest you to copy and paste the code to the new workbook. Dont copy sheets, instead create one and verify your results.
  24. Replies
    21
    Views
    672

    Re: Clear contents of cells

    Can you post your code using code tags ?
  25. Replies
    13
    Views
    708

    Re: Sheet suddently slow

    Hello,

    Does your workbook consist of conditional formatting ?
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4