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...

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

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

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...

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...

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...

I'm using three sets of listboxes, textboxes, and a commandbutton for each textbox. The PROBLEM: I can enter a value in the textbox, click the commandbutton and the listbox populates. BUT if I select an item from the listbox and then try to change the value of the textbox that decides what is...

I have nested a For / Next searching for value = 1. My question is How do I use the For / Next to search column 2 for values of 1 UNTIL the value in Column 2 = 0? The value of 1 may be listed 1 or more times in between a values of 0 in column 2. The design should list only the 1's that...

VB Forms: Do I have to code differently to place data on a Multipage (from toolbox) set on the second tab of another multipage? I am using the VB Form Control Toolbox. I have placed a multipage on the form with five tabs. On the first tab I placed a multipage with six tabs. On the second tab I...

I am using the multipage property form the control toolbox for userforms. The top of the page uses textboxes to read info from the spreadsheet. The four values: OptionCode, PartNumber, LetterState, and PartDescription. On the bottom of that page I'm using the multipage property. Its purpose is...

I know I can use the ControlSource Property in VB Userform to get a value from a cell on the spreadsheet. What I would like to do is have the code look through column A,find a specific NUMBER, and then place the set of data from that row into the VB Form. Is this possible to do? Thanks for...

I know I can use the ControlSource Property in VB Userform to get a value from a cell on the spreadsheet. What I would like to do is have the code look through column A,find a specific NUMBER, and then place the set of data into the VB Form. Is this possible to do? Thanks for any...

Is there a way to insert data into a text box field on a userform without the user typing it in?

Comparing cell values and replacing data I have a set of part numbers that have a version state listed on the same row in the worksheet. Example: ColumnA ColumnB ColumnC R155200 __________ D R155211 __________ B R155211 __________ C R168414 __________ A R168555 __________ C R168555...

Debugging... I've tried the following combinations WITHOUT success to Activate a named sheet from ECN Navigator.xls Workbooks(strECNN & &quot;D0_Face.xls&quot;).Activate Set f = ActiveSheet Workbooks(&quot;ECN Navigator.xls&quot;).Activate Worksheets(&quot;ECN Face Page&quot;).Activate Set...

I apprecaite the assistance... How would I copy: From Workbook A, Sheet 1, Cell A1 To: Text Box 1 on Sheet 1 of another workbook Thanks for suggestions, John

To clarify just in case it makes a difference...the textbox ECNN is from the control toolbox and sits on a worksheet. All of the modules running reports are just that...listed as modules. This is the code from the worksheet. Can I call the modules after opening the file, extract the data, and...

Current Scenario: I'm using drop down boxes to select a product number from the list. The number of items in the list will exceed 100. Prefereably I would like the user to be able to: 1) Enter the number into a Control Text box 2) When the user clicks a CommandButton the value entered is...