Search:

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

Page 1 of 2 1 2

Search: Search took 0.01 seconds.

  1. Replies
    38
    Views
    9,140

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

    Don't forget to put the film in the camera as well!
  2. Replies
    4
    Views
    715

    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....
  3. Replies
    4
    Views
    715

    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...
  4. Replies
    10
    Views
    1,776

    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...
  5. Replies
    10
    Views
    1,776

    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...
  6. Replies
    10
    Views
    1,776

    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...
  7. Replies
    2
    Views
    430

    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.
  8. Replies
    15
    Views
    1,460

    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
  9. Replies
    2
    Views
    430

    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...
  10. Replies
    5
    Views
    4,819

    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...
  11. Replies
    5
    Views
    4,819

    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...
  12. 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...
  13. Replies
    3
    Views
    1,232

    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...
  14. Replies
    3
    Views
    1,232

    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 ...
  15. Replies
    3
    Views
    1,232

    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...
  16. Replies
    2
    Views
    381

    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...
  17. Replies
    4
    Views
    4,038

    Thanks Hans, Just what I needed. Cheers Brian.

    Thanks Hans,
    Just what I needed.
    Cheers
    Brian.
  18. Replies
    4
    Views
    4,038

    Do the filenames resemble the part numbers? ...

    Do the filenames resemble the part numbers?

    Yes they do.
    Something along the lines of Part number 11412378
    Photos might be 11412378-1.jpg; 11412378-2.jpg; 11412378-3.jpg etc...
    I would like to...
  19. Replies
    4
    Views
    4,038

    Hi All, Is there a way to "shell" out to the...

    Hi All,
    Is there a way to "shell" out to the "Windows Picture and Fax Viewer" application from within Excel VBA?
    I am using MS Office XP (2002) SP3
    I would like to be able to search for any photos...
  20. Replies
    2
    Views
    508

    Re: Form Terminate Event (Excel 2000 SP3)

    Thanks Heaps Hans,
    This worked a treat!
    Regards
    Brian.
  21. Replies
    2
    Views
    508

    Form Terminate Event (Excel 2000 SP3)

    When trying to terminate a form by using the "X" box in the upper right corner of the form I find that code relating to anything on the form is not successful.
    ie if the following code is used it...
  22. Replies
    2
    Views
    340

    Re: Opening selected Folder (Excel 2002 SP3)

    Damn that was great!
    Just what I was chasing! Only had to correct the assignment of the Path to strPath and away it went!
    Thanks so much for your prompt and accurate response Hans.
    Regards
    Brian.
  23. Replies
    2
    Views
    340

    Opening selected Folder (Excel 2002 SP3)

    Can anyone please help with the following code chunk?
    I am trying to get the "File Open" dialog box to open up in the correct folder with out the user having to navigate there way thru the server to...
  24. Replies
    8
    Views
    538

    Re: Email from within Excel (Excel 2002 SP3)

    Thanks Hans for your tip.
    Tried putting the sendkeys command before the mail code, but it still made no difference.
    However... I have managed to get everything working by using something called CDO...
  25. Replies
    8
    Views
    538

    Email from within Excel (Excel 2002 SP3)

    Hello everyone,
    I am trying to get an Excel macro to send an email automatically of a worksheet that gets data dumped into it and then saved as a tab delimited text file.
    So far I have managed to...
Results 1 to 25 of 45
Page 1 of 2 1 2