Search results for query: *

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

You need to check the Excel Reference in Tools-References in your VBE mode. And when the user presses a Button on the form in Access you need to call in Excel Application and that particular workbook with your sheet of interest activated. Hope this helps. Ram P

You can use Set copy_range = Sheet4.Range("A4:c19") and use it in your Power Point Paste Mode. I dont think you need WORD Interface... It takes more of your computer resources.

You can try tweaking the following code to meet your needs. I use the following code to copy each chart onto each slide on a blank Power Point Presentation. I hope you can make the changes to meet your requirements. Note that the charts in Power Point are NOT linked to the charts in Excel. For...

I presume you need to store your macros in Personal.xls to use them in XL Application.

You need to call Power Point application and then export the data from the sheet to the powerpoint slide. Check the references for Microsoft Power Point Object 9.0 Library in Tools ->References in VBA. Ram P