Search results for query: *

So when I record a macro to update the progress of a task to the status date I get something like this < UpdateProject All:=False, UpdateDate:="3/02/19 11:00 AM", Action:=1> I want to change the <UpdateDate:="3/02/19 11:00 AM"> to reference the Status Date Te object browser suggests...

Hi I am copying data from Excel to an email I want to copy data from a range as an image and pop it into the email. This is working ok. I also want to add some headings after the image in the body of the email. This also works ok. BUT when I want copy the image to the email then add body...

When I use the offset method in Excel to select an adjacent cell it works fine. I have pushed some data via MS Project to XL using code in Project. It seems when I use the Offset property it is not supported. ActiveCell."Offset" does not appear in the object drop downs when coding in Project...

Hi Looking for some code that timestamps for me. When Percentage in column H = 100 percent then Column G corresponding rows will show timestamps when 100% was achieved. I want this to be static and not recalculate when the workbook is opened a day or two later Cheers

I would like to push out a an excel file to a public folder (Mabye google docs) It has some tasks listed and I would like users to use a form on a mobile device to update records on the sheet. I have looked at forms in Google docs but I can only seem to create a form that adds a new record to...

I have noticed some macro's run ok from the editor but when I put a button on the ribbon the macro looks like nothing happens. So I then run one line at a time and notice the macro will run, but when it reaches "End Sub" everything undoes. Not sure if this has been discussed on here but I would...

Hi I can find lists for Excel and word ,but i am trying to find a list of imageMso buttons for MS Project I would like to programatically choose a button image by calling the image name. I can not find a list of buttons and names that reside in MS Project. Can anyone point me in the right...

I was wondering if there is a way of putting an expiry date in for using a template. I can see this with an "if today > than XYZ date then message:" What id like to do is limit the use for say 12 months, after which a box comes up to enter a code then it reactivates. However Id only want to...

Hi, I have been working with some code that takes the text from text3 places it in the name column and indents the relevent tasks by one level. Thanks to PDQBach for getting me this far. ============================================================================================ Sub...

Hi I have some data I would like to extract two values from. The string length can be variable so a fixed count will not work. I want to extract the second last bit of data in this example I want to extract SMI from "56W Mech Insp BMM SMI STK7" in the the scond example I want to extract SBGSM...

Hi I have to look at a data set and measure change on a daily basis. Each day I will be pasting data into sheet 1 to compare with yesterday’s data. I’m guessing I may Copy sheet 1 to sheet 2 Overwrite sheet 1 with new data Compare results in sheet 3. I want to show in sheet 3 Current list New...

Hi I have used some code to send data from a range of cells via an email +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Sub Send_Range() ' Select the range of cells on the active worksheet. ActiveSheet.Range("A1:B5").Select ' Show the envelope on the...

I have a row of data in row 1 from C:1 to C:55 Each cell in row 1 has a number from 1 to 52 starting at C:1 Cell A:1 has the current week ie 31 (using weeknum formula) I would like to use VBA to look at A:1 and end up selecting the right cell in row c based on the A:1 value I have searched...

In Excel this is easy but MS project has me stumped. I want to find the last row of data in the name column and select the next blank cell in the name column. I then want to paste data from that point forward. How do i find the next blank cell using VBA ? Appreciate some guidance with this Thanks

I was messing around with some code and I can change "Task Bar" formats based on data in "Text1" field. For example If Text1 = "Area1" then Task Bar will = a nominated colour. This part is no problem and in a stand alone project it works a treat. BUT when I run my code in a master project it...

Hi, I have some data in Excel that I would like to import and assign hirarchy upon importing . For example: Column A has a list of work order numbers Column B has a list of task numbers Column C has task description Column D has Work order header description. I would like to import the data...