Programming Resources & More

by Selva V Pasupathy, Hyderabad, INDIA

What’s New

Use BuiltIn Dialogs in Excel

December 20, 2008

Why would you design a custom userform for a routine excel task which can be performed with the use of 200+ builtin dialogs. READ MORE


Programmatically Set Excel Document Properties

December 20, 2008

When you save any excel file, the document properties are automatically set per the system information, like author name, organization name, etc. While you may not want the other person to know where and who created the document, or else you may want to change the properties. Read more to find out how you can do this programmatically… READ MORE

ARCHIVES

  1. Add Sheet Navigation CommandBar to an Excel file or Application
  2. Selva’s Blog
  3. VBA Code Library
  4. Search for a ’string’ in Excel Workbook
  5. Creating MenuRow for Sheets using an Excel VBA
  6. Export a Text File with Comma and Quote Delimiters
  7. Hyperlink Elements in HTML
  8. Login to Rediffmail
  9. Handle WebForm via VB
  10. Secure Login
  11. Get elements from HTML form
  12. Ken’s Knowledge Base submissions
  13. Process all Files in a folder
  14. Get Input Elements Name & Type from HTML Form
  15. Get Cell or Range from User
  16. Resources
  17. Web Forms manipulated by Visual Basic
  18. Write / Read to a Text File
  19. Rename Files using Codes (VBA)
  20. Multiple Cell Concatenation
  21. Get FileNames from a Folder/Directory
  22. Read CSV Using VBA techniques
  23. Auto-Generate a File Name
  24. Rename a File
  25. Move a File
  26. Verify that a File Exists
  27. Resources
  28. Fill a UserForm Combo Box List from a Database
  29. Write or Append a Text File
  30. Downloads
  31. Use of vbScript in Database Applications
  32. (no title)
  33. Connection & Query for data in Excel Spreadsheet
  34. Get FileName with Path from User
  35. Create Access Database via DAO
  36. Tips on VBA
  37. Create Sheet “Table of Contents”
  38. Add Minimize Button to Userform
  39. Search Folders and Subfolders for files
  40. Explore CommandBar control FaceIds Provided by Microsoft
  41. Contents of this Site
  42. Other Site Links
  43. Site Contents
  44. selvavinaygam
  45. Camera Function in VBA
  46. Automate WebLogin…
  47. Write to & Read from Sequential Text Files
  48. ADODB Connection Module
  49. Remove Unprintable Character & Spaces from cells
  50. Add an Image to Cell Comments
  51. VBA Foundations Part I-XII
  52. Reduce Excel File Size
  53. Create ShortCut Link at the desired location
  54. Get Next Available Row on ActiveSheet
  55. Sort WorkSheets by Name
  56. Convert Numbers to Words
  57. Find and Replace in VBA
  58. ExcelTip.com Links
  59. Code to Create FileHandle on Users’ Desktop
  60. Create HyperlinkObject on Sheet
  61. Displaying A Chart In A Userform
  62. Show Status on Userform While executing Code
  63. Automate File Download from Internet
  64. Display Userform with no Title Bar (Splash Screen)
  65. Saving userform in Excel as an image
  66. ActiveX Programming
  67. What’s New
  68. vbaX KB Links
  69. Copy Ranges from Different Sheets into one Sheet
  70. Free eBooks Online
  71. KB Articles
  72. Convert Case in Excel
  73. Junk Files
  74. Worksheet Functions
  75. Clear Controls on Userform
  76. Convert Decimal to RGB Color Value
  77. Get FileNames with Path from User
  78. How to use VBA code in Excel
  79. Creating a watermark in Excel with VBA
  80. Create LogFile for Workbook Open
  81. Export Chart as Image
  82. Sorting Text with Worksheet Formula
  83. Show Formula in a cell
  84. Create UserForm at Runtime using Code
  85. Userform Resizer – VBA
  86. — Downloads from www.jkp-ads.com
  87. — Files at www.zorvek.com
  88. — xla File & Project Analyzer
  89. — VbScript (Examples from www.Cruto.com)
  90. — DHTML/Ajax scripts
  91. Add Sheet Navigation control on ToolBar
  92. Archives

Leave a comment