Archive for Tutorials

Archives

November 16, 2008 at 20:22 · Filed under Automation, Charting, Downloads, Formatting, Tutorials, Userforms, VBA, VBA Advanced, VBA Code Library, VBA Examples

  1. ActiveX Programming
  2. Add an Image to Cell Comments
  3. Add Sheet Navigation CommandBar to an Excel file or Application
  4. Auto-Generate a File Name
  5. Automate File Download from Internet
  6. Automate WebLogin…
  7. Convert Decimal to RGB Color Value
  8. Copy Ranges from Different Sheets into one Sheet
  9. Create HyperlinkObject on Sheet
  10. Create LogFile for Workbook Open
  11. Create Sheet “Table of Contents”
  12. Create ShortCut Link at the desired location
  13. Create UserForm at Runtime using Code
  14. Display Userform with no Title Bar (Splash Screen)
  15. Downloads
  16. Downloads from www.jkp-ads.com
  17. Export a Text File with Comma and Quote Delimiters
  18. Get elements from HTML form
  19. Get FileName with Path from User
  20. Get FileNames with Path from User
  21. Hyperlink Elements in HTML
  22. Ken’s Knowledge Base submissions
  23. Login to Rediffmail
  24. Move a File
  25. Multiple Cell Concatenation
  26. Other Site Links
  27. Read CSV Using VBA techniques
  28. Remove Unprintable Character & Spaces from cells
  29. Rename a File
  30. Rename Files using Codes (VBA)
  31. Resources
  32. Resources
  33. Search Folders and Subfolders for files
  34. Show Status on Userform While executing Code
  35. Site Contents
  36. socko.wordpress.com — Technorati Search
  37. Sort WorkSheets by Name
  38. Sorting Text with Worksheet Formula
  39. test
  40. Use of vbScript in Database Applications
  41. Userform Resizer – VBA
  42. Userforms
  43. VBA Code Library
  44. vbaX KB Links
  45. Verify that a File Exists
  46. Web Forms manipulated by Visual Basic
  47. Write to & Read from Sequential Text Files

Leave a Comment

ActiveX Programming

September 7, 2008 at 20:38 · Filed under Downloads, Tutorials

Selva V Pasupathy, HSBC Global Resourcing, Hyderabad

ActiveX Programming Unleashed

Table of Contents

Chapter 1 – An Overview of ActiveX
Chapter 2 – OLE Components
Chapter 3 – Creating COM Objects
Chapter 4 – Creating OLE Automation Server
Chapter 5 – OLE Controls
Chapter 6 – Creating OLE Control Containers
Chapter 7 – Microsoft Internet Explorer 3.0 and Its Scripting Object Model
Chapter 8 – VBScript
Chapter 9 – JavaScript
Chapter 10 – Using Microsoft FrontPage
Chapter 11 – Using ActiveX Control Pad
Chapter 12 – Advanced Web Page Creation
Chapter 13 – Windows CGI Scripting
Chapter 14 – ISAPI Server Applications
Chapter 15 – ISAPI Filter Objects
Chapter 16 – Internet Database Connector
Chapter 17 – Microsoft ActiveVRML
Chapter 18 – OLE Document Objects
Chapter 19 – Hyperlink Navigation
Appendix A – Internet Explorer 3.0
Appendix B – Microsoft Internet Explorer Logo Program
Appendix C – Microsoft Visual C++ 4.1 and 4.2
Appendix D – Visual J++
Appendix E – ActiveX Template Library
Appendix F – HTML Enhancement by Internet Explorer 3.0

 

Comments (1)