Fax Software

Community Forums

  • This topic is empty.
Viewing 6 posts - 1 through 6 (of 6 total)
  • Author
  • #2748

    Is there a Visual Basic for Application macro that can be placed under a button in Excel and that will fax a designated Excel file to a designated fax number, with out any other intervention from the user? Assuming there is an installation of WinFax Pro v10 under Windows 2000 or XP.

    Thank you


    There is a Symantec macro available to fax an Excel document.

    WinFax PRO 10.0 Symantec Corporation
    Excel 95/97/2000/2002 Macro Installation Notes October 2001

    In most cases the macro installer will copy the appropriate Add-In
    file to your Excel library folder. You then simply have go to the
    tools menu, click Add-Ins, and activate the WinFax Macros. If the
    macro installer fails to copy the Excel Add-In file to your Excel
    library folder, then you must to follow the directions below to
    complete installation of the WinFax macros.

    Installing Macros:
    1. Locate the appropriate WinFax macro file for your version of
    Excel. Copy the WinFax macro file into your Excel Library folder.

    Note: All WinFax macro files are stored in the MACROS
    subfolder of your WinFax installation directory. By default,
    this directory is PROGRAM FILESWINFAXMACROS.

    Version Macro File Default Library Location

    Excel 2002 WFXL2002.XLS Program FilesMicrosoft OfficeOffice10XLStart
    Excel 2000 WFXL2000.XLS Program FilesMicrosoft OfficeOfficeXLStart
    Excel 97 WfXXl97.XLA Program FilesMicrosoft OfficeOfficeLibrary
    Excel 95 WFX7_XL7.XLA Program FilesMicrosoft Office95Library

    2. Start Microsoft Excel.

    3. If you are using Excel 97, open the WFXXL97.XLS file
    located in the WinFax macros subdirectory, select INSTALL macros,
    and follow the instructions on the screen.

    4. For Excel 95, install the macro file as a Microsoft Excel
    “add-in”. Click Add-Ins on the Tools menu, enable the appropriate
    macro, and click OK. Excel installs the add-in and adds the WinFax
    command to the File menu.

    For more information about installing add-ins, see your Excel


    That I know. What I don’t know is how to whrite a macro that will take care of the faxing with out any other user intervention (except to click one button). Do you know where I could get/buy a VB for apps code that will do that?
    Thank you


    I don’t believe there is anything like that already written. What are your requirements for this macro? Does it have to fax a specific Excel type file? or various files of various sizes/pages etc? Is the fax number always the same, or do you require to get the fax number from database?


    The macro should send a specific regular Excel file “c:my documentsbook1.xls” to a specific fax number “13235551212”
    The best way will be if the macro could pickup the fax number from a cell in the spreadsheet, where I will have the desired fax number for that particular spreadsheet. Then I don’t have to type every single fax number in a separate macro.
    As for the book1.xls, I can just call it “ActiveWorkbook”.
    Could you please do this for me? I would like to use paypal.com as form of payment.
    Thank you


    Did you ever get the answer and can you post it. Thanks

Viewing 6 posts - 1 through 6 (of 6 total)
  • You must be logged in to reply to this topic.