Search results

Gulshan, If you need the whole file during presentation you can use INSERT OBJECT (inserting as embedded object) in the excel. Insert --> Object-->Create from file-->browse for excel file--> Check Display as icon.

Its windows XP and Excel 2007 version i am using

Dear experts, My macros are retrieving data from other excel file and the file is linked to other excel file in share point site. When i just retrieve data from other excel file that particular tab will have issue in scrolling to left/right/up/down. If i export it to access and then again to...

Hi, The pivot table that i have created always sort either in ascending or descending order.i have to retain the same order that i have in my source data.Can anyone help me on this pls... Thanking you in advance, Dee...

Hi Xld, Your code will be perfect if i copy and paste continuous columns(series of column) say from A to E but in my case i will be selecting columns randomly ie., a,C,F,H,K ... so i though of giving input box to select sheet,source column and destination column. Thanks, Dee

Hi Guys, Below is the code which i am trying to copy column from one sheet to another by using input box.What missing in this is, its copying only from the default opened sheet. I need to give input for sheet also similar to source and destination column via input box or any other way. Can...

Hi Guys, Basically i am trying to calculate the volume and the input for this is in 4 columns ie.,input for length(L),width(W),depth(D) & diameter(Dia). Requiremetn is, If input for "L","W" & "D" is given then it should not allow user to enter value in "Dia" cell. Similarly if input is...

Hi Hui, Thank you very much...Its exactly suits my requirement with minimum editing. Dee

HI HUI, Thank you very much for your quick reply.This is exactly what i was looking for. Basically i was trying to browse for the picture files to copy and paste it to the excel file. Can you please help me with some smart code for the same? Thanking you in advance, Dee

Hi Guys, I am using the below code to search for an excel file.Can any one of you suggest the code to get the image/picture files (jpeg,jpg,bmp files for example)in the similar pattern? Flatfilename = Application.GetOpenFilename(FileFilter:="Excel files (*.xls), *.xls", Title:="Please...

Hi, Thanks for your quick response. I tried with defining destination cell as variable but no luck :( Its giving "compile error", "User-defined type not defined". Dee...

I am trying to copy few columns using input box and paste it in the destination cells/range using inputbox. In the below code i am unable to paste it in the destination cell as i am getting "Run time error '438'","Object doesn't support this property or method". my codes Sub DFMA_MAKE() Dim...

yes, exactly.... is there any other way(rewriting macro by taking any examle) to get what i wanted? pls suggest

Hi guys, In the below macro i am trying to copy the contents of one file to another file.Here i am trying to refer to the sheet and the column through input box and also the destination cells/column using input box.But getting error at referring destination cell.Can any one of you help me in...

I have big list of tools which will be selected using check boxes. Now i want the list of only selected checked boxes(the consolidated selected tools). I think this may work using macros. Can anyone help me on this pls... Thanking you in advance, Dee

Hi hui, The date represent the completion of that particular phase. The end date of phase 1 will be the start date of phase 2. It's exactly the same what i am looking for... Thank you very much

Hui, As i am unable to access those sites(at present) i am giving snapshot of the pivot table below.For some date is blank as the project is still in previous phase.Info that i need to retrieve are how many came in,how many went out of each phase,Prj manager's name,project name,ID#. ID #...

Hi,Thanks for your quick reply. I tried this, but not working. Each stage date is in different column.I need know how many crossed that phase and how many came into that phase wihtin that range.

I have list of project from which i have created pivot table to give the exact date each stages of the project. I need to extract the details of the projects between two date range(for ex: from 1st Nov 2009 to 30th Nov 2009)if they have passed any stage in the period. Thanking you in advance, Dea

I tried the following macro to track the changes. But this will capture all the changes made in the workbook. I want only the changes which happened in only in column EK, EM & EO of one sheet. your help on this will be greatly appreciated...

Hi All, Is there a way to track the changes that we made in particular cells in the workbook containing pivot tables? Track Changes option in excel is not highlighted in the workbook in which i am working. I used below codes to get the same (recorded macro :)).It is also not working for...

Thanks for this. But i tried all these things but still i am not getting the reason why i am getting this error Dee...

Sorry i have not highlighted the error row The error i am getting is in 13th row ie., ***ThisWorkbook.Worksheets("Project Managers").Activate*** Thanks,

Dear All, I am getting the following error "Index refers beyond end of list" in the row presented within astricks (***)when i try to run this macro. I have two tabs called 'Project Managers' & 'Project List' in the file and at present i have only 4 names in Project Managers tab. The will grow...

Hey! Thank you very much. Dee..