• 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.

Search results

  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.
  16. 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

    Thanks - it is not working getting Subscript out of range :( But if i change -2 to -1 it worked.
  17. 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

    Let me check the spreadsheet - Still issues with 224 sheets - It says Subscript out of range
  18. 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

    THanks, It is showing blank rows for Sheet10 in the Output Sheet post macro execution And it gave me subscript out of range for b(i) as there are 224 sheets to process
  19. 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

    Have a small bug - the current Region copy copied my entire data in the sheet not only the 2nd row all columns. Can you please help? ws.Range("A2").CurrentRegion.Copy (Copied all data from A2 below till the data exists in the sheet). Require only to copy A2 to Last column in Row 2.
  20. 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

    Hi All, I have multiple sheet - having data in Row 2 starting from A2 until some columns (some sheets have data till D, some have data till G etc..) I would like a macro, which would copy the data of Row 2 (All columns having data) from all sheets and paste it transformed in Column A in Sheet...
  21. ajoshi76

    VBA for creating a table using the parameters from checkbox

    Check this file - with values in each sheet (output) after the process button is clicked. Form II where the Process button is - would be the place where the values need to be selected and then once process button is clicked the 3 sheets to be populated. Requirement #2 The user would select ...
Top