Recent content by Annelies

Hi, I have a Sharepoint list which has many entries (350+) and most of these have an attached file. I need to be able to access each of these files easily. I don't want to have to open each list item seperately and extract each file... is there an easy way that I can access all of these...

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...

Hi all, I have a spreadsheet that uses the NETWORKDAYS function, which is part of the Analysis Toolpak (ATP). This spreadsheet is used extensively through our department, by a large number of people. I have started receiving an increasing number of complaints that instead of the function...

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...

Hi Try this... Dim strFileName 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...

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!