Open .pdf or anything else by clicking button as a help popup

Hi, (sorry for my english) (Quebec, canada)

I made a .xls program with a lot of macros to events beetween the sheets. Instead of writing a help-guide in a other sheet, i would like to make a .pdf (or something else) and open it by clicking on a button (placed somewhere on the sheets) just if it was a kind of help (with the scroling vertical bar to see all the contents).

Thank for helping.

Comments

  • : Hi, (sorry for my english) (Quebec, canada)
    :
    : I made a .xls program with a lot of macros to events beetween the sheets. Instead of writing a help-guide in a other sheet, i would like to make a .pdf (or something else) and open it by clicking on a button (placed somewhere on the sheets) just if it was a kind of help (with the scroling vertical bar to see all the contents).
    :
    : Thank for helping.
    :
    YOu need a API function, called ShellExecute. Now I don't have the list of variables you need, but if you search with google you can find some internet pages with the descripition of the page (it's a very used API. you'll find it everywhere) or look directly at two programs: API Guide and API Viewer. The first is a list of functions types, enums, ... bat has no description, the second is less complete but has an explanation for every API memorized, the parameters, ...
  • Now I have the documentation about the ShellExecute function:
    Description:
    The ShellExecute function opens or prints a specified file. The file can be an executable file or a document file.
    Declaration:
    [code]Declare Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" (ByVal hwnd As Long, ByVal lpOperation As String, ByVal lpFile As String, ByVal lpParameters As String, ByVal lpDirectory As String, ByVal nShowCmd As Long) As Long[/code]
    Parameters:
    hwnd
    Specifies a parent window. This window receives any message boxes that an application produces. For example, an application may report an error by producing a message box.

    lpOperation
    Pointer to a null-terminated string that specifies the operation to perform. The following operation strings are valid:
    open
    The function opens the file specified by lpFile. The file can be an executable file or a document file. The file can be a folder to open.
    print
    The function prints the file specified by lpFile. The file should be a document file. If the file is an executable file, the function opens the file, as if open had been specified.
    explore
    The function explores the folder specified by lpFile.

    The lpOperation parameter can be NULL. In that case, the function opens the file specified by lpFile.

    lpFile
    Pointer to a null-terminated string that specifies the file to open or print or the folder to open or explore. The function can open an executable file or a document file. The function can print a document file.

    lpParameters
    If lpFile specifies an executable file, lpParameters is a pointer to a null-terminated string that specifies parameters to be passed to the application.
    If lpFile specifies a document file, lpParameters should be NULL.

    lpDirectory
    Pointer to a null-terminated string that specifies the default directory.

    nShowCmd
    If lpFile specifies an executable file, nShowCmd specifies how the application is to be shown when it is opened. This parameter can be one of the following values:
    SW_HIDE
    Hides the window and activates another window.
    SW_MAXIMIZE
    Maximizes the specified window.
    SW_MINIMIZE
    Minimizes the specified window and activates the next top-level window in the Z order.
    SW_RESTORE
    Activates and displays the window. If the window is minimized or maximized, Windows restores it to its original size and position. An application should specify this flag when restoring a minimized window.
    SW_SHOW
    Activates the window and displays it in its current size and position.
    SW_SHOWDEFAULT
    Sets the show state based on the SW_ flag specified in the STARTUPINFO structure passed to the CreateProcess function by the program that started the application. An application should call ShowWindow with this flag to set the initial show state of its main window.
    SW_SHOWMAXIMIZED
    Activates the window and displays it as a maximized window.
    SW_SHOWMINIMIZED
    Activates the window and displays it as a minimized window.
    SW_SHOWMINNOACTIVE
    Displays the window as a minimized window. The active window remains active.
    SW_SHOWNA
    Displays the window in its current state. The active window remains active.
    SW_SHOWNOACTIVATE
    Displays a window in its most recent size and position. The active window remains active.
    SW_SHOWNORMAL
    Activates and displays a window. If the window is minimized or maximized, Windows restores it to its original size and position. An application should specify this flag when displaying the window for the first time.

    If lpFile specifies a document file, nShowCmd should be zero.
    Return values:
    If the function succeeds, the return value is the instance handle of the application that was run, or the handle of a dynamic data exchange (DDE) server application.

    If the function fails, the return value is an error value that is less than or equal to 32. The following table lists these error values:
    0
    The operating system is out of memory or resources.

    ERROR_FILE_NOT_FOUND
    The specified file was not found.

    ERROR_PATH_NOT_FOUND
    The specified path was not found.

    ERROR_BAD_FORMAT
    The .EXE file is invalid (non-Win32 .EXE or error in .EXE image).

    SE_ERR_ACCESSDENIED
    The operating system denied access to the specified file.

    SE_ERR_ASSOCINCOMPLETE
    The filename association is incomplete or invalid.

    SE_ERR_DDEBUSY
    The DDE transaction could not be completed because other DDE transactions were being processed.

    SE_ERR_DDEFAIL
    The DDE transaction failed.

    SE_ERR_DDETIMEOUT
    The DDE transaction could not be completed because the request timed out.

    SE_ERR_DLLNOTFOUND
    The specified dynamic-link library was not found.

    SE_ERR_FNF
    The specified file was not found.

    SE_ERR_NOASSOC
    There is no application associated with the given filename extension.

    SE_ERR_OOM
    There was not enough memory to complete the operation.

    SE_ERR_PNF
    The specified path was not found.

    SE_ERR_SHARE
    A sharing violation occurred.

    I think this is all I can do for you.
    Good luck
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

In this Discussion