With regard to your question about the error on the "For Each uid in Range. A few lines of tidying up at the end and that was it. header, column widths, font, etc.) and then indexed through the arrays to write the data. Once the data was gathered, I pre-formatted the Excel Workbook/worksheets My macros used arrays, (single, two and three dimensional), to capture the Project data. The user to either export the data to separate Excel Worksheets or directly to two CSV files. ![]() Years ago I wrote a complex macro that included a userform to export Cobra data to a Resource file and an Activity file. It's interesting that you are exporting data for Cobra and that you have an Activity designation. (FileSaveAs Name:=ActiveProject.Name & Activity) but that obviously did not work. While I am on this I also am curious how I can edit the FileSaveAs Name:= () to be the filename + activity. The export macro is just thisįileSaveAs Name:=ActiveProject.Name, FormatID:="MSProject.CSV", _ The problem is I can only run that from excel, what I want to be able to do is run that after the export. I use to organize the excel file to my needs.įor Each uid In Range("A2:A" & Cells(Rows.Count, "A").End(xlUp).Row) ![]() However my activity file is exported based off a map and I then use an excel macro to organize the excel sheet to my liking. I have been using a user-form from Project to export a resource activity file and time phased report.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |