Recent content by Dheeraj

Thanks for the information. However, it is unfortunate for me that I'll not be able to use power pivot :(

Thanks for reply Thangavel but I have already tried this. There is nothing in Com Add-ins. My office provides only 2013 version which doesn't has pre-installed Power Pivot and Power Query. Luckily, I was able to find Power Query and got this installed and using. But for Power Pivot, unable to...

I have excel 2013 which do not has Power Pivot add-in enabled. I searched google for add-in to download but nothing found. Please help me with the link where I can download it.

Thanks Marc L for your response however; I could not use it. I added "Microsoft ActiveX Data Objects 2.5 library" and tried but didn't get using it. Also, tried to read about it on Google but felt difficult to understand the examples. (http://www.motobit.com/tips/detpg_read-write-binary-files/)...

Hi, I have a few text files (.txt) which have data in English and Chinese languages. I am required to consolidate these files. I am able to do that successfully however; while reading Chinese language data and pasted it to Excel, Chinese alphabets becomes some special characters i.e. do not...

Dear All, I am trying to make similar charts as shown in the attachment but don't know to make them in Excel. Tried a lot searching on google but got no success. I viewed them on internet so don't have data so just uploading the picture that I captured from there. Hoping to get a solution...

Hi All, Thanks for your support :) I have already checked with the points mentioned in replies. However, still unable to solve it. Unfortunately unable to upload any sample workbook. Anyways, I have found few links on google and these have some concepts. Let me try them and if those...

Hi all, Yesterday one of my team member showed me an error he was getting in a report. This is very strange kind of error which I never heard from anyone nor faced it. Also, unable to replicate it. However, seen it on my colleage's system. We tried to fix it but no success :( 1. there are 4...

Sorry Luke, I don't know how to tag my post like that. I am unable to upload a sample file to elaborate my query so just requesting you to visit below mentioned link and read the last 2-3 paragraphs where a line graph has been explained (I hope you will be able to understand my query). I just...

Hi Faseeh, I think the file that I tried to upload was discareded by system (I am working on my office system). Please read the last paragraph in the page by accessing the link I provided in my 1st post. Thanks

Hi Faseeh, I am unable to understand the solution given in the last paragraph of the page for the line graph. I have also attached a file with the related pictures. I hope this will help to understand the issue. Thanks

Hi All, First time accessing this new version of the forum and happy to find that we can upload sample data now. It will help a lot in my future posts. Thank you so much Chandoo:) I was reading a topic on google (link ...

Hi All, Please help me with VBA code so that I can login to a web based application. For example, I need a code to login to my gmail account by running a macro in Excel. Thanks, Dheeraj

Hi SirJB7, I searched it on google now. The code that I needed was ?Application.StartupPath. Other details are available at http://www.rondebruin.nl/personal.htm. Thanks, Dheeraj

Dear Narayan, It seems that I did not explained my question clearly. Let me explain it again. Whenever we open any excel workbook, MS Excel opens another excel file in the backend. The name of that file is Personal.xls. This workbook is hidden and so we are unable to view it. However, we...