[chatty]

Instead of using “insert names>define” to define wfxFaxNum, wfxRecipient etc, can the winfax macro be modified so that the program looks for a cell and uses the number or name in that cell?
EG if I put the fax number in cell N6 and the recipient number in O6.

[Administrator]

Yes, it can be done.

Excel uses a Cell(Row,Column) command to specify a cell. so something like this would read the contents the cell at Row , Column into the variable sFaxNumber.

Dim sFaxNumber As String
sFaxNumber = Cells(A1,A1)

so sFaxNumber contains the fax number now, and you would send this information to WinFax using the SDK method.

Here is another method
http://www.ozgrid.com/forum/showthread.php?t=11530

[Author]

Posts