Search results for query: *

Yup, that worked. Part of what I was doing wrong was setting only using date, but not time as well. There may be a better way of doing this, but it worked. Thanks! Dim curdate As String curdate = Format(Date, "mmmddyy") & Format(Time, "hhmmss") Sheets("Summary").Select...

Hi, perhaps I'm still not being clear. I'm using the code: curdate = Format(Date, "mm-dd-yy hh:mm:ss") to set curdate. I need to use alternative code to set curdate to include month, day, year, hours, minutes and seconds, but without the colons (as we've discussed, a worksheet cannot be...

Sorry, I thought my post indicated that I had tried this, and appreciate the need to scrub the colons from curdate before trying to name the sheet with it. To clear up the question, I'm trying to set curdate to reflect date and time, but without colons. Thanks! Barrett

Hi, I'm very close to being able to insert a copy of one worksheet at the end of my workbook, and rename the new sheet using current date and time. Date is easy, it's time that's giving me a little hassle - presumably since Excel doesn't like you using : in your sheetname. Here's my code...

Hi everyone, I'm a relative newbie, and am interested in making my excel code more efficient. Just a couple questions. 1. is there a really good newbie reference (free or for purchase) for excel vba? I'll paste an example of my code below, so you can know the general level I'm at right now...

Hi, I'm pretty new to using relative references in my VBA code. I use excel 2003, and write fairly simple programs most of the time. I'm wanting to start in a particular cell, which will change every time I run the program. I will then move four spaces to the left to set one of my variables...

Hi, I've heard that if I can get my Lotus Notes Calendar (or at least entries within it) to iCalendar format, I can import that into Google Calendar. I'm looking for the quickest and simplest way to get my Notes Calendar syched with Google Calendar, without installing software. Any thoughts...

Hi everyone, I'm using BO 6.5 SP2. I have two columns - one is a production date, another is the number of months before a product expires. How can I build a formula that uses both these columns to return the actual date the product expires? Thanks much in advance! Barrett

Thanks - this compiles alright, but does not actually do any Find/Replace work. Perhaps the range is not defined correctly? Thx Barrett

Thanks Femei, I've tried using a Range instead, but don't have the syntax correct. It's giving me a compile error of User Defined Type not Defined. Any ideas? Specifically, it looks like it's highlighting the Dim rng line. Here's the code: Sub test() Dim appWd As Object Set appWd =...

Thanks for all the great help and ideas! Here's my code right now. For some reason, instead of processing all the replacements, it instead simply selects the first instance of "D" in the word doc before it exits the procedure without error. Any thoughts? Thanks, Barrett Sub test() Dim...

actually, here's what I've tried. I'm getting a compile error highlighting the CreateObject command stating Sub or Function not defined. For some reason I thought CreateObject would be an internally defined function of some sort, that Excel would use to reference an external word object: Sub...

Yeah, the trouble is that when I try to have it (the Word macro recorder) record me opening an Excel file using Excel, I've had no success thus far. Based on my research in this forum, I'll probably want to: Set appWd = CreatObject("Word.Application") appWd.documents.open...

Hi, thanks PHV. My vba knowledge is such that I could easily do this if it was all within the context of Excel. I'd probably tape a macro and go through the motions in order to get the syntax. But since the macro won't record once I leave excel to open the file using word, I'm not sure what...

Hi everyone! what I need to accomplish is very simple. Based on an excel table with two columns: Excel columns: "Find What" "Replace With" I will need to open up an XML file using Word, and then do find replaces within that Word file. Thoughts? Thanks! Barrett

Hi everyone, I'm thinking someone will probably figure this out fairly easily. I have two columns with data: Production Date (usually the first day of a certain month) - examples would include 8/1/2008 or 12/1/2008 Then I have a number of months until Expiry (Expiry Months) - examples would...

Hi, I have a Receipt Unit of Measure and for an Item, and the Item's base Unit of Measure. Returning the correct conversion rate from the database is complicated, but I'm wondering if there is any advice out there? To me, it seems at least three tables from the INV schema will be involved...

Hi everyone, I've got two tables, that should be linked by common field course_code. The tables are called Courses and Emp_Qualifications. How can I write a simple statement that shows me all Courses that have course_codes not found in the Emp_Qualifications table? Thanks! B

Hi! I feel silly even asking this. How do I get a count of unique values in an excel column?? (easiest way?) B

well heck, that was easy ;) thanks a lot CMP!! Barrett