Import Text from Excel spreadsheet

D

Dalef

Hi all
I am trying to automate a process that inserts or updates MS Project tasks
based on the data in an Excel spreadsheet, and I have two questions regarding
the process.

1) There is a 256 character limit on all of the text columns in MS Project.
Is there a way to change this setting, or do we have to settle for using the
Excel macro to truncate the Excel text columns to 256 characters before
importing the data to MS Project?

2) I would like to write a MS Project macro to append the text from one of
the Excel text columns to the MS Project NOTES field using the APPENDNOTES
function, but I can’t figure out the right syntax. Does anyone have an
example of correct syntax?

Thanks,
Dale
 
J

Jan De Messemaeker

Hi,

1. 255 is cast in concrete I'm afraid.
2. atask.notes=atask.notes & "ThetextfromExcel"

HTH
 

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

Similar Threads

Excel does not accept text format! 0
Linking data in MS Word into Excel 5
How to import Start/Finish Data from Excel 1
Importing new start and finish dates 0
Formatting Text from Excel 1
From VBA scroll to specific ID or Unique ID regardless of view 4
Word Mail Merge - keeping paragraph breaks that appear in original Excel cell data 2
import an Excel file to create a Gantt chart in Visio; Error:do not have the required mapped columns 0

Top