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

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

Thanks for Responding Skip, Column H is looking at another sheet and adding up progress from various cells, eventually all tasks will be complete and 100% will be achieved.

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

No Change, Just cant get my head around why it runs from the editor and not from the ribbon

Thanks Kjv I also use other macros with For Each t In ActiveProject.Tasks i = t.ID - 1 And do not have the same issue. Also the script plays out then on "End sub" reverts back to nothing. Ive seen this before on the odd occasion but never have been able to work it out.