Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.31 seconds.

  1. Replies
    4
    Views
    63

    Re: VBA Code To Copy Files From Path To Path

    Hi,
    suggest you update Ron's code to meet your specific need one part at a time

    To address point one you can change the String variables FromPath & ToPath to string arrays & then loop through...
  2. Re: Copy one whole worksheet into another whole worksheet taking too long

    Hi,
    try



    Application.Calculation = xlCalculationManual
    Sheets("Sheet1").UsedRange.Copy Sheets("Sheets2").Range("A1")
    Application.Calculation = xlCalculationAutomatic
  3. Replies
    6
    Views
    175

    Re: VBA Find and Select loop

    You have been shown how to resolve this

    My Solution kept with the Range.Find method you are using & shows how to loop through each of the search values.

    Others have provided alternative...
  4. Replies
    4
    Views
    63

    Re: VBA Code To Copy Files From Path To Path

    Hi,
    have a look at Ron de Bruins site here:https://www.rondebruin.nl/win/s3/win026.htm

    There is an example code named Copy_Files_Dates that may be close to what you want.

    Dave
  5. Replies
    6
    Views
    175

    Re: VBA Find and Select loop

    Hi,
    try this update to your code & see is does what you want



    Option Base 1
    Sub Giggs1991()
    Dim rng As Range, FoundCell As Range
    Dim CityNames As Variant, CountryNames As Variant
    ...
  6. Replies
    9
    Views
    278

    Re: Need help with Code converting xlsm to xls

    Hi,
    untested but see if this update to your code solves the issue



    Sub bomaisgrat()
    Dim Fname As String
    Application.DisplayAlerts = False
    With ActiveWorkbook...
  7. Replies
    4
    Views
    193

    Re: Several issues with userform macro

    Really sorry but I don't have time to study your project & maybe another here can but perhaps lesson should be, save the workbook as a new version each time making coding updates.

    Dave
  8. Re: Distributing specific information from one sheet onto 4 more sheets depending on values

    Hi,
    welcome to forum.

    One approach that you may be able to take is to use AdvancedFilter Copy. This would simply copy the required data from your master sheets to the sub-set sheets you create.
    ...
  9. Replies
    4
    Views
    193

    Re: Several issues with userform macro

    Hi welcome to forum.

    If your form was working ok until you made changes then can you not just revert back to an earlier version?


    Dave
  10. Replies
    9
    Views
    216

    Re: run time error 1004

    Dante

    In my post I clearly stated



    code works fine for me with a Form Control Button - I just amended posted code for the OP to try.

    It maybe for you that your system may need to use the...
  11. Replies
    9
    Views
    216

    Re: run time error 1004

    In your code your are referring to an Excel Form Control OptionButton when from what you describe, you really mean Buttons which would explain the error.

    try this update



    Worksheets("4_Lift...
  12. Re: Inputbox to select the range from user to apply a specific function.

    welcome - thanks for feedback

    Dave
  13. Re: Inputbox to select the range from user to apply a specific function.

    Hi,
    untested but try




    Sub CleanAll()
    Dim rng As Range, cell As Range

    On Error Resume Next
  14. Replies
    2
    Views
    44

    Re: Opening a Workbook from a File Dialog Box

    Hi,
    looking at your code, I suspect your variable strFile excludes the folder path & just contains the file name

    try replacing this line



    strFile = Dir(.SelectedItems(i))
  15. Replies
    4
    Views
    78

    Re: formatting name in new worskeet VBA

    Hi,

    Use the Range.Text property to return what you see in the cell & not its underlying value

    change this line



    wh.Name = ws.Range("E9").Value
  16. Re: Can you check & advise on my userform code please

    You said in your first post that you were only selecting a year which gave the impression of a single numeric value in your combobox.


    change this line



    wsSummary.Cells(2, 1).Value =...
  17. Re: Can you check & advise on my userform code please

    Hi,
    looking at your code I am guessing that you have adapted it from another procedure as you have an array for controls with just one control?

    If all you have on your form is just combobox to...
  18. Re: Saving updated data record on current line vs saving new record

    Hi,
    code you have just posted is a very early version of your project which has modified by another here.

    I spent a period of time bringing your project up to a working standard but as is your...
  19. Replies
    33
    Views
    1,613

    Re: help with a simple VBA code for excel form

    There is your answer


    You entered



    FolderName = "P:\Penrose work\KPI Data\Dashboard Data and reports"
  20. Re: Saving updated data record on current line vs saving new record

    Copy you provided at time only had a Next Button & I updated code accordingly - but you since started another thread where you have been getting good help with a solution although similar in parts,...
  21. Re: Saving updated data record on current line vs saving new record

    Did you try my updated version with next Button?

    Dave
  22. Replies
    33
    Views
    1,613

    Re: help with a simple VBA code for excel form

    That suggests that you have not entered the FolderName correctly.

    Open a blank workbook & turn macro recorder on and then Open the file on your network

    Once open, turn macro recorder off & then...
  23. Re: Saving updated data record on current line vs saving new record

    Hi,
    If you use the search facility and a record is returned - you have an existing record & Update button is enabled and Add Record disabled. This action is designed to prevent duplicates.

    To Add...
  24. Replies
    33
    Views
    1,613

    Re: help with a simple VBA code for excel form

    hi, should work OK

    have you updated FolderName variable correctly?



    FolderName = "C:\Users\phillip87\Documents\KPI Data"
  25. Replies
    33
    Views
    1,613

    Re: help with a simple VBA code for excel form

    untested but try this update




    Private Sub CommandButton1_Click()
    Dim wsKPI As Worksheet
    Dim wbKPI As Workbook
    Dim FolderName As String, wbName As String
    Dim wsName As...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4