Search:

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

Page 1 of 9 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    1
    Views
    107

    Excel 2010 VBA to PowerPoint

    Hi

    I am trying to create a powerpoint slide pack from Excel 2010 VBA.

    I have looked all the various suggestions and tried a number of different bits of code but I always "User Defined type not...
  2. Many thanks

    Many thanks
  3. Hi Maud, Thanks for your help I have now...

    Hi Maud,

    Thanks for your help I have now cracked it and the macro works well and all parameterised.

    In the end I worked using the Xformula option instead of the Xvalues.

    Regards


    Mike
  4. Hi Maud, Couple of questions please. 1) Can...

    Hi Maud,

    Couple of questions please.

    1) Can I pick out if a chart number is not being used, the reason for the question is that if I (or anybody else) adds charts to that tab they may not know...
  5. Hey Maud That is fantastic, will play with...

    Hey Maud

    That is fantastic, will play with this.

    Many thanks

    Mike
  6. Hi Thanks for this and sorry for not...

    Hi

    Thanks for this and sorry for not responding earlier, this look really great but I have an added dimension which not sure how to apply you code to.

    Attached is a cut down example of what I...
  7. Dynamically move charts on over time as the data changes

    Hi

    I am using Excel 2010 and I wondered if there was any way to move chart lines dynamically over time.

    So, I have data in a row by date, I then draw a line chart based on that data and to...
  8. Replies
    7
    Views
    1,355

    Thanks Rui I am investigating your suggestion,...

    Thanks Rui

    I am investigating your suggestion, many thanks.

    Will post something when I get it working.

    Mike
  9. Replies
    7
    Views
    1,355

    Hi Joe I was just using mordi (I think). I...

    Hi Joe

    I was just using mordi (I think).

    I have been told to use Chromium which I understand will allow me to log on, this I will try, but I want to be able to move files from a raspberry pi...
  10. Replies
    7
    Views
    1,355

    Hi Jean Not prossible, will not let me log on,...

    Hi Jean

    Not prossible, will not let me log on, can see the screen but after you enter the User ID and password it seems to ignore the entry. What I am trying to do is connect to the OneDrive in...
  11. Replies
    7
    Views
    1,355

    Connecting to MS OneDrive with Raspberry Pi

    Hi

    Has anybody managed to connect to an MS Onedrive with a Raspberry Pi

    Thanks


    Mike
  12. MS Project Macro using LinkPredecessors ActiveProject.Tasks

    Hi,

    I have an MS project Macro which unlink and links predecessors and I get the error 1004 on some project plans but not others, I have compared everything I can think between the plans and all...
  13. Replies
    2
    Views
    5,651

    Hey, Many thanks for this information it what...

    Hey,

    Many thanks for this information it what I feared.

    I have done some work with resource allocation and leveling in the past and found it to be unpredictable but I thought that I had missed...
  14. Replies
    2
    Views
    467

    Thanks Martin

    Thanks Martin
  15. Replies
    2
    Views
    5,651

    MS Project 2007 and 2010: resource tracking

    Hi,

    I am trying to set up a project using resource tracking, typically I setup project using Duration and normally do not worry about resource levelling, but now I need to.

    Basically I want to...
  16. Replies
    2
    Views
    467

    MS Excel 2010 { } function

    Hi,

    What is the function that puts { } around the function e.g. {=sum(if(A1:b10="Y:,AA1:AB10,0))}

    Thanks

    Mike
  17. Hi TD, I checked that first off and they are...

    Hi TD,

    I checked that first off and they are all selected.

    Thanks

    Mike
  18. Macro connecting MS Excel and MSProject not working

    Hi

    I have a macro which is in MSExcel and opens MS Project, reading a project plan. This worked using earlier version of Excel and MSproject.

    I am now using Excel 2007 and MSProject 2007.
    ...
  19. Replies
    12
    Views
    12,017

    Hey Rory, Thanks, I misunderstood your...

    Hey Rory,

    Thanks, I misunderstood your previous comment, I did not use "Sum of Days", sorry about that, but it work great now thanks

    Regards

    Mike
  20. Replies
    12
    Views
    12,017

    Hi Rory, I did, but whatever I set the range...

    Hi Rory,

    I did, but whatever I set the range for the conditional formating to it worked fine, as soon as I refreshed the data the formating disappeared.

    Regards

    Mike
  21. Replies
    12
    Views
    12,017

    Hi Rory, Sorry for the delay, my email...

    Hi Rory,

    Sorry for the delay, my email address is mike.towns@xerox.com

    Regards

    Mike
  22. Replies
    12
    Views
    12,017

    Hi Rory, Stripped down version, look at the...

    Hi Rory,

    Stripped down version, look at the Holiday tab, there are conditional formats, I set the format to any range so the colour kick in, as soon as I do a refresh the conditional format range...
  23. Replies
    12
    Views
    12,017

    Hi Rory, The problem is that I cannot...

    Hi Rory,

    The problem is that I cannot reproduce the first issue if I create a new spreadsheet, the file I have the issue with is 30 meg and contains some sensitive data, I will see if I can strip...
  24. Replies
    12
    Views
    12,017

    Hi Rory Yes it does. Another thing I have...

    Hi Rory

    Yes it does.

    Another thing I have noticed is if I change anything in the pivot it effects other pivots on other tabs, eg, if I group dates into Months and Years all the other tabs...
  25. Replies
    12
    Views
    12,017

    Conditional Formats in Pivot Tables - Excel 2007

    Hi

    I have a pivot table and if I put a conditional format over that table it works fine, as soon as I referesh the table the conditional format range changes and stops working.

    This pivot is...
Results 1 to 25 of 224
Page 1 of 9 1 2 3 4