Search:

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

Page 1 of 5 1 2 3 4

Search: Search took 0.01 seconds.

  1. Hi Maude, I really appreciate your kind offer...

    Hi Maude,

    I really appreciate your kind offer but the E-mail data are just for info to summarize the daily actions.

    Friendly regards,

    Wolfgang
  2. Hi Maude, both solutions are just fine and I...

    Hi Maude,

    both solutions are just fine and I thank you very much for your kind help.

    The data in my sample are the actual data but their order differ every minute.

    At the end of each day I...
  3. How To Separate Text And Numbers From A String

    Hi All,

    lately I get Stock-Data from various sources by E-mail in the following format:
    GRAPHITE ONE RESOURCES0,051+6,25 % - MOLYCORP0,365+18,89 % - GRAPHENE NANOCHEM0,472+0,64 % and so on.
    ...
  4. Hi Maude, everything works just fine... ...

    Hi Maude,

    everything works just fine...

    Best,
    Wolfgang
  5. Hi Maude, great stuff, thank you very much for...

    Hi Maude,

    great stuff, thank you very much for your time and help!

    Have a nice week.

    Best,
    Wolfgang
  6. Hi Maude, you spend your time even on a Sunday...

    Hi Maude,

    you spend your time even on a Sunday with Excel and funny requests.

    I generated a stripped-down version of my workbook and incorporated your code.

    When I do a REFRESH ALL I get an...
  7. You are right, I suggest a Schneider Weisse...

    You are right,

    I suggest a Schneider Weisse Dunkel...

    Can not be beaten...

    Wolfgang
  8. Hi Maude, thank you for your fast response! ...

    Hi Maude,

    thank you for your fast response!

    Yes, please use the copy because the workbook has grown over time and requires some passwords to get into the Internet tables.

    The layouts...
  9. Track Real Time Changes In The Stock Market Additional Help Requested

    Hi Maude,

    I direct my question to you since you provided me with a really great solution!

    Is it possible to extend it to another sheet (SUMMARY) within the same workbook.

    So far only one...
  10. Thank You And Have A Peaceful X-Mas and A Peaceful 2015 As Well...

    This Goes Out To All Of You Very Knowledgeable People Who Had The Nerve To Listen And Help A Financial Analyst With His Weird Problems!!!

    I Thank You Very Much And I Wish All Of You The Very...
  11. Hi Maude, read it, applied it, thanked it... ...

    Hi Maude,

    read it, applied it, thanked it...

    Have a great weekend...

    Best
    Wolfgang
  12. Arrange Web Imported Data Horizontally Excel 2007

    Hi All,

    I like to have some code or formula that arranges my imported data into horizontal order as shown in my attached workbook, please.

    It starts at A23 to A25 on sheet WEB and should be...
  13. Good Morning Maude, All Done... Have a nice...

    Good Morning Maude,

    All Done...

    Have a nice day and multi thanks.

    Best Regards,

    Wolfgang
  14. Good Morning Maude, you made my day!!! It...

    Good Morning Maude,

    you made my day!!!

    It works just fine...

    Just one more thing: Is it possible to define the Sheet-range as B2:B22 - D2:D22 - F2:F22 - H2:H22 - J2:J22 - M2:M22 and W2:W22?...
  15. Good Morning Maude, sorry for the late reply...

    Good Morning Maude,

    sorry for the late reply but I was away for the weekend.

    I implemented your change and the error message is gone.

    The code works when the cell contents is changed...
  16. Good Morning Maude, thank you very much for...

    Good Morning Maude,

    thank you very much for your reply!

    When I run your code it barks at the line "Public oldval" and tells me "Invalid Attribute In Sub Or Function".

    Wolfgang
  17. Track Real Time Changes In The Stock Market

    Dear All,

    "With Microsoft Excel and Internet access you can track real time changes in the stock market" we were told on a recent seminar for Financial Analysts.

    The result of this daring...
  18. Hi Bill, easiest way to do this: Copy...

    Hi Bill,

    easiest way to do this:

    Copy Excel.exe to Desktop

    Double click for every workbook that you want to open separately

    Open the workbook via Open Menu
  19. Hi Steve, I finally found the root-cause to my...

    Hi Steve,

    I finally found the root-cause to my problem.

    It is not related to Office 2007 but to the way that my new hardware handles screen resulations.

    If I work in High Resulation Mode all...
  20. Hi Steve, thanks for your quick reply. ...

    Hi Steve,

    thanks for your quick reply.

    Everything ran fine with 2007 and the formulas with the icons were given as an answer by you some months ago.

    Could it be an issue with the color...
  21. Conditional Formats Office 2007 And Windows-8

    Hi All,

    I am using Windows-8 now with Office 2007 installed.

    After importing the attached file everything works fine except the Conditional Formats although all criteria are accepted.

    That...
  22. Hi Maude Have a nice weekend, too. Best...

    Hi Maude

    Have a nice weekend, too.

    Best regards,

    Wolfgang
  23. Steve, explorer does find all files that...

    Steve,

    explorer does find all files that contain "focus" in the file name and some that contain "focus" somewhere in the file.

    I looked at Maudibe's solution and it finds all occurrences of...
  24. Steve, I tried your suggestion and explorer...

    Steve,

    I tried your suggestion and explorer found some occurrences but not all of them, strange.

    Basically, the code should exactly do what I just did using explorer: look thru all Excel binary...
  25. Hi Steve, thank you very much for your fast...

    Hi Steve,

    thank you very much for your fast reply.

    I don't know if Windows explorer can search thru binary files, I will try this.

    All of my Stock-files are .xlsb files.

    Let me check out...
Results 1 to 25 of 122
Page 1 of 5 1 2 3 4