Search results for query: *

I am trying to open a document and retrieve some info from it and place it into excel. The file name would be 9005-607.doc or something like that, and i want it to search through the file till it finds the sentence seq # 20 and then i want it to put anything that starts with 2100 or 2000 to be...

I have to questions. When i have a user form open on one of my woorkbooks why can't i switch to a different workbook? How do you use vb to close a workbook? Thanx :)

Is there a way to select an option button when hit a regular button? by using Optionbutton2.activate it will select the option button but it won't avtivate it or put the little dot in it

I am having trouble figureing out how to use a user form... I made a user for called nortech and i have an ok button called ok and cancel button called cancle. I also have a text box called textbox1. I want what is typed in the text box to be put in a cell (for ex c4) when the ok button is...

Whats wrong with my code :( Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Selection.Count = 1 Then If barcode = "on" Then If Selection = Range("d8") Then Range("d8").Value = (InputBox("Scan or Type Assembly Part Number", "NORTECH...

Is there a way to find out the current day of the week using excel or vba?

I am trying to get excell to send information to a program called Visual Manufacturer. Is there a way to use the sendkey command? Or is there a different way that may work better? Like if i wanted to send 7091 and the enter key to the program.

When using an input box, If the user hits the cancel button instead of leaving what is currently in the cell, it clears it. Is there anyway around that? Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Selection.Count = 1 Then If barcode = "on" Then If Selection =...

I have only programed in c++, so I know this may sound like a dumb question, but how and where do you declare a local or global variable? THANKS

Range("B10").Value = (InputBox("Scan or Type Assembly Part Number", "NORTECH SYSTEMS INC.")) Can i make that input box display without a cancel button? And if so can i also make it with out an ok button, so it just waits for the user to hit enter?

Is there a way to have excel only let the user select one cell at a time? The code I have displayed below, gives me an error everytime a user selects more than one cell at a time..... Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Selection = Range("b10") Then...

I am trying to export information from a cell to and application. I know you can export info to a text file, channelNumber = Application.DDEInitiate( _ app:="WinWord", _ topic:="C:\Program Files\Microsoft Office\Office10\test.doc") Set rangeToPoke =...