Recent content by rocknrisk

Hi RoyVidar, Talk about the simple things. And they always seem to work. It works. Thank you. You're a star. "The important thing is not to stop questioning." - Albert Einstein

Hi all, I am trying to add a VBA check to a TextBox object to ensure that I don't end up with duplicate records in an existing Access97 database (I can't change "Indexed" property in the table to "Yes (No Duplicates)" because the table is linked). I have searched Tek-tips...

Hi Andreas, I cannot make your code work. It crashes my PC, unfortunately. So, I've tried to investigate a bit and have com up with this for now but it too does not work. Sub test() Dim wd As Object, wdData As Object 'Create a Microsoft Word session Set wd =...

Hi Andreas, Thank you. I will try that. The Word doc has no formatting really. It is a report from another application. Nice site by the way... I may read that "A Theory of Marble" sometime if I ever get some free time. "The important thing is not to stop questioning." -...

Hi all, I'm stepping out of the norm into API stuff that I know very little about. I need a macro to show me the Open Document Dialog box, select a Word file, copy all the data in the Word file, and paste the data into an Excel workbook. Please. I also need it to not paste the data all into one...

Hey Rob, Congratulations mate. Email me at clinton.edwards@edfenergy.com. I'll reply. I don't remember your email address. Thanks for the help. Clinton "The important thing is not to stop questioning." - Albert Einstein

Hi all, Thank you. Rob - It works. Cheers CL Macroman - how's the little one. Skip & Tony - Thank you... I have alloted for that but thinking about rewriting in a better format. I'm currently rewriting old macros that are very long because they were recorded. Will keep the reverse practice in...

Hi all, I have a data type issue here with my code (according to the compiler) at line 7 (For colID = ...). Sub rcbTrim() Dim colIDArray Dim colID colIDArray = Array("B", "E", "G", "I", _ "K", "M&quot...

Wow, thank you all, SkipVought - Sorry, I'm stressed - was just picking dates to use for the example. Also, I can't use a PivotTable as I need the data exactly as I mentioned before: ColA ColB ColC ColD ColE 28/02/03 3 Sales = 113 Items 24/12/02 4 Sales = 34...

Thank you BlueDragon, Please could you help me with this? How do I get the code to know when the Date changes i.e: <Date Reference>, as I have literally 1000s of rows with almost 700 dates?. Again, thank you. Clinton &quot;The important thing is not to stop questioning.&quot; - Albert Einstein

Hi all, Hope you can help, please. I need to COUNT and SUM items for specific dates, i.e: Col A Col B No. of Items Date 45 31/02/03 67 31/02/03 1 31/02/03 19 24/12/02 12 24/12/02 2 24/12/02 37...

Hey Geoff, Thank you. Your idea worked. I have given you a star in appreciation. You are a star, mate. Best regards, Clinton &quot;The important thing is not to stop questioning.&quot; - Albert Einstein

Hi all, Please can someone me with 2 problems I'm having with macros in Excel 97. How can I input the items in the AutoFilter list into an a array so that I can manipulate the data grouped by the AutoFilter list. Basically, if I had a column with a few 1s, 5s, and 8s in it, then AutoFiltered...

Hi all, OK. I'm about to crack here. I have written an applet. Included the <applet> tag in my html file but the applet won't load. I know that my classpath, etc. is correct because when I use appletviewer it works. I am using 1.3.1 and I have the plugin installed. We are working on a NT...

Pete, You're a star, mate. Thank you. &quot;The important thing is not to stop questioning.&quot; - Albert Einstein