Pages

Index



Index


Formatting
Filter
Worksheet
File and Folder Name
Notepad
Outlook
Charts
Export To Powerpoint
Import  from Powerpoint to Excel

Google Map API
Access 
Free Downloads 






Note: All Macros are tested and working fine in Excel 2007 Version


15 comments:

  1. Very Knowleglable ....Thanks .

    ReplyDelete
  2. You have good knowledge in macro. Nice. Can you do one excel file that can translate from french language to English language by base on ms-office inbuilt offline translator? It will be helpful for offline excel users to translate easily.

    regards,

    Suresh UMARE

    ReplyDelete
  3. Hi how can I get the excel files for the excel export / import to Access . The links you gave are no longer working. In fact I need the files to update my skills on interfaces between excel and Access.

    ReplyDelete
  4. I am encountering a problem with my program. We have a small project called Library System. I have a frmDeleteBook and in that delete book, before you delete a book, you must enter the BookID then, by clicking the View command button the data on the specific Book ID will be retrieved on the textbox/s (enabled = false) and when I click the delete button a Type Mismatch Error shows up.
    This is the highlighted error.
    Rows(num & ":" & num).Delete Shift:=xlUp
    Can you help me, I'm a beginner

    ReplyDelete
    Replies
    1. can you please share the whole code at
      http://www.facebook.com/groups/excelvbamacros/
      http://www.facebook.com/EXCELVBAMACROS

      or mail me koul.ashish@gmail.com

      Delete
  5. Can you please explain how to write VBA code to compare 2 columns using Vlookup.

    ReplyDelete
  6. After a long time i built a Monitor Power Saver application in Excel, So I thought I’d share some of my application. once this application runs successfully then I’ll build the same application in .exe format.

    This application save your monitor power when your PC is in lock mode.As soon as you lock the screen, the monitor goes off

    Link1.....
    https://www.dropbox.com/s/4l72u4mb7xxmne1/Monitor%20Power%20Saver.xls

    Link2.....
    https://www.dropbox.com/s/0xl48by1bjpkmwl/Monitor%20Power%20Saver.rar

    Any feedback/suggestions would be greatly appreciated!! Thanks!

    ReplyDelete
  7. Hello, I need recover a corrupt Excel spreadsheet , a friend recommended this tool http://www.excelfix.com/, so i would like to know your opinión about this recovery tool or another tool. Thanks for this.

    ReplyDelete
  8. Respect your work Sir...
    Look forward to improve skills with your support...
    http://warlocksolutions.blogspot.com/

    ReplyDelete
  9. my e-mail address
    umer03344@gmail.com
    please send me some useful excel file

    ReplyDelete