Search:

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

Page 1 of 5 1 2 3 4

Search: Search took 0.01 seconds.

  1. Good Morning Maude, All Done... Have a nice...

    Good Morning Maude,

    All Done...

    Have a nice day and multi thanks.

    Best Regards,

    Wolfgang
  2. 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?...
  3. 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...
  4. 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
  5. 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...
  6. 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
  7. 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...
  8. 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...
  9. 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...
  10. Hi Maude Have a nice weekend, too. Best...

    Hi Maude

    Have a nice weekend, too.

    Best regards,

    Wolfgang
  11. 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...
  12. 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...
  13. 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...
  14. Search All Excel Files On Drive If Data Already There

    Hi All,

    I have many Excel files on my F-drive which hold international stock data.

    Some of them will be deleted and others will be added.

    I like to know if it is possible to look for a...
  15. HI, I tried your advise and it runs just fine...

    HI,

    I tried your advise and it runs just fine except for the fact that it shuts-down all Excel instances without giving me the chance of saving.

    I went thru the internet and found a macro at...
  16. Hi Maud, thank you for your answer but I do...

    Hi Maud,

    thank you for your answer but I do need those files to be opened in separate instances.

    Best,
    Wolfgang
  17. I run XP Home US-Vesion and it does not contain...

    I run XP Home US-Vesion and it does not contain "TASKKILL.EXE".

    I did a thorough search on my C: Drive and did not find it.

    Wolfgang
  18. Another question, by "Start" do you refer to the...

    Another question, by "Start" do you refer to the Start button of Windows and have me input your parameters?

    I did that and Windows tells me that "taskkill" is not found...
  19. Hi SpywareDr, thanks for your fast answer. ...

    Hi SpywareDr,

    thanks for your fast answer.

    Question: Will the contents of each workbook be save or not?

    If not do I have to make sure that everything is saved?

    Best,
    Wolfgang
  20. How To Close 5 Instances Of Excel 2007 At Once...

    Hi All,

    i have 5 workbooks open at separate instances.

    Is it possible to to close all of them at the same time by the use of a macro?

    Thank you in advance for your help,

    Wolfgang
  21. Replies
    6
    Views
    474

    Hi zeddy, no I import by Excel's Data - From...

    Hi zeddy,

    no I import by Excel's Data - From Web utility...

    Wolfgang
  22. Replies
    6
    Views
    474

    Here is the link: ...

    Here is the link:

    http://www.miningfeeds.com/strategic-minerals-mining-report-all-countries
  23. Replies
    6
    Views
    474

    Hi zeddy, thanks for your quick reply. What...

    Hi zeddy,

    thanks for your quick reply.

    What I don't understand is the fact that these formats are all imported from the net and I can't change their behavior at all as you may see in cell P6.
    ...
  24. Replies
    6
    Views
    474

    How To Process Web-Imported Values

    Hi All,

    I import a table that contains values regarding several Rare Earths companies and like to process some values like columns E and F.

    I just can't overcome their formats as shown in cell...
  25. Replies
    10
    Views
    3,933

    Hi Steve, your explanation is highly...

    Hi Steve,

    your explanation is highly appreciated!

    Have a nice Easter holiday season.

    Best,

    Wolfgang
Results 1 to 25 of 110
Page 1 of 5 1 2 3 4