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

    VBA Pivot Data Source Change Error "method pivottables of object _worksheet failed"

    Have tried this but getting same error... Please Note : I am copying Pivot Table from Another Workbook into new workbook and Then I had changed Pivot Table name in new workbook and then trying to change Source Data but error occurred. Dim Pivot_sht As Worksheet Set Pivot_sht =...
  2. Nitesh Khot

    VBA Pivot Data Source Change Error "method pivottables of object _worksheet failed"

    Unable to change Existing Pivot Table data source.. Getting error "method pivottables of object _worksheet failed" Set Pivot_sht = ThisWorkbook.Sheets("Summary") Pivot_sht.PivotTables("Manpower").ChangePivotCache _ ThisWorkbook.PivotCaches.Create( _...
  3. Nitesh Khot

    How to Find Corrupted file using VBA code

    Hi.. I want to know how to check excel file is corrupted or not..as I we are storing multiple excel file in folder but some files are corrupted..... Thanks, Nitesh
  4. Nitesh Khot

    Check value available or not in 3 cell

    Hi, How to compare 3 cells value available or not.. ie. A2 B2 C2 I want to check any if value is available or not in any one of the cell...if 3 cells are empty then highlight as red. Thanks, Nikh
  5. Nitesh Khot

    How to Highlight Value if not in array

    Awesome..
  6. Nitesh Khot

    How to Highlight Value if not in array

    I want to highlight cell value if not present in array.. ie. if in array("IN","US","SG") If in Range(A2) to last row if cell value not in array then highlight cell as red backcolor. Thanks in advance, Nikh
  7. Nitesh Khot

    How to Stop backup file creation everytime when save on file..

    Thanks for prompt solutions....
  8. Nitesh Khot

    How to Stop backup file creation everytime when save on file..

    Hi.., How to stop creating backup file i.e Backup of CENTERLISTDATA.xlk Note :- I have tried Check / unchecked Auto Receover option. Version of Excel - 2007 MS Office Edition : Enterprise Edition Thanks, Nikh
  9. Nitesh Khot

    how to convert .xls file into .xlsx format without loosing formats.....

    Hi.., When i download file from system its exported into .xls format and i need to convert every tie into .xlsx ...is there any vba code to this in quick... Thanks, nik
  10. Nitesh Khot

    It Is possible to change vba message box design.

    i want to change apperance & want to add images onto message box....how to do this using API???
  11. Nitesh Khot

    It Is possible to change vba message box design.

    Hi.., Is there any way to change messagebox design (except userform suggestion) same as like as messagebox displayed on webpage or other sites... thanks, Nitesh
  12. Nitesh Khot

    How to Move Grand Total Column in Pivot from right to left

    In Pivot table we can't move Grand total column from Right side to left side... Is there any vba code or trick to do this ?? Thanks, Nik
  13. Nitesh Khot

    Macro to check latest file in folder & move to another folder

    Hi Experts, I am looking a vba code to check latest excel file in folder and copy data into macro file and then move file into another folder... How to do this using vba code ??? Thanks in advance.. nitesh
  14. Nitesh Khot

    Excel 2016 Hangs when Filter On / OFF

    I have reinstalled / repaired Office but same problem....even i have checked any updates from MS......also checked ctrl + end....but same problem.....is there another issue ...
  15. Nitesh Khot

    Outlook to Excel & Excel to send mail

    I have gone thr' this but can't get satisfied answer....i.e => How to create unique number when export mail into excel and if i received multiple mails at same time then how to handle this...
  16. Nitesh Khot

    Outlook to Excel & Excel to send mail

    Hi.. Is there any trigger to check new mail in subfolder of inbox (i.e Inbox then subfolder "Mails FromFriends") then export sender name and subject into excel database then create unique number and send again mail to sender... if it is possible then how can we write code for the same...
  17. Nitesh Khot

    Excel 2016 Hangs when Filter On / OFF

    Hi Experts.., I have Installed Excel 2016 (32 Bit) on my windows 8.1 system.....Whenever I work on small data i.e around 10 cols and 500 rows....My Excel gets Hangs and then i have only options to close workbook.....(If you press ctrl + s then excel save data but not working)... I have checked...
  18. Nitesh Khot

    How to Create India & District Map in Excel...

    How to draw or add map in excel to display sales and change particular state color.. Thanks, Nikh
  19. Nitesh Khot

    How to autobackup Workbook using VBA code..

    Yes ..But Can you show me code for this....this will help me for anither project
  20. Nitesh Khot

    How to autobackup Workbook using VBA code..

    Hi.. I am looking for vba code which is autobackup excel file (in background as per interval) and save in target folder. If excel get crash then when I open again excel then it should ask for recovery of temp file. or if my excel stops or Not responding then automatially save file & wait...
  21. Nitesh Khot

    Automatically Send Mass emails

    No Idea.....Try using F8 else you need to get access from System Administrators... Thanks.
  22. Nitesh Khot

    Automatically Send Mass emails

    Dear Abhijeet..., Run your macro in debug mode..i.e pressing F8...just send 2-3 mails by using F8 keys...then it will not ask you for allow/deny option.....If not then you have to turn on options as below :
  23. Nitesh Khot

    Automatically Send Mass emails

    Hi Abhijeeet, change macro setting of outlook to always run macro save & exit and then run code in debug mode (F8) with ".send" ....send more than two mail in debug mode and then problem will solve.... I had same problem & now this resolved..
  24. Nitesh Khot

    How to Insert Data Into SQL Table Using Excel VBA.

    Thanks Working Awesome... Thank you, Nikh
Back
Top