Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.03 seconds.

  1. Replies
    2
    Views
    35

    Prevent user interrupting Macro ?

    Hi,
    i have a macro which depending on data size, can take up to 2 minutes to complete.

    Now ive found if whilst this is running the user gets impatient and clicks the mouse / keyboard etc.. then i...
  2. Re: ADODB Insert Query - Modify to Update instead ?

    Tom Schreiner
    @Worf

    Thankyou
    Table only contains around 1000 records currently but could soon be 20000+

    Is there any advantage to using ADODB.recordset instead of direct query like I've done...
  3. ADODB Insert Query - Modify to Update instead ?

    Hi,
    i have the following which works fine:
    but im wondering how i can modify this to UPDATE the existing record if the data2 value already exists in the table (Column2)? To prevent duplicate data....
  4. Filtering a Pivot by user input value?

    Hi,
    I have a pivot table with the left column numbers 1-100
    And I want to be able to filter between 2 numbers (from user inputboxs for min and max)

    Eg. Numbers 11-20 or 1-80

    Unsure how to do...
  5. Checking if a record exists already before using SQL INSERT ?

    Hi,
    not sure if this fits into the excel category but its what im using with ADODB



    Sub insertSQL()

    Application.ScreenUpdating = False
  6. Replies
    4
    Views
    107

    Re: Convert HHMMSS to time in VBA?

    Thankyou Rick Rothstein

    This will be faster
  7. Replies
    4
    Views
    107

    Re: Convert HHMMSS to time in VBA?

    thankyou,
    i put this together and its working



    Sub TimeConvert()

    Line = 2

    Do Until Cells(Line, 1).Value = ""
  8. Replies
    4
    Views
    107

    Convert HHMMSS to time in VBA?

    Hi,
    In a database our timevalues are stored like
    94500 = 09:45:00
    121755 = 12:17:55
    58 = 00:00:58

    What is the best way to convert these when pulling them via ODBC? Ideally in the SQL query but...
  9. Re: Outputting time correctly when using IF statements

    nevermind i figured this out

    time(8,0,0)
  10. Outputting time correctly when using IF statements

    Hi,
    i might me missing something simple here but i have the following:


    =IF($A1="Day1","08:00:00",IF($A1="Day2","09:00:00",0))

    Now this outputs as strings which makes it difficult to use in...
  11. Replies
    8
    Views
    310

    Re: New Analyst - New Problems

    You can do something like this to only write your formulas to the last row of data, rather than always 150



    Sub Pickup_Time()


    'Get the Last row of Column A
    LR =...
  12. Re: Saving a copy of just one worksheet + remove buttons

    Thanks mumps

    this works (almost perfect)

    it currently deletes all buttons, but also deletes the textbox's i have on the sheet which i want to keep
    is there any way to skip textboxe's in the...
  13. Saving a copy of just one worksheet + remove buttons

    Hi,
    I have a workbook which I use savecopyas often and with a file size of around 6MB, it's using up space fast.

    Source workbook contains many sheets/macros/formulas

    And I only need to save 1...
  14. How can I add a progress bar to a loop?

    Hi,
    I've never done anything before with progress bars.

    I have a macro which loops through a worksheet to last row and the data is used to update an external program.

    The problem is if there...
  15. Re: Error handling if VBA reference not found?

    Thanks for the reply, though it isnt a standard DLL

    The DLL when installed will always be located at the same location, so thinking I can simply check if file exists.
  16. Error handling if VBA reference not found?

    Hi,
    I have an Excel macro that requires a reference (DLL) and if the DLL isn't found I get "Compile Error, can't find project or library"

    Is there a way I can handle this error by checking if the...
  17. Replies
    7
    Views
    249

    Re: VBA Complicated Loop

    Thanks Eric W
    It's working as intended I just got a little confused
  18. Replies
    7
    Views
    249

    Re: VBA Complicated Loop

    For John,
    ID2 has 20 Points assigned

    But in the outcome he has
    ID1 - 70
    ID2 - 10
  19. Replies
    7
    Views
    249

    Re: VBA Complicated Loop Help

    Thanks Eric W
    You was right with your question it was just my input

    I tried this code on a small dataset and you see
    60 has gone to ID:1 for John
    But then another 10 has gone to ID: 1 Also...
  20. Replies
    7
    Views
    249

    VBA Complicated Loop

    Hi,
    I have 2 tables

    Table1 - Source with Total Points


    <tbody>
    ID
    Name
    Points
  21. Replies
    3
    Views
    133

    Re: Erasing Arrays after use question

    Perfect thankyou
  22. Replies
    3
    Views
    133

    Erasing Arrays after use question

    Hi,
    I have a macro that uses multiple arrays and after use I have a reset button which clears these:

    erase MyArray1 etc...

    However in some cases not all arrays are initiated so when I attempt...
  23. Re: Extracting Rows from a table based on list

    Thanks Fluff this works perfect
  24. Extracting Rows from a table based on list

    Hi,
    i am testing this currently with a large dataset (50000) rows and want to extract rows from a table based on a list of order IDs.

    My Data table is stored in sheets("Data") - Columns A:N...
  25. Replies
    9
    Views
    215

    Re: Basic Array Question VBA

    Thanks
    The goal is to store each unique IDNO, along with their name and a TOTAL of their values
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4