[rpuser]

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
RP

[Anonymous]

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
documentation.

[rpuser]

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
RP

[Anonymous]

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?

[rpuser]

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
RP

[Anonymous]

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

[Author]

Posts