Search results for query: *

Is it possible to submit a request to MS Outlook from UNIX that launches "schedule a meeting" and places the attendee list in the meeting being scheduled? Example: Using sample data (below) which is available from UNIX and submitting the request from UNIX. Bob Jones <bjones@abc.com> Jim Smith...

I would like to read from C4 to L4 and verify if any of those cells has a value in it. If so, Then copy the value of B4 to AB4. If ActiveSheet.Range("C4") <> "" Then ActiveSheet.Range("AB4") = ActiveSheet.Range("B4") ElseIf ActiveSheet.Range("C4") = "" Then...

How is that used to move to the next row down from '[S350 T3 PLPDP.xls]Master Tracking'!R10C2" so that it selects the value in R11C2

Is there a method to use the following statement so that in a Loop it locates the next row down. example !R11C2, then !R12C2,...and so on? ActiveCell.FormulaR1C1 = "='[S350 T3 PLPDP.xls]Master Tracking'!R10C2

Thanks ETID. That worked very well!

I need to look down a column of data and verify the entry is a date. Thanks for assistance, John

I know how to link a spreadsheet one value at a time. example: ='[S350 T3 PLPDP.xls]Master Tracking'!$B$10 Is there a method to link all values in column B to my new worksheet rather than going one cell at a time? Thanks for the assistance, John

Thanks... that was easy.

I'm using this code to look up the column from a variable cell position. When I find the matching value I would like the Loop to End. r = 1 Do If .Cells(lngRow - r, 16) = strCode Then...

Thanks That worked! It's always the simple stuff. John

I recently upgraded from Acrobat 5.0 to 6.0 (Standard). I have VBA code the previously worked well in 5.0 to create postscript files. The code does not work as is for Acrobat Distiller 6.0. Code Being Used: Dim PSFileName As String Application.ActivePrinter = "Acrobat Distiller on...

When I run the first set of code that uses lastletter = I would get the following results in the work 2 column (1 to 8) I would like this number to continue up to 999, which would include enough "0" Level PartNumbers to be used. Level PartNum work2 0 RE523132 1 1 R519336 1 1 R85027 1 1...

Skip, Thanks for the reply. I apologize if I have not communicated thoroughly. Is it possible to use what you have only with the results be all numeric and then an example of alphanumeric lists of numbers in column A? Thanks again, John

The code below is used to place an identified value greater than the cell of the same column in the previous row if the values between the two other cells in each row are different. This works well when there is 26 or fewer different compariasons. (building A, B, C,... etc.) I'm looking for a...

Thanks Skip

Code used for Commandbutton, ListBox, and TextBox Private Sub CommandButton2_Click() optioncode_Search UserForm1.Frame2.TextBox12.Text End Sub Private Sub optioncode_Search(SearchFor As String) Dim rngFind As Range Dim strFirstAddress As String ListBox2.Clear...

Watch : : UserForm1.Frame2.ListBox2.ListIndex : -1 : Variant/Long : UserForm1.ListBox2_Change Watch : + : UserForm1.Frame2.ListBox2.List : <No Variables> : Variant/Variant(0 to -1, 0 to 9) : UserForm1.ListBox2_Change

I have the items added to the watches. What do I need to communicate to you from the Watches? by the way...thanks for helping. John

okay I figured out how to add watch

Skip, I haven't used the watch window before (hope you're not too surprised by that. Iclicked on watch window but I am unsure how to enter what you said to watch. John