mapedit | Interactive editing of spatial data in R | Data Visualization library

Thanks to Rachel Hettinger's assistance I've been able to create a VBA macro to open an Excel workbook and create a new project from a worksheet. I am able to import to almost all of the project-level and task-level fields I need, but I did hit a roadblock. cannot import data to the project-level Description and Owner fields that I see in the Project Web App or the Task-level Status Manager field that I see in the client.

The following is an excerpt of how I handle the task-level fields:

I'm working within MS Project and trying to use a macro to import project information from a spreadsheet to MS Project. What I have so far works fine for importing the Task information from the spreadsheet. I'd also like to import the Enterprise Custom Fields Project information, like Project Departments -- the information you would see in the Project Information dialog box. I am able to pass hard-coded information to those fields using ProjectSummaryTask.SetField, like this:

I've been trying to import project data from Excel into MS Project; specifically the task Name, Outline Level, and Created, Start, Finish, and Actual Finish dates. I am able to import all of the data just fine...except for the Actual Finish dates. All of the Actual Finish dates are being populated with NA instead of the actual dates.

I was originally just trying to do the import through MS Project's import wizard. Then I recorded the following macro, which yielded the same result. (It's the first macro I've ever done for MS Project, but I have used VBA with Excel before.) Is there a rule set where having any of the other dates in the import would somehow cause the Actual Finish dates to force an NA? Or do you know any other reason for my problem?

I would like to create an automated tool to import the excel for Microsoft Project file. I am trying to achieve this in VBA (please suggest me, If any other options there) and i researched some code for basic setup.

I found following link to setup the system and code to do this automation but still not sure below code is exact my findings or not.

Sources :

https://www.linkedin.com/pulse/how-automate-ms-project-from-excel-app-malcolm-farrelle?trk=portfolio_article-card_title

Automate creating n Microsoft Project files from an excel file with n rows

I would like write the update script using Mapping field and create/append as new projects.

Update

With help of below answer, I have rewritten the code to import the multiple files and saved it as *.mpp file.

but the problem is mpp file is opening and it should happen in the backend user should not view naything.

Code:

I have a directory with a bunch of shapefiles for 50 cities (and will accumulate more). They are divided into three groups: cities' political boundaries (CityA_CD.shp, CityB_CD.shp, etc.), neighborhoods (CityA_Neighborhoods.shp, CityB_Neighborhoods.shp, etc.), and Census blocks (CityA_blocks.shp, CityB_blocks.shp, etc.). They use common file-naming syntaxes, have the same set of attribute variables, and are all in the same CRS. (I transformed all of them as such using QGIS.) I need to write a list of each group of files (political boundaries, neighborhoods, blocks) to read as sf objects and then bind the rows to create one large sf object for each group. However I am running into consistent problems developing this workflow in R.

I am quite new to using R - and i am currently trying to create an elevation diagram of a study site using the below code: