Search:

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

Page 1 of 3 1 2 3

Search: Search took 0.01 seconds.

  1. Replies
    9
    Views
    431

    Hi Zeddy, You are very generous. Both with your...

    Hi Zeddy,
    You are very generous. Both with your time and effort on this forum.
    I decided to have another crack at the VBA solution as an exercise in cruelty to myself :)
    I found that by adding in...
  2. Replies
    9
    Views
    431

    Hi Zeddy, Thanks for your help... again. I had...

    Hi Zeddy,
    Thanks for your help... again.
    I had not realised that you need to set the X axis Dates for each series.
    This is where I went wrong.
    Also, thanks for the solution to hiding the extra...
  3. Replies
    9
    Views
    431

    Hi Zeddy, Have tried applying your solution to...

    Hi Zeddy,
    Have tried applying your solution to one of the other graphs that I need to update, along the same lines as the first graph.
    The second graph I have applied this solution to updates the...
  4. Replies
    9
    Views
    431

    Hi Zeddy, Fantastic solution. Like you say,...

    Hi Zeddy,
    Fantastic solution.
    Like you say, takes out the need to use VBA.
    A solution like this never even entered my thoughts.
    Thanks so much for your assistance.
    Regards
    Brian.
  5. Replies
    9
    Views
    431

    Problem with updating Charts Excel 2013

    Hi All,
    I have a project where I am building up some graphs that represent Daily and Monthly production output values. (Lots of others as well, but let's get the first step correct eh?)
    I have...
  6. [SOLVED] Hey Zeddy, Only saw your answer after I replied...

    Hey Zeddy,
    Only saw your answer after I replied to Paul's post.
    YOU DA MAN!
    Made one slight change to the formula in that I used Count rather than CountA, as all the values are numerical.
    The...
  7. [SOLVED] Hi Paul, Thanks for the tips. tried to modify...

    Hi Paul,
    Thanks for the tips.
    tried to modify my function, but stuffed if I can get this to work for me.
    Oh, I had reselected the original sheet in the original function.
    Did not really know how...
  8. [SOLVED] Trying to capture a constantly updated value, Excel 2013

    Hi All,
    I have a column of figures that represent the value of production booked out during the day.
    I am trying to setup a simple chart that shows the value in the last row of the column (i.e....
  9. File sharing via DFS causing problems (Windows Server 2012 R2 and Win 7)

    HI All,
    I have a work environment that is starting to come online where we now have three servers spread over large distances.
    Files are replicated between all three servers to keep all servers the...
  10. Replies
    38
    Views
    12,962

    Don't forget to put the film in the camera as...

    Don't forget to put the film in the camera as well!
  11. Replies
    4
    Views
    1,344

    Thanks Zeddy and Maud, Two great solutions for...

    Thanks Zeddy and Maud,
    Two great solutions for my problem and both rather different, but both work great.
    Def have some food for thought on how I will resolve the issues involved with this project....
  12. Replies
    4
    Views
    1,344

    Coding Problem (Excel 2010 VBA)

    Hi All,
    Having a brain fart moment and can not figure out the best way of coding the following issue in VBA.
    Problem:
    A work sheet has a 'Month' laid out in a grid with each day having 8 cells...
  13. Replies
    10
    Views
    2,575

    Yes a suitable server is available to use for...

    Yes a suitable server is available to use for this project.
    I was thinking a simplistic solution would be for display items to be scanned as a jpg or tiff file from our multifunction...
  14. Replies
    10
    Views
    2,575

    Thanks people. Did not want to really go down...

    Thanks people.
    Did not want to really go down the paths suggested as each display point would involve the use of a PC or something along those lines. I would prefer to have the ability to just put a...
  15. Replies
    10
    Views
    2,575

    Digital Notice Boards

    Hi All,
    I have been asked to investigate how to setup and run a "Digital Notice Board".
    I am thinking that I should be able to have one master computer that holds the relevant files/photos that...
  16. Replies
    2
    Views
    560

    Hi Paul, Thanks for that search tip! Spot on...

    Hi Paul,
    Thanks for that search tip!
    Spot on results for what I am looking for.
    It really is all about getting the right search phrase.
    Cheers
    Brian.
  17. Replies
    15
    Views
    1,958

    Another simple solution that I have used before...

    Another simple solution that I have used before is thus:

    Sub filename()


    Range("B1") = Right(Range("A1"), Len(Range("A1")) - InStrRev(Range("A1"), "\", -1))

    End Sub
  18. Replies
    2
    Views
    560

    Remote Display, How?

    Hi All,
    I would like to setup some remote display screens at work, much like the displays at an airport showing flights and gates etc...
    Can someone please point me in the right direction as to...
  19. Replies
    5
    Views
    8,191

    Thanks for those suggestions, Have tried them and...

    Thanks for those suggestions, Have tried them and get a somewhat variable result as it really depends on the zoom factor etc as to what size your final output achieves.
    That is why I was hoping for...
  20. Replies
    5
    Views
    8,191

    Printing to JPG Format

    Hi All,
    I would like to output directly to JPG format from within Excel 2010. Firstly, is this possible?
    i.e. when printing, rather than output going to a printer or to a PDF file I would like a...
  21. I have developed a spreadsheet application that...

    I have developed a spreadsheet application that includes the use of the Microsoft Date & Time Picker control.
    All runs sweet on my development PC, but when I went to run it on another PC it came up...
  22. Replies
    3
    Views
    1,769

    Woohoo! ...

    Woohoo! http://windowssecrets.com/forums/images/smilies/biggrin.gif
    Just found the section in the help file as described by Pieterse.
    Like a hell of a lot of things in the Help system, if you...
  23. Replies
    3
    Views
    1,769

    Copied Directly from Excel 2003 VBA help: ...

    Copied Directly from Excel 2003 VBA help:

    Route Method
    See AlsoApplies ToExampleSpecificsRoutes the workbook, using the workbook's current routing slip.

    expression.Route
    expression ...
  24. Replies
    3
    Views
    1,769

    Hi everyone, I would like to be able to send a...

    Hi everyone,
    I would like to be able to send a workbook to a group of people, one after another, by using the "Routing Slip" functionality.
    I have found all the bits and pieces on how to send...
  25. Replies
    2
    Views
    453

    I have an unusuall problem that has only cropped...

    I have an unusuall problem that has only cropped up this morning.
    We are running Terminal Services with Office 2000 SP3 running on the system.
    One user has reported that they can not view or set...
Results 1 to 25 of 54
Page 1 of 3 1 2 3