<div>
Could you please give me an example... I tried this but it continues to place the information into the first cell. <br />
Here is the code that I am using. Could you tell me what I am doing wrong?<br />
<br />
SendKeys &quot;C:\MSOffice\YO Book Sheet.xls~&quot;<br />
DoEvents<br />
&nbsp;AppActivate retval<br />
SendKeys Text1.Text<br />
Text1.Text = &quot;&quot;<br />
DoEvents<br />
AppActivate retval<br />
SendKeys &quot;{F5}&quot;<br />
DoEvents<br />
AppActivate retval<br />
SendKeys &quot;($D$4)&quot;<br />
DoEvents<br />
AppActivate retval<br />
SendKeys &quot;{Enter}&quot;, True<br />
DoEvents<br />
End Sub<br />

</div>


Could you please give me an example... I tried this but it continues to place the information into the first cell.
Here is the code that I am using. Could you tell me what I am doing wrong?

SendKeys "C:\MSOffice\YO Book Sheet.xls~"
DoEvents
 AppActivate retval
SendKeys Text1.Text
Text1.Text = ""
DoEvents
AppActivate retval
SendKeys "{F5}"
DoEvents
AppActivate retval
SendKeys "($D$4)"
DoEvents
AppActivate retval
SendKeys "{Enter}", True
DoEvents
End Sub


<div>
Leave off the parens &amp;&nbsp;$'s on ($D$4) - feed as D4...<br />
<br />

</div>


Leave off the parens & $'s on ($D$4) - feed as D4...



<div>
<div class="content wysiwyg-content">
When the user enters specific information onto my application I need that information to be sent to a specific cell in &nbsp;Excel. How do I write the code fro this? I have been trying to find info on this type of problem for some time. I can get the worksheet to load and unload , even to print but I have no idea on the code to sent it to the required cell. Any answers?
</div>
</div>


When the user enters specific information onto my application I need that information to be sent to a specific cell in  Excel. How do I write the code fro this? I have been trying to find info on this type of problem for some time. I can get the worksheet to load and unload , even to print but I have no idea on the code to sent it to the required cell. Any answers?

entering input from VB forms to excel

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.