Exporting MS Project Values into Excel

  • Thread starter Paul Peterson - Velox Consulting, LLC
  • Start date
P

Paul Peterson - Velox Consulting, LLC

I am exporting the "Actual Work" values from MS Project into an excel
worksheet. Unfortunately, 40 hours is stored as "40h" in excel which makes
it impossible to use for calculations. I would like some automatic way of
making sure this value is always 40 (rather than 40h) - I don't want to
manually manipulate my excel file. Any ideas?

Thanks.

Paul C. Peterson.
 
M

Mike

You could use a macro to do this
Sub hoursWorked()
'Macro to remove h
Const hoursColumn = "D" 'Change to your needs
Dim iRow As Long
iRow = 2
Do While Len(Range(hoursColumn & iRow).Formula) > 0
Range(hoursColumn & iRow).Value = Replace(Range(hoursColumn &
iRow).Value, "h", "")
iRow = iRow + 1
Loop
End Sub
 
P

Paul Peterson - Velox Consulting, LLC

Thanks for your help Mike.

Mike said:
You could use a macro to do this
Sub hoursWorked()
'Macro to remove h
Const hoursColumn = "D" 'Change to your needs
Dim iRow As Long
iRow = 2
Do While Len(Range(hoursColumn & iRow).Formula) > 0
Range(hoursColumn & iRow).Value = Replace(Range(hoursColumn &
iRow).Value, "h", "")
iRow = iRow + 1
Loop
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top