Recent content by ed_metcalfe

  1. E

    Inputbox

    Ben, If you want to stick with using an input box let me know what format you want to ensure the entry is in and I'll write a bit of code that will validate the entry for you. Ed Metcalfe.
  2. E

    Variable Scope.

    Anybody any idea what the difference between a Global variable and a Public variable is? As I understand it: Dim - available only within the current procedure Private - available to all procedures in the current module Public - available to all procedures in all modules Global - available to...
  3. E

    Handling Lotus Notes Via VBA

    Mr. Tibbs, Enjoy the code. It is quite useful. I can't find any way of reading the state of the auto-spellchecker. That's my problem. I'm using Notes 5.08. Ed Metcalfe.
  4. E

    Check if a directory exist and create a directory

    And seems as this is an Access/VBA forum I thought the answer would answer itself really! Ed Metcalfe.
  5. E

    Check if a directory exist and create a directory

    Damn, not quite right. I'll try again: Public Sub CheckDir(strDirectoryPath As String) If Dir(strDirectoryPath)="" Then MkDir strDirectoryPath End if End Sub Ed Metcalfe
  6. E

    Check if a directory exist and create a directory

    To find out if a directory exists: If Dir(strDirectoryPath)<>"" Then True Else: False End if To create a directory: MkDir strDirectoryPath Therefore this should do what you want: Public Sub CheckDir(strDirectoryPath As String) If Dir(strDirectoryPath)<>"" Then MkDir...
  7. E

    Handling Lotus Notes Via VBA

    I have the following code which sends an email from a Lotus Notes email account: Public Sub SendMail(strAddressee As String, strSubject As String, strBody As String) Dim objNotesWS As Object Dim notesdb As Object Set objNotesWS = CreateObject("Notes.NotesUIWorkspace") Set notesdb =...
See more
Back
Top Bottom