Search results for query: *

You can add the Data in code by using: Use List to copy an entire two-dimensional array of values to a control. Use AddItem to load a one-dimensional array or to load an individual element. Example: ComboBox1.List() = MyArray or ComboBox1.AddItem "Test" Just have a look in the...

If you just want a list of directories / files print you could try using this at the command prompt. Dir C:\ >> Lpt1 Where C:\ is the directory you interested in and Lpt1 is where your printer is mapped to.

bsimm, It looks like your problem has been solved but I would just like to add this bit of knowledge. You can use: Application.GetOpenFilename This will launch the standard Open Dialog box for the user to select a file. Example: MyFilename = Application.GetOpenFilename Workbooks.OpenText...

Try putting this at the beginning of the Sub: Selection.Activate If that doesn't work can you paste your code so we can have a look at it.

You need to use something like this: Worksheetfunction.HLookup("Axles",sheets("NameofSheet").Range("A1:C4"),2,true) if you look at Worksheetfunction you will see that it has all the functions you can use in a excel.

Filesystem.FileDateTime

What version of excel did you write it in? What version of excel are you opening it in?

that was supposed to say "Make sure you are NOT just hitting play!"

How are you running this macro? It works for me. Make sure you are just hitting play. The sheet must be active otherwise the Sendkeys will be run on what ever has focus.

Why are you using Goto?? Why aren't you using a proper loop??

ETID, You will need to use an array formula so that you can specify more than one criteria. I can't seem to get the Count array formula to give me the right results at the moment. You can cheat and use Sum array formula but it means you will need to add a column with ones in. Here is the...

You could just use this bit of code: Private Sub Document_Open() ActiveWindow.View.SplitSpecial = wdPaneComments End Sub Place this in the VBA Project for the document. This would show the Comments pane when the file is opened. Or you could use code to change the options as dianemarie...

You can just goto Insert-Comment. Then to view comments you goto View-Comments.

Okay here is an example: I hope this is clear. The basic idea is to use the Ontime function to check the current value every second. I have done this by placing the Ontime function call inside the procedure it calls. I have a sheet called "BIDS". I have added two Modules to the VBA...

Okay I have more of an idea what you are trying to do. How is the data updated? Is it done through code? The reason I am asking is there are a couple of ways of doing it. 1. If data is updated via some other code you can add a simple bit of code to copy the value before updating. 2. Have a...

Example: You have created a userform called "FrmTest" You want this to be displayed when the workbook is opened. Code is this: Private Sub Workbook_Open() FrmTest.Show End Sub

Look at Type Conversion Functions in the help. You might find what you are looking for in there. CBool(expression) CByte(expression) CCur(expression) CDate(expression) CDbl(expression) CDec(expression) CInt(expression) CLng(expression) CSng(expression) CVar(expression) CStr(expression)

In answer to question one: Do a keyword search on this Forum for "COUNTIFK" You should find one thread. It contains some code I wrote and an excel way which should work. Let me know if you can't find it.

Can you explain exactly what you are trying to achieve. Can you give an example. When do you run this Function? Is it in a loop?

This site might help you a bit. http://www.microsoft.com/officedev/articles/Opg/012/012.htm To display the form use this code: FormName.Show