Search:

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

Page 1 of 7 1 2 3 4

Search: Search took 0.01 seconds.

  1. MS Project: Rolled up tasks and timelines

    Hi all,

    a colleague of mine is trying to understand if it is possible in MS Project to create a timeline view where it is possible to view each summary task in its own timeline with the...
  2. Replies
    3
    Views
    448

    Nope, that can't be the problem. The first...

    Nope, that can't be the problem.

    The first line of the following fails saying that the object doesnt support the method. so Piece is always nothing. OUtputContent is full of all the stuff I need...
  3. Replies
    3
    Views
    448

    Need help with simple macro

    hi all, I have the following code which isnt working because the "piece" range in the collection fails on the Piece.copy method. I cant think of what I am doing wrong. Help appreciated!!

    cheers,...
  4. ok I'm beginning to think it has something to do...

    ok I'm beginning to think it has something to do with the file associations with installed applications. So if an installed application is associated to a file type, then the file information...
  5. FileSystemObject and File.Type property Text Document problem

    Hi all,

    I've written a macro which uses the FileSystemObject and the File Object. Specifically I am checking the File.Type property to see if the file is a text document. According to...
  6. VBA Dialog Boxes - System Fonts different than other peoples?

    Hi,

    I just noticed the other day that the dialog boxes (forms) i created in VBA to support loads of my macros seem to now have a different (larger) font, so that none of the text fits in the...
  7. I think I just answered my own question: You...

    I think I just answered my own question: You right click on the custom toolbar on the Add-Ins ribbon and you select "Delete" and then you are warned that it is irreversible. But that's a good thing :)
  8. Removing legacy add-in toolbars from Word 2010 templates

    Hi,

    Recently I converted some Word 2003 templates containing macros and toolbars into Word 2010 .dotm files. I added a nice new ribbon for the macros and everything works fine.
    The only problem...
  9. Hi guys, thanks for the answers. Macropod:...

    Hi guys,
    thanks for the answers.

    Macropod: There is no more code to show, except perhaps a line at the start to set the Selection to the beginning of the document or region to be searched. If you...
  10. VBA to search for highlighted text - problem with Tables

    Hi.. I've been struggling with this problem for a while. I have the following simple code to search for highlighted text in a document and to report each instance to a user:



    With...
  11. OK, thanks.. I've sorted it now using the hidden...

    OK, thanks.. I've sorted it now using the hidden sheet, which is dynamically modified in exactly the same way as the data entry sheet so when the user selects different start and end dates for the...
  12. hi there, thanks for your suggestions! Yeah, I...

    hi there,
    thanks for your suggestions! Yeah, I know I was trying to do a lot in one place, but it was to try to avoid having hidden sheets - and besides I was just trying to be clever :) But yes, I...
  13. Hmm this doesn't work either... I need help :(

    Hmm this doesn't work either... I need help :(
  14. as if by some miracle, I stumbled across the...

    as if by some miracle, I stumbled across the following formula, which doesn't used named ranges (yet) but substituting fixed ranges for named ranges should be quite straight forward!
    ...
  15. Excel 2010 - Complicated Formula - help needed urgently!

    Hi All,

    I've attached a small spreadsheet with which I need urgent help. I have a workbook with 2 sheets

    Rates Sheet

    The Rates Sheet contains a set of hourly rates for a series of different...
  16. MS Access 2010: Adding Attachments from Form using Unbound Field and VBA

    Hi All,

    I have a form in which the user inputs data and then some VBA processes and checks this data before putting into a table. The Form fields are not directly bound to the table.

    I want to...
  17. Yes, I realise that this will get rid of that...

    Yes, I realise that this will get rid of that folder grouping.. however, all of my other libraries are also "Arranged by Folder", yet they do not show this folder grouping, even if there is more than...
  18. Create new library - contents grouped by folder

    Hi All,

    new to Win 7, so apologies for the simple question!

    I created a new library called "Downloads". I added the "My Downloads" folder to this library and I can see the files within the...
  19. oh don't worry about it - I'm being a divvy :) I...

    oh don't worry about it - I'm being a divvy :) I sorted it by just running a query to select those records with a type linked to the type in the other table.

    Silly me - it's been a decade since I...
  20. MS Access - filter out records from a dataset based on values in a table

    Hi,

    I seem to have got myself into a bit of a pickle. I have a table "tblDocs" containing a list of document reference numbers and document types.

    Using VBA, I need to get the recordset from...
  21. VBA Text / Number format conversion when opening HTML file in Excel

    Hi,

    I've been battling with a problem for a while now and need some help..

    Our company has a VB .NET web-based tool over which I have no control or visibility of the code. It does provide an...
  22. Replies
    3
    Views
    681

    This now works ok, but it is incredibly slow....

    This now works ok, but it is incredibly slow. Doing these date conversions for one single row (i.e. two date fields) takes about 4 seconds.

    Do you know if there's any quicker way to achieve the...
  23. Replies
    3
    Views
    681

    ahh it's just the little things... thanks.. Dom...

    ahh it's just the little things...
    thanks..
    Dom

    p..s I'd tried changing the format of the column manually after the macros had run, but this of course had not effect because text is text..
  24. Replies
    3
    Views
    681

    Dates, Conversion and Sorting

    Hi all,

    Attached is a cut-down version of a spreadsheet I've made, with some macros. I'm not pretending the macros are the most efficient in the world, but please ignore that! I need some help...
  25. Yes it is an option, but not an ideal one - the...

    Yes it is an option, but not an ideal one - the ribbon generally has few "text only" controls. The main problem is that you just can't use customised icons for built-in controls, so if the control...
Results 1 to 25 of 172
Page 1 of 7 1 2 3 4