Hello,
I have a Macro that runs, and saves a document with whatever today's date is...The next step is when a user closes the Word application by clicking on the Red-X, I need all the VBA/(Macros) to delete from the visual basic editor.
What would be a code to do that? Here is my current code...
Even though you were quite rude to me in my thread, I wanted to add something in here...PHV Suggested
PHV (MIS) 3 Mar 09 15:12
Why not an UserForm ?
I think he meant a user form - created in the VBE, would that work for you? Allow the user to select from a box that would pop up?
If not...
Hey you guys...Some of you dont have to be quite so rude...but Ive read the information about cross-posting, and I agree with it.
Ill be more careful in the future before doing a cross post, and if I do, Ill provide links!
Thanks to everyone
Ive had an identical thread going here:
http://www.mrexcel.com/forum/showthread.php?p=1859589&posted=1
A fellow has helped me out re-arranging the code to use a string like this:
Selection.TypeText (CStr(myWB.Sheets("PayHist").Range("B" & 5)))
Thread Solved!
Thanks to everyone!
Is it bad that I ask in more than one place for suggestions?
The assistance on VBA Express has not been sufficient, so Im asking around to see what others think of my problem here...
Regards,
Hello,
What Im trying to develop is this:
(I have a Word document, that pulls information from an Excel document)
(Thats essintially what this script does)
A Macro that upon opening of a Word Document, a Macro executes and updates the information a Word Document from a source file which is an...
Ok, now that I have tested a few things out, I also made some sample data with 9 rows, and attached it to this post.
All the attempts and suggestions I tried failed...
Im thinking this could work:
UPDATE WELLS
SET VolumeNum = DCount("*","WELLS","Number='" & [Number] & "' AND RowID<=" &...
Hey,
Thanks for your time...Ill explain a little more...
There is a ID column that automatically gets assigned when a new record is entered.
The data is already in order...but there can be three instances of a number like this:
RowID Number VolumeNum
1 10-02-003-04-W5...
Hello, Im in 'Table' view right now...and in
Column 23 (Column Letter W) if you had to assign a letter, in my list there are sets of numbers like this:
02-03-005-09-W2
02-03-005-09-W2
The reason there is two numbers is because one is volume 1, one is volume 2...
The table Im using is 100,000...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.