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

    Xlsx to XMl Conversion through MAcro Need Help

    Write the below code user the button click event. ActiveWorkbook.SaveAs Filename:="FilePath/Filename", FileFormat:=xlXMLSpreadsheet, ReadOnlyRecommended:=False
  2. Abdul Matheen

    Save File without Text Boxes

    Hi Lesley, Once you do the saveasworkbook just delete all the textbox and buttons and save the workbook. below is the code to delete the activex objects. Sub delobj() Dim obj As OLEObject For Each obj In ActiveSheet.OLEObjects obj.Delete Next End Sub Regards Matheen
  3. Abdul Matheen

    Restrict cell input until another cell is populated

    Hi Lesley, To do this activity you need a VBA code, send me the workbook file i will do it for you. Regards Matheen
  4. Abdul Matheen

    Hello Narayana, I need one help from you, i have some TIFF documents i need to capture text...

    Hello Narayana, I need one help from you, i have some TIFF documents i need to capture text from that TIFF files, i tried using OneNote but unable to get the correct result. I am using excel 2010. Could you help me out on the same, it is nothing but i am looking for OCR. Regards Abdul Matheen
  5. Abdul Matheen

    MS Query Data Connection & Coworkers' Different Drive Letters

    Hi, Instead of drive letter you give the server address, when you map the share drive to your system you give the server address like \\server\sharefolder give directly that address in the code it will work fine irrespective of drive letter. Regards Abdul Matheen
  6. Abdul Matheen

    VBA Insert New Rows

    Hi, Click on record macro and goto any cell insert row and copy down the above row. Then see the code is generated in the VBA editor, just change range("") to activecell. Regards Abdul Matheen
  7. Abdul Matheen

    Publish Dashboard on web with all ActiveX objects

    Thanks for your response. Actually i am looking a excel dashboard to be deploy on web site. Where my excel will work as source data and all the functionalties like button and dropdown should work in web site, i am aware of sharepoint but i want to deploy on web intranet or internet. Regards...
  8. Abdul Matheen

    Publish Dashboard on web with all ActiveX objects

    Hello, I need your help on vba, i have created a dashboard with some ActiveX controls like dropdown and command buttons which make the dashboard interactive. When i do a save as web page the ActiveX controls are not working on web. I need to publish dashboard on web with all the objects...
  9. Abdul Matheen

    How to copy data from one workbook to another

    Hi, You need to create variable to store all the workbook names and put the variable in loop and for the source workbook you can "Thisworkbook" function. Regards Abdul Matheen
  10. Abdul Matheen

    Color Picker AddIn

    Hi Ali, I am unable to open that file, could you please attach that file again. Regards Abdul matheen
  11. Abdul Matheen

    Advanced IF conditions

    Hi Ali, Wonderful job....I like that very much. Regards Abdul Matheen
  12. Abdul Matheen

    Date reminder

    Hi Tobias Ebuku, The formula is in the conditional formatting, go to home tab there you will find conditional formatting, there go to manage rules. There you find the formula. Find the attached picture. Regards Abdul Matheen
  13. Abdul Matheen

    Date reminder

    Hi, You can give the conditional formatting for that cell, through conditional formatting you can set the reminder like in the attached work book i have given when in the sheet1 F5 date matches with the current date it will turn to RED color. Check entering date in sheet1 F5 cell. Regards...
  14. Abdul Matheen

    Can the MAX function be modified......

    Hi James, You can use =LARGE() function instead Max, you will get 1 or 2nd etc number in the range. Example 1 2 3 4 =LARGE(A1:A4,2) = Result = 3 in above example the 2nd largest is 3. Regards Abdul Matheen
  15. Abdul Matheen

    Fully Customizable VBA Date Picker

    great stuff, really very useful. Thanks for sharing.
  16. Abdul Matheen

    VBA Error: Concatenate in SELECT statements

    Hi, SQL not recognise the "&" hence it is giving an error try using "+" instead "&". Eg: strquery = "Select number + name as numname from table_name" Regards Abdul Matheen
  17. Abdul Matheen

    Userform, submit to generate number in column B

    Hi Ben, Do you need to auto generate the job number? If so then put the below code in the submit button. Code: <Sheet name>.<Range name>= <Required Number> If you need more help then send me the sample work book I will do it for you. Regards Abdul Matheen
  18. Abdul Matheen

    Save Sheets in Separate File Debug Error

    Hi Shakeel, I tried with same code from my end and i didn't received any error. If possible could you send me the error message what you are receiving. Regards Abdul Matheen
  19. Abdul Matheen

    Macro for matching by shifting rows down and getting difference

    Hi, I have made macro as per your requirement, check the attached workbook and run the macro "rearrange". Regards Abdul Matheen
  20. Abdul Matheen

    Module not working

    Hi, The macro will create new sheet with sequential number, hence you should not specify as sheet1 instead you have mention as activasheet. The macro creates a new sheet and activated. Remove these 2 line Sheets("sheet1").select sheets("sheet1").name="Pivot1" put the below code...
  21. Abdul Matheen

    VBA Code

    Hi Deepu, Find attached macro as per the requirement, download the attached workbook and save in the same folder where you save the individual workbooks and click on "Run Macro!!!" button. Regards Abdul Matheen
  22. Abdul Matheen

    VBA Code

    Hi Deepu, Can you send a sample workbook with data and exact requirement sample, so that i can design in the same way. Regards Abdul Matheen
  23. Abdul Matheen

    Help Please!

    Hi Donna, Can you send me the sample file what exactly you are looking for, i have little confusion on week worked. Regards Abdul Matheen
  24. Abdul Matheen

    VBA Inputbox to select 2 sheets of users choice

    Hi, Find the attached workbook with solution of your query. if this meets your requirement then click on LIKE. Regards Abdul Matheen
  25. Abdul Matheen

    Report

    Hi Kaiser, I have made the changes as per your requirement, check the attached workbook. Regards Abdul Matheen
Back
Top