Search results

Hi All, i need to select and copy different ranges in excel but i am stuck please suggest. j=2 i am using below:- Range("T" & j & ":AA" & j, "AM" & j).Select giving wrong selection selecting T to AM Thanks Nipen

hi all i have some data for august month which is in form of 1 to 31 August datewise, i want to reverse this data in to 31 to 1 the latest date should come in first Any idea Regards Nipen

Hi Folks, i have tried all my mind to remember the password but not reached and i got stuck somewhere i need this file for one of my processes please suggest the idea or take a look of that. i need to unprotect it and want to change the new password. Best Regards Nipendra

Hi All, Here in the attached data I have some duplicates IDs , I want to copy all the remarks if available and paste in-front of the single unique Id. Lets take a visible example:- If I have ID (101) four time in the data:- ID Remarks 101 A 101 B 101 A 101 C Output should Like...

Hi all, I have done something to connect the excel vba with access database, all the things I have done but whenever I am trying to delete the data or trying to insert new record the event is not working, but when I reload the same form then the database is showing the updated values. Where I...

Hi All, i am trying to count the unique date count from a range which is based on two criteria. example sheet attached pls help or share you thoughts. i have found the unique date count by the:- sumproduct(1/countif(Range,Criteria) but if i have some name and week name also in terms of...

Hi All, my confusion is :- I am entering some data in to the vba form at Run time, and I need to open another excel sheet at that time any idea I can I do that. Please suggest.. Thanks Nipendra

Hi all, Here I am in between my code please help if anybody can.. I want to add multiple values by dropdown but it should be basis on the number count which is in sheet2, like formatting should be count of 6 only not more than that if user is trying to select the formatting after count of 6...

How to count with in the single row horizontally how to count the Stock word which is >=5 Please find the attached sheet here. Nipendra

Hi all, i have little query here, I am working on the 200 pages document in word 2010, and i need a hyperlink on a every page to go back to the home page(Fisrt page), let say i am on the page number 32 and want to go back the first page it is difficult to go back. I have one way that I can make...

Hi all here i have attached a sheet where i am trying to put some vba automation but i am confused. i need to insert the current time when i select the value from drop down in the column "C" i am confuse about the event, what type of event should i use for this. any idea please suggest...

Hi all, I am trying to make an automation where I have the database in “sheet2”, in database I have two company name like “A” and “B”. I want to split the Company “A” data and Company “B” data in to different sheets. I have inserted combobox in “sheet1” where I am using the company name I want...

Hi experts, let suppose i have a database in excel sheet1 and a userform with in the same spreadsheet, i have to update database every day now it’s a very heavy amount of data. the challenge is i am getting whenever i am going to enter some new values it gets duplicate some time because of...

hi all i am facing an error here with this calendar i want to use this calendar in my existing project. please tell me what does the mean of library missing error.

Hi experts, Sorry if this sounds looks dumb Is it possible to track system time by vba code in Excel while system is active. I need to know, if I want to build an application in excel vba on the below requirement-: 1)-whenever i'll login vba code should take as start time 2)- when I'll take...

Sorry if this sounds dumb, is there any way to insert a company logo in word document as a header by excel vba code and I have logo(picture) in the same excel file. Thanks n advanced Regards Nipendra

Hi all, if i have my 12 standard mark sheet in PDF format and I want to extract required details from this PDF to Word doc...like .. i need -: 1) date of birth 2) father's name 3) Mother's name 4) Year is it possible to do with excel vba coding.......... please share your suggestion...

Hi Experts, do you have any idea how to use object shape in vba coding if want to open it. please suggest me if any. attached example Regards Nipendra

Hi Hui, Hope you doing well, I am in difficult situation again I need some suggestion to create a word document by vba code. like If I have three sheet in a workbook and I want to make word doc. for sheet1 with respected existing data and format. please share your suggestion would be...

Hi Experts, is there any way out to make our textbox readable. readable means textbox name should be appear in the textbox until unless textbox is not clicked. Regards Nipendra

hi Sir, I actually have some new fields in query is it possible to do by vba form I wan to fill up all red entries in word document on click event both samples are attached. Regards Nipendra Attached file here=== http://www.fileconvoy.com/dfl.php?id=g34ddc23fe708c503999344781a20461ee7c211bdc

Hi Experts, can we remove the specify name in cell value if I have to remove Nipendra here then? only by excel formula I wan to do it. raj,Npendra,kamal,raju Sam,Harish,Nipendra,Raj Praveen,Amar,Amit,Nipendra Kiran,Aman,Pari,Nipendra,Mukesh,Arjoo Regards Nipen

Hi Experts, can please someone help me out how I can add calendar on vba user form I have downloaded MSCAL.OCX ,mscomct2.ocx files and paste in to system 32 still cant able to see the Microsoft month view control 6.0(sp4) in additional control window please suggest me here. Regards Nipendra

Hi Experts, please suggest for protect the word document actually I am saving a word doc by excel vba code and want to protect it also but not idea how to do it Regards Nipen

Hi Experts, Actually I am working on a project where I am in between a query, Is this possible that we enter some input from vba form and input should be reflect on pdf and word page where I want ? Like I have four input box on the form 1- Name 2- Id 3- Process Name 4-...