Home Products Tips VBA FAQ Utilities Licensing Disclaimer Privacy Policy Links

PowerPoint VBA Section

The PowerPoint VBA section contains VBA code that can be used in Microsoft PowerPoint. They present some programming techniques to solve particular problems.

PowerPoint HowTo Section

Automating PowerPoint from Visual Basic

Automating PowerPoint from JavaScript, Visual Basic and Delphi

Office VBA Section

The Office VBA section contains VBA code snippets that can be used in any Microsoft Office products. They offset the routines available in the VBA environment.

  • Position VBA user forms using pixels.
  • UniquifyStringArray - A function to remove duplicates from a string array using a Collection.
  • GetFileCreator - Code snippet that uses DSOFile.dll to retrieve the application name that created the document.
  • IsClipboardEmpty - Code snippet to demonstrate how to find out if clipboard is empty or not.
  • ClearClipboard - Code snippet to clear clipboard.
  • CreateShellShortcut - Code snippet to demonstrate how to create Shell Shortcuts in VBA using Windows Scripting Host.
  • ForceMkDir - A recursive routine that creates all folders along a path if they do not exist.
  • ShowFileOpenDialog - Uses Common Dialogs to show the standard file open dialog box.
  • Upload File Using FTP - Code snippet to demonstrate how to use Microsoft Internet Transfer Control to upload a file using FTP protocol.
  • Download File using FTP - Code snippet to demonstrate how to use Microsoft Internet Transfer Control to download a file using FTP protocol.
  • Download File using HTTP - Code snippet to demonstrate how to use Microsoft Internet Transfer Control to download a file using HTTP protocol.
  • Check if File Exists using HTTP - Code snippet to demonstrate how to use Microsoft Internet Transfer Control to check if a file exists using HTTP protocol.

Copyright © 2001-2009 OfficeOne. All rights reserved.

free hit counter