Search results for query: *

Guys, I posted on here to try to get help and haven't received much. In fact, I think your comments could be a bit more constructive than so critical and questioning. At least I posted the final code to try to help out somebody else who might have the same issue. I would hope that would be...

Here's the code that actually works, in case anybody else would like to see it. What this does is from an Excel spreadsheet, it launches a Word document that has come from a print output and has no columns that can be parsed, with Word macros that select data, such as name, SSN, birthdate, and...

OK, Skip. You win. I give up. Sorry I posted.

Yep. Did that too. This is a 1980s version of a DOS-database and this is the ONLY available electronic extract of data that I can get, as a TXT export. Thus, that brings me back to trying to copy/paste pieces of the record into a spreadsheet. Do you have any ideas about how to jump from Excel...

Yes, I saw the Process TGML. I did not want the example pasted with the TT tgml code because it needs to represent exactly the way the Word doc looks, which it does. And yes, the columns do not line up at all. That is exactly the way it looks in the original Word doc, which is the problem...

Here is the entire part of the actual record. Yes, the spacing is weird and that is the problem. If I could simply do an import and put all the data into columns, I would. But there is nothing about this data that permits easy parsing. That is why I need a set of macros in Excel and Word that...

Actually, there are two macros that I showed. In all there will be probably a dozen. But I thought two would show enough of what I needed. After the Word macro runs to copy in the Word document, I have the pasting in the Excel macro, where I assumed that it would work best for the Excel...

You are exactly right. I had forgotten to show how I was asking the Word macros to copy from the Word document. Since I want the Name, I'm doing a search on the "," and then spacing over with the select to pick up the dates. Thank you for your help. Sub Macro2() ' Dim sData As String...

I have a 300-page word document with some data that I have to use a macro in Word to copy and then am trying to paste into Excel. I got this to work with one copy/paste, but how do I send the focus back to the Word document, and run another macro in Word, then copy/paste back to Excel? Here's...

Here's what Microsoft says about MS Query. I'll try to download it and put it in my 2007 version because I thought it was a great add-in too. http://support.microsoft.com/kb/288118/en-us

Thanks for the posting, but unfortunately, Microsoft quit including MS Query in any Excel version past 2002. So I can't use this in 2007 or 2003. I'll try to do something with automating the Autofilter, but it doesn't look too clean.

Yes, Yogi, you're right, but he wants to do it with a macro so it is automated. I don't know if filters can be automated.

I have a client who wants to create a spreadsheet that will have a column that alternates between a "0" and "1" flag. He wants to send all the "1" flag records to a separate spreadsheet and print out the area. I could easily do this in Access with a query and make a new table, but how do you...

I've put as many as 6.5 million records that had more than 25 fields into an Access 2003 database. There was no degradation in performance and it never crashed.

Even though my registry didn't exactly match up to the instructions, I think just by opening up and following the steps in the link you sent caused this bug to clean itself up. THANK YOU THANK YOU THANK YOU

Last week I thought I'd try Firefox. After an hour or so, I noticed that when I wanted to copy anything in Excel and paste in Word or Publisher, I couldn't do it. So I uninstalled Firefox from the Control Panel and it helped--but now I still can't consistently copy a chart, text...

Let me suggest something that is quick and easy. I bought an incredible application that let me build an Access database for the web in about 15 minutes--and it works great. Here's the link: http://www.asprunner.com/ (By the way--I am not associated with this company other than a user.) Long...

This would seem easy but I can't find a way to get it work. I have a Powerpoint presentation with 24 slides that are in Portrait orientation. But I have two slides that have to be landscape orientation. Whenever I change the orientation in the Page Setup area in Powerpoint, it changes the...

Roy-Vidar--Works like a charm. Thank you for ending my two days of research and debugging. This is really a clean piece of code.

I have a basic recordset coding problem that is stumping me. I want to flip a SELECT flag whenever the IDNUMBER changes, but this would be the last date associated with that IDNUMBER. Here's what I've started: Dim Dbs As DAO.Database Dim rst As DAO.Recordset Set Dbs = CurrentDb() Set...