Recent content by sreekhosh

Hi Deepak, Its works fine for me. thanks a ton Sreekhosh.AP

Hi, How to format the Height and width of the chart. (chart is pasting from excel to word). Sub ChartsToWord() Dim WDApp As Word.Application Dim WDDoc As Word.Document Dim iCht As Integer Dim Msg As String Set WDApp = CreateObject("Word.Application") Set WDDoc = WDApp.Documents.Add...

Great Thanks a ton. :)

Dear Deepak, I have asked this doubt one year before. I am very glad to see your reply after one year, however the link you provided is not satisfying my query. I need to add a Range and a chart to email body for sending (not as attachment). But its not possible for me and I add the range...

Fuzzy Lookup is working fine for me. Thanks a ton for the wonderful information. Sreekhosh

Guys thanks for your reply, @Somendra: Great formula, but still not working in all cases Eg: Row No (3),(7). @Deepak: Will install it and check. thanks Sreekhosh

Hi, Please see the below table and advise how to do the vlookup if the values are partially matching. Regards Sreekhosh

Hi Hui, Thanks for the reply. My actual issue is this. http://www.accessforums.net/programming/error-attempting-export-data-ie9-26092.html But i couldnt solve it Regards Sreekhosh

Hi All, I am trying to export and excel report from a website. Website is opening with the report but i am receiving a run-time error '2147467259 (80004005)': Method Document of object 'IWebBrower2' failed. I am using Internet Explorer 9 Here is my code. Dim ipf, ie As Object Dim path...

Hi BD, thank you so much. it helps lot Regards Sreekhosh

Hi, When i am trying to sort the subtotaled data, excel prompts me to remove the subtotaling. Is there any way to sort the data after subtotaling. I am looking for macro to do the same. In my data i need to sort the revenue in descending order. That means high revenue earning Parent company...

Hi SirJB7, Thank you for the effort. but i got Runtime Error '1004' Method range of object Global failed. Regards Sreekhosh.

Thanks Kanti, I also tried the same. But is there any way to do the same with out repeating table name (ie: "Table1"). Thanks Sreekhosh

Hi, I have a table containing more than 10 Headers. How to select and copy multiple headers at a time using macro. I need to copy below Headers from my table. Account Name, Cleint Name, Eng Number, Revenue. I am using below code for selecting single column header, Range("Table1[Account...

Thank you Hui...I think if we are arranging our data in Descending order, Column Chart is More Conveyable. Regards Sreekhosh