Search results

Dear Mukund.. Thanks a lot for your praise. Regarding your next question, please post it in a new thread. We will help you definitely

Dear Dronka I have just used "Mid Part" for reference. Here Mid Part is the filed of the pivot table. As per your confirmation, you are not so familar with VBA, so if you upload your file, i will do it and upload it for you.

Dear Mukund.. As i said earlier that, your format is not in standard (ranges and cell address) so i just modified the format by deleted blank rows. I am uploading the file for your reference. I created a button labeled as "Extract details", whenever you click that button, a new sheet will be...

Not clear... can you please elaborate more. So that other can get your idea

Dear Anamika Which excel version you are using, if you are using excel 2007 or above, then excel has built in function (filter by color) then you can select and count.

Dear Smallman Sorry for this... but in this forum, we need help and need to help. ;););)

Dear Anamika Sharma Please find below code for your reference. It is a UDF function. In Rcolor, just refer your font which is colored. In RRange just select your range in which colored font cells are there and lastone Sum, if you want to sum the values then just put TRUE otherwise FALSE, False...

Dear Dronka You can disable multiple selection option in Pivot Table through VBA. You can use below code to disable the filed selection pTbl.PivotFields("Mid Part").EnableItemSelection = False Please let me know whether it works or not. Here pTbl declared as Pivottable. And you can set it to...

Dear J.Steik As per your attachment, in sheet "Objective" in Column "D", contains four Ids i.e HD120,PQ120,L120G & WL430. In column "A" you have mentioned only one Id and in next cell you wrote second id and in next cell you wrote third Id. Is this correct way of your requirement like if in a...

Dear Bharath... I just want to know that, you want to call a procedure from a function or you want to call a function from a procedure? If you want to call a function from a procedure, then please put your function name in between sub and end sub Regarding first one, call procedure from...

Dear Mukund Vyas Please find below code, kindly copy and paste it in a module. I hope it will resolve your problem Private Sub ExtractDetails() Dim ws As Worksheet Dim cell As Range Dim i As Integer Dim PartyName As String Dim RefNo As String Dim RefDt As Date Dim...

Thank you somendra... that means whenever i want to paste the code, i need to type code(vb) and paste the code Is that right?

Sorry to all excel moderators, i don't know how to paste the code in this forum

Dear Mukund.... I think in your sheet, Format not standard, i mean to say item description range was differ in some of the sheets. If you are using standard format, then below code will work for you Sub ExtractDetails() Dim ws As Worksheet Dim cell As Range Dim i As Integer Dim...

Dear clmitche223 First of all, please upload a sample for better understand Next one is, i think you can update the data with the help excel built in functions like Vlookup, Index+match and other functions.

Dear Rahul Do you want to play a particular video from a excel file... like file name and it is hyperlinked with video file. So that you can play it from that excel file Is my understand is right? or you want to play the video in a frame like in powerpoint presentation.

Thank you so much shri... :) for your suggestion. I will try and explore these references too.

Dear Nagovind This problem appears due to hidden range names. So if you delete hidden range names from your workbook, then it will resolve your problem http://support.microsoft.com/kb/119826

Hi shrivallabha... I learn new concept or you can say new way to get rid of this. Thank a lot for sharing this new way with us. I never used Shell.application object. So i will practice this new object

Please upload a sample file...

Dear Abhijeet Just declare one variable - dim fldPath as string (to hold selected folder path) then before set my folder paste the below code Application.FileDialog(msoFileDialogFolderPicker).Show fldPath = Application.FileDialog(msoFileDialogFolderPicker).SelectedItems(1)

In Luke M code just changed dim fso as object to dim objFSO as object It will work...

Dear vipin, I don't know what is your structure, but i just created a dummy data and save it as text file. Please have look on below macro Sub CreateText() Range("A1").CurrentRegion.Copy Application.Workbooks.Add Worksheets.Add ActiveSheet.Paste ActiveWorkbook.SaveAs "C:\users\vijay...

Can you create dummy file with same structure ? You told that you are manually copy and paste it in notepad to save it as text file. How much range you are copying and what are the contents. Please let me know

Dear Vipin, It can possible by VBA. But can you please upload a sample file along with one example. So that other members can resolve your problem as soon as possible