![]() ![]() If fileExplorer.Show = -1 Then 'Any folder is selected Set fileExplorer = Application.FileDialog(msoFileDialogFolderPicker) With help of below answer, I have rewritten the code to import the multiple files and saved it as *.mpp file.īut the problem is mpp file is opening and it should happen in the backend user should not view naything.ĭim InputFolderPath As String, DefaultInputFolderPath As String, DefaultOutputFolderPath As StringĭefaultInputFolderPath = "D:\Sample Projects\MPP Import\Input\"ĭefaultOutputFolderPath = "D:\Sample Projects\MPP Import\Output\" ![]() I would like write the update script using Mapping field and ![]() 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.Īutomate creating n Microsoft Project files from an excel file with n rows 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 would like to create an automated tool to import the excel for Microsoft Project file. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |