Recent content by lambuhere1

Have you tried exporting modules and then importing them?

I think you need to call this macro when a particualr slide comes up or you can assign it to a button on the required slide to call this macro. Hope this helps Ram P

Search for ! in your workbook. You should be able to find all the listed links. Else you have a delete links addin from Microsoft which can do the work. Heres the link for it. http://support.microsoft.com/?kbid=188449 Thanks Ram P

Similar to the above requirement, I have something like this. All the links in my file have to a particular file like c:\abc\ I would like to replace it to c:\n\abc Can anyone guide me in replacng all the links with the new path. Thanks Ram P

Use old_path = activeworkbook.path ' to get the path which has the macro run. And use this to save your workbook. ActiveWorkbook.SaveAs FileName:=old_path + "\filename.xls" Hope this helps. Ram P

For i = 1000 to 1 step -1 if cells(i,1).value = "" then cells(i,1).select selection.entirerow.delete end if Next i Tweak this code to meet your requirements. Ram P

Pardon me. I was thnking it was XY Scatter chart.. Ram P

You can use Ctrl in combination with PageUp and PageDpwn to move between various worksheets of a workbook. Rob is right in using his VBA. Ram P

And as far as my knowledge goes, we don't have any concept called 3D Line plot. Let us know what you are trying to accomplish to help you with. Thanks Ram P

I prefer using Ctrl and Tab key combination to shuffle between various open workbooks. Isnt it great!!! Thanks Ram P

Yes, You can do it through VBA. Do send me the file and I can send you the code. Thanks Ram P ram.prakash@geind.ge.com

You can use something like this. In the command_button_click event of the MOTHER FORM, Use the following code. Motherform.hide Childform.show 'you may need to tweak the code depending on the names assigned to your userform. Hope this helps. Ram P

How about using Progressbar?

How about using Filesystemobject ?

You can select each individual Point to change the color you want to Hope this helps. Ram P