Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.03 seconds.

  1. This code for saving worksheet is very slow

    Hi,
    This code I have to add new workbook > copy data from active sheet to Sheet1 of new workbook then save runs slow.



    Private Sub SaveSheet()
    Dim WB1 As Workbook, WB2 As Workbook
    Dim WS1 As...
  2. An easier way than this to SQL update ?

    Hi,
    i have the following which works

    but is there an easier way if the worksheet data matches the table? ie same no of columns
    as with 20+ columns to update it gets tedious typing it all out.
    ...
  3. Replies
    2
    Views
    87

    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...
  4. 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...
  5. 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....
  6. 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...
  7. 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
  8. Replies
    4
    Views
    140

    Re: Convert HHMMSS to time in VBA?

    Thankyou Rick Rothstein

    This will be faster
  9. Replies
    4
    Views
    140

    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 = ""
  10. Replies
    4
    Views
    140

    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...
  11. Re: Outputting time correctly when using IF statements

    nevermind i figured this out

    time(8,0,0)
  12. 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...
  13. Replies
    8
    Views
    343

    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 =...
  14. 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...
  15. 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...
  16. 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...
  17. 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.
  18. 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...
  19. Replies
    7
    Views
    258

    Re: VBA Complicated Loop

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

    Re: VBA Complicated Loop

    For John,
    ID2 has 20 Points assigned

    But in the outcome he has
    ID1 - 70
    ID2 - 10
  21. Replies
    7
    Views
    258

    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...
  22. Replies
    7
    Views
    258

    VBA Complicated Loop

    Hi,
    I have 2 tables

    Table1 - Source with Total Points


    <tbody>
    ID
    Name
    Points
  23. Replies
    3
    Views
    142

    Re: Erasing Arrays after use question

    Perfect thankyou
  24. Replies
    3
    Views
    142

    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...
  25. Re: Extracting Rows from a table based on list

    Thanks Fluff this works perfect
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4