Search results for query: *

hi all. I need to find the time taken by my program . The way in which i am doing this currently is by storing the start time and end time of the program and finding the difference. I want to know whether there is any specific commond to find the time taken. Any help is appreciated !!! - Arun

Hi I need to round real numbers to 3 decimal places . There is no function round is available in FORTRAN . How to do it ?

Hi , Now my requirement is , i should allow the user to select only a folder browsing thru a dialog box. I cannot use Browseforfolder since it doesnot provide the option to go back behind the starting path and also it doesnt remember the path of the last selected folder. I can use...

Hi PHV, But if i use browseforfolder option , it is not allowing the user to go above the starting path.Or we have to give nothing as starting path. In this case the user has to go thru the whole folder structure to select his folder. And one more thing it is also not remembering the path of...

Hi guys, Now the following is the code that i used to get the path of the folder that the users selects by browsing. It is workin fine in Excel 2003. But it is not in 2000. Can u suggest a solution ? 'Open the folder dialog With Application.FileDialog(msoFileDialogFolderPicker)...

Hi guys , I got the solution.Anyways thanks macropad. With Application.FileDialog(msoFileDialogFolderPicker) .AllowMultiSelect = False .Show End With fldr = Application.FileDialogmsoFileDialogFolderPicker).SelectedItems(1) 'Code to get the files available in the user...

Hi friends, I am a creating a tool in Excel using VBA. In that once the user click on "Load" button, the tool should allow the user to select the folder which contains the input files. By default the path of selection will be starting from Desktop. Now if i specify the (starting) path...

Hi guys, I need a help. I am tryin to delete a series from a chart. the problem is for that series xvalue is chosen from a cell and the cell is currently empty now.( note that it is none and not zero also). When i try to delete it using boht methods it is showing error. I tried using for...

Hi guys . I got the answer. on error goto errhandler Errhandler: Select Case Err Case 68, 75: ' Error 68: "Device not available" ' Error 75: "Path/File AccessError" MsgBox "There is an error reading drive B." End select End sub

Thanks combo. is there a way of displaying a msgbox when an error occurs.

Hi guys, I need a help. In my current work , i am encountering a situation such that if the user selects a wrong folder instead of the correct folder, my program is entering debugging mode and it is displaying error such that "Path not found". Instead of this i need my program to display...

Ha. Finally i found th solution for this and this is working. here temp = 19 ActiveChart.SeriesCollection(1).XValues = Worksheets("Summary Data").Range("T" & Temp & ":T20") And thanks a lot Mr. Skip for your effort to help me. - Arun

Nope. Still returns an error as "Series Collection" of object "_chart" failed.

Hi Skip, I tried ur code. It is Throwing error as Runtime error 1004 ."Method Cells of Object "_Global" Failed" . Any Idea ?

Hi friends, I am working with charts now.I have a variable now . "Temp = 19" In the following piece of Code instead of R19 , i have to make use of the variable "Temp" Something like R" & Temp &" ActiveChart.SeriesCollection(1).XValues = "='Summary Data'!R19C10:R28C10" What is the correct...

Hi jack, Do u want to save the workbook in the same name or do u need to get the name from the user using which the workbook has to be saved ? - Arun

Hi Skip , I think the idea enableevents = false and then do stuff and then enableevents = true is not working.I checked it now .Try this snippet , it is entering an infinite loop. The control is not at all reaching the line application.enableevents = true. Private Sub CheckBox1_Click() If...

Hi. A changed the logic in my program slightly and amazingly the program is working fine. Anyway thanks a lot for ur ideas Mr.taupirho.

Hi guys, I need a help.I am creating a tool in excel using VBA. There i have some checkboxes to initiate some actions. I have also provided a command button( Clear ) to clear that cases. The actions to be performed when the user switch on or switch off the checkbox is different. But if the user...

Hey i got the answer. we can use STRVAL = '0.5' READ (STRVAL,'(f3.2)') Floatvariable