Search:

Type: Posts; User: Ed_from_AZ

Search: Search took 0.02 seconds.

  1. Re: Losing USB keyboard, mouse while program is running

    Yes!! **That** was the setting I was searching for!!

    Okay - I can try this again tomorrow night and see what happens. If they still drop out, might be time for a new computer.

    I can believe I...
  2. Losing USB keyboard, mouse while program is running

    i have a VB6 Learning Edition program running on XP Pro SP3. The program is fairly simple: it opens and reads six tables in a Word document to populate several combo box drop-down controls, then...
  3. Replies
    6
    Views
    1,567

    Re: Call VB6 exe from Excel macro?

    It might take me a few days to get this pounded out (it's a spare-time project, and some days there's precious little!!), but I'll post back to let you know how it's going.

    Thanks for the help.
    Ed
  4. Replies
    6
    Views
    1,567

    Re: Call VB6 exe from Excel macro?

    Never thought of that! So the whole process could block out something like this:?
    -- Click button on VB form to open XL file
    -- Hide, but not Unload, VB form
    -- Do all in XL file
    -- Last line in...
  5. Replies
    6
    Views
    1,567

    Re: Call VB6 exe from Excel macro?

    Thanks for your help. I'm on my mobile right now, and it won't scroll through a code section in a post with scroll bars, so I couldn't follow all of the code.

    I have found elsewhere about using...
  6. Replies
    6
    Views
    1,567

    Call VB6 exe from Excel macro?

    I have a VB6 program which populates lists from an Excel 2000 workbook. To add another item to the lists, I have a button in the VB form that opens the workbook and a userform.

    The VB button...
  7. Replies
    25
    Views
    10,381

    Re: Parsing Word Document & Export to Excel

    No problem at all with the hand-holding! I'd love to say I learned all this all by myself - but truth be told my hand was held many a time! Two things I have learned though - F1 (Help) and Google...
  8. Replies
    25
    Views
    10,381

    Re: Parsing Word Document & Export to Excel

    Well, the col B 'x' was just my way of setting up the list of what chapters to grab. It just made it easy to know which two headings we were working with, because for my code you needed the chapter...
  9. Replies
    25
    Views
    10,381

    Re: Parsing Word Document & Export to Excel

    I did some playing with your sample doc. I don't think we're going to be able to use the Table of Contents bookmarks. (Probably someone else with a lot more experience in Word VBA could, but I...
  10. Replies
    25
    Views
    10,381

    Re: Parsing Word Document & Export to Excel

    I uploaded the files to my web site so maybe you can download them from there.

    www.FamilyFunMagic.com/Stuff/MyReport.doc
    www.FamilyFunMagic.com/Stuff/MyReport.xls

    Ed
  11. Replies
    25
    Views
    10,381

    Re: Parsing Word Document & Export to Excel

    I've come up with something - hope it works for you. I tried to attach the files, but it wouldn't go. So here's the code that I put in a code module in an Excel file.

    Sheet1 of this file is set...
  12. Replies
    25
    Views
    10,381

    Re: Parsing Word Document & Export to Excel

    If you can translate "Toc292701022" into the chapter you need, then you're good to go. Try using the GoTo feature and type in one of these bookmark names and see if you go directly to the desired...
  13. Replies
    25
    Views
    10,381

    Re: Parsing Word Document & Export to Excel

    What I see as the building blocks for this are:

    -- A way to create a collection of documents to work on, or
    A method to use the doc path and name to get to the doc
    -- A list that identifies...
  14. Replies
    25
    Views
    10,381

    Re: Parsing Word Document & Export to Excel

    Sounds like an auto-genereated Table of Contents. And with that, each of your chapter headings would indeed have a bookmark as a place for the hyperlink in the TOC to jump to. Sure, those bookmarks...
  15. Replies
    25
    Views
    10,381

    Re: Parsing Word Document & Export to Excel

    Oh - and if you're running this from within Excel VBA, you might consider pulling your config file list (if it's CSV or similar format) into a sheet in your Excel workbook, vice holding populated...
  16. Replies
    25
    Views
    10,381

    Re: Parsing Word Document & Export to Excel

    When you say: "I am running out of excel, I wish to export to a different spreadsheet.", do you mean you're running out of room in the sheet to place your data? And you want to use a different...
  17. Re: Need help getting form window to top and active

    Yah - saw that thread as I was scoping out the WebBrowser control.
    I'm sure I will have some questions to add to it!! :confused:
    Won't have a chance until this weekend, though.

    Ed
  18. Re: Need help getting form window to top and active

    Commented this out

    No joy! The task bar and the form title bar just flash.

    Looks like it's time to see about a second form with a full-screen WebBrowser control.

    Ed
  19. Re: Need help getting form window to top and active

    Thank you, Spoo. Obviously, I've never delved that far into this. The WebBrowser control might be a good alternative, especially if it loads faster! :8>)

    Ed
  20. Re: Need help getting form window to top and active

    Thank you very much!! I'll have to wait until later to try those, and I'll let you know what happens.

    So I had the AppActivate syntax wrong, eh?? Knew it would be something simple!

    And all...
  21. Re: Need help getting form window to top and active

    Okay - finally, here's some chunks of my code. (I tried posting this last night, but my phone wouldn't cooperate!) The whole purpose of this app is to let me type in a word or phrase from a song...
  22. Re: Need help getting form window to top and active

    Spoo: I didn't mess with a Rich Text box because I didn't want to import the doc or cause any changes to the formatting, etc; I just wanted to open the doc. (It was all fine as long as it was just...
  23. Re: Need help getting form window to top and active

    Yah, I tried both. The SetFocus just makes the app notification on bottom flash. The AppActivate wouldn't compile.

    I'll get the code later when I get back to the other computer and I'll post...
  24. Re: Need help getting form window to top and active

    Thanks for the replies. But I've done this. And a bunch more - ActiveWindow, SetFocus etc. (Sorry - I'm on another computer right now and I don't have the code with me. Actually, though, I've...
  25. Replies
    25
    Views
    10,381

    Re: Parsing Word Document & Export to Excel

    I think I would drive this from within an Excel VBA module. Hopefully, all your Word docs are in one directory! If that directory is a constant, you can hard-code your file path; otherwise you're...
  26. Need help getting form window to top and active

    I'm self-taught in VB macros in Word and Excel, and I dabble a bit in VB6 (Classic, not NET). I'm not at all up on APIs, relying on slurping from the internet.

    I have a one-form program that works...
  27. MsOf07 Re: [Word2007] Any way at all to access ALL spelling, grammar options thru VBA?

    Tried that first, westconn1 - it comes up pretty much blank.

    Ed
  28. Re: Write, run VBS within VBA macro?

    Dang it!! I coulda swore it didn't work yesterday when it was _my_ idea!! And that's why I was asking!!

    Sure enough, though, it fired right off 'n makes me feel stoopud! 8>{

    Thanks, Mark. ...
  29. MsOf07 Re: [Word2007] Any way at all to access ALL spelling, grammar options thru VBA?

    Thanks for the links, koolsid - but I'm not so much interested in calling the Spell and Grammar Checks as I am in how to capture and change all of their settings.

    Ed
  30. Re: Write, run VBS within VBA macro?

    Hi, Mark. Thanks for the reply.

    The part I really had in question was:

    wshShell.Run ("cscript ""C:\Documents and Settings\user.name\Documents\TestMe.vbs""")
    When I tried to sustitue a...
  31. Re: Components available to upgrade VB6 LE functionality?

    Yah - I was afraid of that. Just thought I'd ask first.

    Thanks for the time and info.
    Ed
  32. MsOf07 Re: [Word2007] Any way at all to access ALL spelling, grammar options thru VBA?

    Hi, RobDog. Didn't see that link befre, but I just went through it all. *whew* - lotsa stuff!

    Unfortunately, not quite what I needed. I don't need to invoke the spell check function - I want to...
  33. Re: Components available to upgrade VB6 LE functionality?

    Yah - I just didn't want to have to worry about .NET/.Fred :afrog: vs VBA :duck: compatability. Very few tweaks to lift a macro and drop into VB6.

    Another issue is that due to corporate policies...
  34. [RESOLVED] Write, run VBS within VBA macro?

    (Not sure this is exactly the right forum; if not, a nudge in the right direction is appreciated.)

    Wondering if there's a better way to do this:

    In Word 2007 VBA (running on Vista Pro), I wrote...
  35. Re: Components available to upgrade VB6 LE functionality?

    I do write macros within Excel and Word. But I can see a use for gathering several macros having a specific application to our work and putting them into a VB exe that I can distribute. In my...
  36. MsOf07 [Word2007] Any way at all to access ALL spelling, grammar options thru VBA?

    Is there any way to access ALL the spelling and grammar check options in Word 2007 through a VBA macro? I can set some, but there's still a large amount that don't seem to be available.

    I'm...
  37. [RESOLVED] Components available to upgrade VB6 LE functionality?

    I have VB6 Learning Edition. It works great for me - actually, most of what I do is Word and Excel macros.

    Occasionally, though, I find myself wanting to put several macros into a VB program that...
Results 1 to 37 of 37



Click Here to Expand Forum to Full Width