# Search:

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

Page 1 of 3 1

1. ## Thread: Firefox feature new to me

by BRoby
Replies
28
Views
5,656

### Surprise surprise, this works in Chrome also......

Surprise surprise, this works in Chrome also... :)
Been using this functionality for ages.
2. ## Thread: Trying to work out a formula to sum 7 days of data

by BRoby
Replies
3
Views
247

### hi RG, Awesome! Thanks for your solution. Works...

hi RG,
Works a treat.
Took a bit of reading in the help file to totally understand your solution, but all good now.
Cheers
Brian.
3. ## Thread: Trying to work out a formula to sum 7 days of data

by BRoby
Replies
3
Views
247

### Trying to work out a formula to sum 7 days of data

Hi All,
I have a series of data that is tacking hours per day spent on various tasks.
This data then needs to be summerised to a weekly format.
Yes a simple SUM formula would normally be the...
4. ## Thread: Problem with updating Charts Excel 2013

by BRoby
Replies
9
Views
584

### 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...
5. ## Thread: Problem with updating Charts Excel 2013

by BRoby
Replies
9
Views
584

Hi Zeddy,
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...
6. ## Thread: Problem with updating Charts Excel 2013

by BRoby
Replies
9
Views
584

### 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...
7. ## Thread: Problem with updating Charts Excel 2013

by BRoby
Replies
9
Views
584

### 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.
8. ## Thread: Problem with updating Charts Excel 2013

by BRoby
Replies
9
Views
584

### 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...
9. ## Thread: Trying to capture a constantly updated value, Excel 2013

by BRoby
Replies
4
Views
200

Hey Zeddy,
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...
10. ## Thread: Trying to capture a constantly updated value, Excel 2013

by BRoby
Replies
4
Views
200

### [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...
11. ## Thread: Trying to capture a constantly updated value, Excel 2013

by BRoby
Replies
4
Views
200

### [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....
12. ## Thread: File sharing via DFS causing problems (Windows Server 2012 R2 and Win 7)

by BRoby
Replies
1
Views
1,156

### 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...
13. ## Thread: The value of a recent drive image

by BRoby
Replies
38
Views
13,481

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

Don't forget to put the film in the camera as well!
14. ## Thread: Coding Problem (Excel 2010 VBA)

by BRoby
Replies
4
Views
1,426

### 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....
15. ## Thread: Coding Problem (Excel 2010 VBA)

by BRoby
Replies
4
Views
1,426

### 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...
16. ## Thread: Digital Notice Boards

by BRoby
Replies
10
Views
2,647

### 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...
17. ## Thread: Digital Notice Boards

by BRoby
Replies
10
Views
2,647

### 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...
18. ## Thread: Digital Notice Boards

by BRoby
Replies
10
Views
2,647

### 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...
19. ## Thread: Remote Display, How?

by BRoby
Replies
2
Views
571

### 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.
20. ## Thread: Formula help: is =Right right?

by BRoby
Replies
15
Views
2,031

### 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
21. ## Thread: Remote Display, How?

by BRoby
Replies
2
Views
571

### 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...
22. ## Thread: Printing to JPG Format

by BRoby
Replies
5
Views
8,582

### 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...
23. ## Thread: Printing to JPG Format

by BRoby
Replies
5
Views
8,582

### 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...
24. ## Thread: Automatically checking for and Registering OCX Control

by BRoby
Replies
1
Views
1,238

### 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...
25. ## Thread: Can I add a Routing Slip from within VBA

by BRoby
Replies
3
Views
1,815

### 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...
Results 1 to 25 of 57
Page 1 of 3 1