• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Recent content by ajoshi76

  1. ajoshi76

    MS Planner Integration

    I wanted an automated code - not a manual upload - as it would be a project plan in excel which i wanted to auto sync with Planner. Manual upload doesnt solve my purpose.
  2. ajoshi76

    MS Planner Integration

    The code should be executed via Excel - and then output should be validated and verified in Planner - both are microsoft products .
  3. ajoshi76

    MS Planner Integration

    The VBA code should be in excel - and when the macro is run - it should have a DB connection to MS Planner application to upload the data from excel to Microsoft planner. MS planner can read Excel files .
  4. ajoshi76

    MS Planner Integration

    VBA to upload the data from the excel attached to Microsoft Planner application.
  5. ajoshi76

    MS Planner Integration

    Hi, I am looking for a VBA to integrate excel table and MS Planner - Could one please help? Thanks and Regards Ashish Joshi
  6. ajoshi76

    Gantt Chart - Bar Text to be created after the Bar is over

    oh thats very odd - as my entire data was populated in the powerpoint gantt in few seconds.
  7. ajoshi76

    Gantt Chart - Bar Text to be created after the Bar is over

    Thanks :) It worked with the + value suggestion. :) What excel version are you using? Though it shouldnt matter. Just curious. As it should not go in unlimited loop. Did you edit the data sheet with your data ? Do check the date format .... that causes a lot of issues
  8. ajoshi76

    Gantt Chart - Bar Text to be created after the Bar is over

    .TextFrame.MarginLeft = DiagramWidth * ((Cells(CurrentRow, 11).Value - Cells(CurrentRow, 10).Value) / (EndDate - startDate)) * 1.2 Not sure why it is going in endless loop as it works fine on my machine :(
  9. ajoshi76

    Gantt Chart - Bar Text to be created after the Bar is over

    okay thanks .Textframe.MarginLeft = Width *1.1 The code crashed with an error - after getting the text fixed on the bar. so it worked on the bar and when it reached the milestone it crashed.
  10. ajoshi76

    Gantt Chart - Bar Text to be created after the Bar is over

    The point was to use Excel data to create a Powerpoint gantt (via code) to send to leadership. How does one determine the length of the bar ? Because i tried margin left etc. nothing worked
  11. ajoshi76

    Gantt Chart - Bar Text to be created after the Bar is over

    The whole code worked except of the text on the bar
  12. ajoshi76

    Gantt Chart - Bar Text to be created after the Bar is over

    Attaching my workbook
  13. ajoshi76

    Gantt Chart - Bar Text to be created after the Bar is over

    I added >>> use code - tags <<< TextFrame2.MarginLeft = RowHeight * ShapeSize *3 The smaller gantt chart bars it worked fine. But for Larger bars it doesnt work...
  14. ajoshi76

    Gantt Chart - Bar Text to be created after the Bar is over

    The below code is executed after the shape (Gantt chart bar is created) to update the text (Task description).... The output is that from the left margin of the bar the task description is populated... But i would like to have the task description tagged after the bar is ended. I am attaching...
  15. ajoshi76

    Copy Entire Rows from each sheet and paste it in another column in one column with Sheet name pasted against each field from where its being copied

    Apologies to all who helped me on this - Next time onwards will ensure i provide the exact spreadsheet with the problem statement.
Top