Search results

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

Thanks Oldchippy, But Jon Peltier's suggestion is not allowing me to go with Pie. Regards Sreekhosh

Hi, My data consisting of 4 country's revenue. Which chart is best for showing contribution of each country?. India - 40% China - 31% Nepal - 19% Japan - 10% Regards Sreekhosh

Hey thank you Anupam. Set wb = Workbooks.Open("c:b - programmeringtempaha.xls", notify:=False) is working fine, Regards Sree

Hi, As per the below Macro if the file (CustomersData.xlsb) is readonly (it may using by another person) it will close and display the MsgBox says "try after sometime". But if it is closed by the person who accesed earler, I will get an alert "File is Now available for editing" Readwrite or...

Hi SirJB7, Hearty congratulations..... And I wish all the very best for your next Milestone...... Sreekhosh

Hi Saurabh, I think there is no dedicated shortcut key for it. Either you can Press and Hold Ctrl+Left Arrow then you will reach @ A19 and press down arrow or Press Ctrl+G and enter the Cell referance which you want to go. Regards Sreekhosh

Hi, How can we add two comparative measures in Bullet chart. I am using Bar charts as bullet chart instead of conditional formatting. I Need to compare Year To Date Sales with Target and Previous Year to Date Sales. Regards Sreekhosh

Hi BigBear, I did something like this before. Can you please give brief idea about the sheets contents (individual update sheet and boss sheet). Regards Sreekhosh.

Hi SirJB7, Sorry for cross posting. Going forward i will adhere all the Posting rules and etiquette. Regards. Sreekhosh

Hi, I have a report with two dynamic charts. I used PICTURE link to view both. But whenever I reopen the report these charts are not updating properly. One is gauge chart and another one is Bullet chart, for the bullet chart bullets are not moving and for gauge chart needle is not moving. But...