Search:

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

Search: Search took 0.00 seconds.

  1. Replies
    2
    Views
    309

    Locked Database (2002)

    I wonder if you can help.

    I am unable to open a database and receive the following message " The Microsoft Jet dB engine stopped the process because you and another user are attempting to change...
  2. Pivot Charts - Series in rows (Excel 2002)

    I wonder if you can help.

    My pivot chart displays the informatin in columns rather than rows. When I create a similar chart not using pivot tables I am given the option of selecting a series...
  3. Replies
    3
    Views
    2,216

    Re: Excel VBA - NetworkDays (Excel VBA)

    Thanks very much that is a big help.

    In relation to the time component, I wanted to calculate the interval between two dates and times, excluding weekends. For example:

    16-Aug-04 09:00 and...
  4. Replies
    3
    Views
    2,216

    Excel VBA - NetworkDays (Excel VBA)

    I would like to write a function to calculate the number of working days between two dates (including the time component of the date). Note that the Excel NETWORKDAYS function does not account for...
  5. Excel VBA - Pasting Cells (Microsoft Excel 2002)

    I wonder if you can help.

    I am trying to cut and paste serveral cells worth of data from one sheet to another. However the following code 'shtDest.Range("A" & intRowinc).Paste' generates the...
  6. Pivot Tables - Referring to Values in Cells (Excel VBA/ Excel 2000)

    I wonder if you can help.

    I am trying to write some VBA code to refer to the data values in specific cells in a pivot table. I know how to refer to specific pivot fields, specific pivot items...
  7. Re: Using an Object Reference Reassign a Named Range (Excel VBA/ Excel 200

    When I say that the code does not work I mean that the named range entitled 'SR_data" is not updated when the following code is run: ' NewDataSet.Name = "SR_data". The named range continues to...
  8. Re: Using an Object Reference Reassign a Named Range (Excel VBA/ Excel 200

    Hans

    I have tested the code below and it still does not work and I am getting the same problem.

    Apologies for not doing this earlier but your reply made perfect sense, because the code did...
  9. Re: Using an Object Reference Reassign a Named Range (Excel VBA/ Excel 200

    Thanks Hans

    I think you did answer my question, which is good as it was bugging me

    In your reply you also stated that is more efficient to use 'something' with range objects. I assume that...
  10. Using an Object Reference Reassign a Named Range (Excel VBA/ Excel 2000)

    I have a pivot table pointing to some data, which is in a named range. I am copying in some new data and trying to change the range accordingly so it refers to the new dataset. I cannot...
  11. Excel Pivot Tables _Refreshing using VBA (english)

    When I change the reference to the source data behind an Excel Pivot Table using VBA only the original pivot table is changed. Other pivot tables based on (or linked to) this original pivot table...
  12. Re: Excel Pivot Tables - Changing the source data (English/Excel/2000)

    Thanks for the reply.

    I thought that I had effectively used a named range (the code can be found in the original attachment) with the following code: Dim CellsData As Range and Set CellsData =...
  13. Excel Pivot Tables - Changing the source data (English/Excel/2000)

    I wonder if you can help.

    When I change the reference to the source data behind an Excel Pivot Table using VBA only the original pivot table is changed. Other pivot tables based on (or linked...
Results 1 to 13 of 13