Search results for query: *

I am attempting to define a 2 dimensional, variable array (in terms of size). The number of items given in response to an inputbox will determine the size. For each item I would like to enter a price and volume, compute the price per volume (perform a division) and return the coordinate pair and...

From Eytch, I am trying to establish several "Cases" here where MyValue falls within certain ranges of values. That is why I thought using select case statements would be appropriate. Thanks Again.

I want to express the "Case" where MyValue is greater than or equal to 0.5 or less than 5. Why wouldn't this work? Select Case MyValue Case 0.5 >= MyValue < 5 Thanks to All, Eytch

Select Case MyValue Case >= 0.5 0r < 5 Could someone tell me why my Or statement doesn't work? Thanks, Eytch

Hello, I would like to write a routine that allows entry of the system time and date in a cell and then after an elapsed period of time of the users discretion add to an adjacent cell the system time and date in a different color font. Any Suggestions? Thanks, Eytch

I have long since forgotten how to make an excel file executable. I can't find what I'm after in "help". Any suggestions for the best way to protect my excel VBA code from viewing or editing? Would saving it as an executable file do the trick? Thanks, Eytch

I created files on my computer several months ago (within a year) and saved them to a 3.5 inch disk in the A drive. Now, when I try to access them I get a message that the disk has not been formatted. Can you tell me why this is occurring and how I can access the files I know exist on the disks...

Do Do . . . Loop While E9 = E12 Loop While E10 = E11 Working in Excel how would I incorporate both conditions into one DoWhile Loop? What is the proper syntax to get something such as the following to work: Do . . . Loop While E9 = E12, E10 = E11 Thanks, Eytch

I get the following message when I run my program, any suggestions why? java.sql.SQLException[Microsoft][ODBC Microsoft Access Driver]Syntax error in FROM clause. Thanks, Eytch

When I compile my tester program I receive the following: Note: Recompile with -Xlint:unchecked for details. Tool completed successfully Can anyone tell me how to set this unchecked for details? Thanks, Eytch

How do you copy the output generated by an Excel macro to a new file without including the macro that generated the output? Thanks, Lakefish

fumei, The macro I wish to make unavailable was created in Excel. Could you give give an example or reference to having the code write output to a new file? Thanks, Lakefish

I don't want my code available to users only the output generated by virtue of executing the macro. What is the easiest means of disseminating the output without passing on the macro code that generated it? Thanks, Lakefish

I want to copy a selected range of cells to other sheets using the FillAcrossSheets method. What I have tried below in my macro does not work. I know the FillAcrossSheets method has a defined range in the help example, .Range("A5,B9") as the suffix. How do I get it to work when I want the...

I want to have the user enter a date to an input box in the format "01/01/05". Set myDate = Application.InputBox(prompt:="Enter the first day of the Month, mm/01/yy", Type:=0 + 1 + 2) Can anyone tell me the Type setting to use so that I may assign the value input to a cell as the myDate...

I used a selection statement to define a range using cells. Now that I have the column of cells comprising the area selected I want to format the first cell a date and autofill the remaining cells with successive days of the month. The area was defined using cells in the range statement...

Can anyone tell me the code to use to close an applet by clicking an exit button within the applet. System.exit(0); does end the program. Thanks, Tripoli

I want to right justify the data in an integer field and also in a double field. My program is from the command prompt. It is not an applet. I know it is possible if these were strings by way of setting the length to a given value but I am using integer and double here. Any suggestions...

I would like to set all data in a field right-justified. Is there a way of defining the field size in Java or right-justify the data in the fields of a report? Thanks, Tripoli

I want to be able to replace any array value specified by user input with a replacement value also specified by user input. How do you compare the keyboard input of a character to the literal value occupying an array position? If array[1]= '2' how do I first find all instances of positions with...