View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default VBA to VBA Script Function

I think you are looking at using variables in your macro such as

myvalue=range("a2").value
msgbox myvalue

Perhaps if you posted your code and requirements.

--
Don Guillett
SalesAid Software

"Danny Young" wrote in message
...
Hello:

An answer to one of the following would be greatly appreciated.

(1) I am trying to send data to a specific location in a VBA script from a
cell on its respective spreadsheet.
Is this possible?
If so, how?

(2) If not, is it possible to send data from a cell on a spreadsheet to a
DOS Batch File?
If so, how?

(3) Is it possible to create a Macro that records the actions in the VBA
Script Editor?
If so, how?

I am trying to pass data from a cell to a VBA Script, which is a mailing
program for Novell Groupwise; I need to allow input of different e-mail
addresses, messages, and subjects.

As I am fairly new to VBA I would appreciate layman's terms, if that is
possible.

Again, any help would be greatly appreciated.

Thank you,

Danny