Recent content by Palmcrest

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

Went down a different path - Saved image as temp file, referenced it and added it into the body text with HTML. All worked good

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

OK so I realised I was not referencing the Excel objects by using Dim XXXX as Excel.Application All good

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

Lol , I was channelling the capitol V after Skip in your name, apologies :) And yes thank you for your efforts, I am self taught on VBA so I really appreciate looking at and understanding this code. Im constantly amazed at what can be done and how people construct code to get it done.

Cheers Vic I will run it this morning and have a go. Thanks for your help.

Yes I did have the same thought. If old stamps are left in there, a new update will not overwrite. So it would be best on >100% it clearts

Thanks Skip Much appreciated, this helps me understand a few things that were a bit blurry to me.

Hi The line of code turns yellow when I put a break on it and enter a y To be fair the process works well on one entry at a time. it only has an error if I delete multiple "y"s or drag a y down the list.

Yes

Yes Macros are enabled. I restated my laptop and when I add or remove "y"s from the category I get a type mismatch error on this line. sCat = Intersect(Target.EntireRow, [Category]).Value 'corresponding Category value EDIT, Single entry works , if I drag down multiple "y"s I get the error...

When I update the category column with a "y" I can see the percentage hit 100 But no timestamp is triggered.I have also refreshed data but nothing so far.

Thanks Skip I will go through this and see what I can learn... I will update this thread after I have a look. Appreciate your inputs

I have uploaded a sample book Sheet 1 column F is the column I want to timestamp after column G rows = 100% The percentage is using a formula to evaluate data on sheet 2 Hope this helpshttp://files.engineering.com/getfile.aspx?folder=ee4d81d9-7c7a-4a92-9d38-672651f7f537&file=Example_timestamp.xlsx