Search results for query: *

...each list item seperately and extract each file... is there an easy way that I can access all of these files at once? I am in a corporate environment, and have limited access to the servers, so dipping into a SQL database is not *really* an option. Any help would be gratefully received...

Hi Glenn All users should have Excel 2003 (which the spreadsheet was created in). I now suspect that this has something to do with the ATP - VBA module not installing properly. I need to do some more testing on Monday, but a user who reported this problem yesterday did not have the ATP...

...no problems there - both are formatted as valid dates. This is also not a problem of Excel manually calculating its formulas - I've checked and the workbook is set to automatically calculate. Can anyone shed any light on this issue? Any help would be *very* much appreciated! Thanks Annelies

Has anyone found a solution to this problem? I have exactly the same issue - I need to establish the date when the Baseline Finish date (for example) for any task was last modified. Thanks Annelies

Hi I have been going slightly batty over this all day and would really appreciate any help that anyone can offer. I have three tables in Access: MILESTONE DATA (WBS, Tranche ID, Milestone Number, ...) MILESTONE NUMBERS (WBS, Tranche ID, Milestone Number, ...) TRANCHE DATA (WBS, Tranche ID...

Hi I have some code that loops through all controls on a form. I want to be able to determine what type (eg, Combobox, TextBox, CommandButton etc) each control is. My code looks like: Dim c as Control For Each c In Me.Controls If (c.?? = TextBox) Then 'Do something End If...

Hi I have a formula that I want to copy to non-adjacent cells, however I want the references in that formula to stay concurrent. For example, I want: A1: =Sheet1!A1 A3: =Sheet1!A2 A5: =Sheet1!A3 But if I do a standard copy and paste of the formula I get A1: =Sheet1!A1 A3: =Sheet1!A3 A5...

Hi, Since posting this I have found a website which explains how to do this. If anyone else wants to know, check out: http://www.dailydoseofexcel.com/archives/2005/06/05/multi-column-match/

Hi, Just wondering whether it is possible for a Control (Formula) array in Excel to return a text value? We can't seem to get it to work. Our formula looks like: {=(IF('Raw Data'!$D$2:$D$1000=$B5, IF('Raw Data'!$E$2:$E$1000=T1, 'Raw Data'!$F$2:$F$1000,"Could not return value")))} In plain...

...As String Dim objProject As Object Set objProject = CreateObject("MSProject.Application") strFileName = Application.GetOpenFilename("MS Project (*.mpp),*.mpp", , "Select MS Project File to import from") objProject.FileOpen Name:=strFileName, NoAuto:=True 'Do whatever you want to with it...

Good morning I am trying to Analyze some Resource Usage data in Excel using the "Analyze timescaled data in excel' functionality. The problem that I am having is that the numbers in Excel do not seem to match the numbers in Project. This is only happening with Material Resources, not Work...

I *think* that the reason you are having problems Gerry (which I also experienced) is that it would seem that FileSearch can only reference the properties available in the File > Open > Tools > Find dialog box. These are the 'standard' file properties, and do not include Custom properties. In...

Hi Thanks for this. Is this the only way (or simply the easiest way) to achieve this? The reason that I ask is that I am working in a Corporate environment in which the workstations are very 'locked' down. We cannot register DLL's on our PC's, so getting this solution up and running is going...

Hi I have a folder full of large Excel (3MB+) files. I want to import information from some of them, depending on some values in their custom properties. Because of the size of the files, and the subsequent delay in opening them, I would like to check the custom properties BEFORE I open the...

That is fabulous, thank you so much! I was really hoping that I was over-engineering things, but didn't expect it to be QUITE so simple! Thanks!

Hi, I have a workbook into which a various number of worksheets will be copied. These worksheets will be named "BU-*" (the * being a different name for each sheet). I want, on a summary page, for the formulas to sum a cell value on each of these sheets. The complex part is that at the time...

...the individual shapes, when updated individually, will intermittently update OK. This makes us think that the visio diagram and access database *can* speak to each other, they obviously just don't like it much! Can anyone shed any light on this problem for us? Your help would be much...

Hi! I have one file (lets call it MASTER.XLS) that opens another file (SUB.XLS) Sub.xls has a userform in it (frmPeriodEnding) that prompts the user to press one of two buttons. frmPeriodEnding is called from code on Workbook_Open. It then runs one of two Private Subs (cmdChange_Click() or...

Hi, I am trying to create what I understand is a 'no-no' in Excel - a circular reference within an IF Function. Basically, my IF Function looks like IF(condition,<set value of cell to this>,<leave the cell unchanged>) Does anyone know how to do this? Excel won't let me do a circular...

The news is not great I'm afraid... you need Outlook 2003 and a Service Patch to get this working... http://support.microsoft.com/default.aspx?scid=kb;en-us;821840&Product=out2K