Search:
Type: Posts; User: Ed_from_AZ
Search:
Search took 0.02 seconds.
-
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...
-
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...
-
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
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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
-
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
-
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
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
Tried that first, westconn1 - it comes up pretty much blank.
Ed
-
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. ...
-
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
-
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...
-
Yah - I was afraid of that. Just thought I'd ask first.
Thanks for the time and info.
Ed
-
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...
-
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...
-
(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...
-
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...
-
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...
-
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...
|
Click Here to Expand Forum to Full Width
|