Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by SurfdudeNL

  1. SurfdudeNL

    Set focus on Excel

    Thanx, that did it (stupid me tried appactivate "excel")
  2. SurfdudeNL

    Set focus on Excel

    Doesn't work either, focus stays on Outlook.
  3. SurfdudeNL

    Set focus on Excel

    Worksheets("name").visible = true doesn' t do it. What do you mean by last actiev (code?)
  4. SurfdudeNL

    Set focus on Excel

    Hi, I have made/customized a routine that imports mailheaders into an excel table from an Outlook folder. (For code see: http://www.dicks-clicks.com/excel/olRetrieving.htm). After running the focus is on Outlook. How do I programatically set the focus back on Excel? .select or .activate doesn't...
  5. SurfdudeNL

    Import and transpose multiple txt files

    Thanks PHV that did it!
  6. SurfdudeNL

    Import and transpose multiple txt files

    It's in A module...
  7. SurfdudeNL

    Import and transpose multiple txt files

    I still get the ActiveX error 429...
  8. SurfdudeNL

    Import and transpose multiple txt files

    Yep, I first get a sub of function error on ParsePath.
  9. SurfdudeNL

    Import and transpose multiple txt files

    Vis Basic For apps Ms Excel 11.0 Object lib OLE autom Thats all
  10. SurfdudeNL

    Import and transpose multiple txt files

    Thanks, but I get an ActiveX-... can't make object error on the CreateObject command. What's wrong?
  11. SurfdudeNL

    Import and transpose multiple txt files

    Ah no, In the past I accidentally signed up as a programmer, I am certainly not one. The proof: I don't even know how to change this into something more appropriate ;-) Arnie
  12. SurfdudeNL

    Import and transpose multiple txt files

    Thanks Skip, I'm not that familiar with array's can you help me with some code?
  13. SurfdudeNL

    Import and transpose multiple txt files

    Hi, I have multiple .txt files, each containing 3 lines of variable lengts. I want to import them into Excel and make every line a database record (transpose?). .txt file example: John Pete Sampras Ike Turner Excel should look like this: John Pete Sampras Ike Turner etc. Any suggestions?
See more

Part and Inventory Search

Back
Top