LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,090
Default FAX with Excel VBA

Excel XP, Win XP
Win XP has a built-in FAX capability so the user can send a FAX from his
computer. That's what I have. But I need to program in Excel VBA the task
of sending a range by FAX.
The following is a macro recorder recording when a FAX is sent manually
through Win XP. Obviously it needs work because, for one thing, the input
of the FAX number is not recorded. In my case, the range to send as well as
the FAX number are variables:
Sub Fax()
Application.ActivePrinter = "Fax on Ne04:"
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Preview:=True, _
ActivePrinter:="Fax on Ne04:"
End Sub

Can anyone offer me some guidance with this or direct me to some sources of
information? Thanks for your time. Otto


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 09:26 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"