Search results for query: *

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

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

Hi everyone, I've got a macro that is saving my one column spreadsheet in excel to a txt format for uploading into another application. The problem is that A is turning into "A" during the Save As Txt Any ideas on how I can avoid this happening? Thx! Barrett

Hi everyone, I'm using the GetOpenFilename method as shown below: Filename = Application.GetOpenFilename(filefilter:=filt, Title:=Title) What I'm wondering is this: how can i provide a default directory on my C: for this to occur in? I'd like to avoid the user needing to browse to the same...

Hi guys, I'm working with the following SQL. I'm a beginner, most definitely. Everything works quite well, but when I try to use multiple cost centers in my prompt (for cost center) no data is getting returned. The wildcard %, on the other hand, works fine. So one or all is working, but not...

Hi everyone, every month I paste from excel to pp using a picture special format. Today, for whatever reason, I'm having issues in terms of getting a column, which I've obviously copied, to paste into the picture successfully. Any ideas? Thanks in advance! Barrett

Hi, if I attach a template, and choose to Automatically Update Document Styles - does that mean that later on, when I modify a style within that template, that modification will automatically carry through to anything based on that template? Thanks! Barrett

Hi everyone, I have a document header that references a single line of text on the front page of the document ("project title" style). Beneath that lies another style reference, to the "document name" style. My problem is this - on the first page these things look fine. On the second page...

Hi, I'm using MS Project 2002 and Project Server 2002, trying to assess its usefulness in terms of all its functionality. However, I'm having trouble getting any views into resources, or portfolio analysis. Resources in particular are frustrating, because the user I've set up has total access...

Hi! I know I could use a picklist within excel to change something like the color or conditional formatting of a cell. However, is there a way I can also get an icon to change? What I'd like to do is us a picklist (stop, yield, etc) of words to change the icon (stop sign, yield sign, etc) in...

Hi, I've just started using 2002, but my fellow team members still have 2000. However, I'm not noticing an ability to save a file down to 2000 format from 2002. Is this something I should be worried about? I do notice that simply opening an older 2000 file with 2002, then closing, prompts...

Hi everyone, this is a continuation of a previous post. I have the following BA DD Unix Admin[38%] DBA [40%] What I'd like to do is get the 38 and the 40 into column B, and removed from column A. I could do this through the use of some ugly code: 1. find length of total 2. find number of...