Search results

Hi All, Can anybody suggest a vba code in access, which enables macro automatically at open event of ms-access. Actually, in a project we are using ms-access as a front end tool containing some Autoexe macros. Everytime, whenever we open ms-access it shows an error because they disabled all...

Hi All, I stucked at a place in excel from so long. we have a excel workbook contain external links, I tried to break the links with all the options available in the Data Menu>>edits links. I do good reserac on google as well and got options like: 1) Check Name Manager in formula and delete...

Dear team, i am working on a excel dashboard where i need to do a certain operation:- Grade Name1 Name2 Name3 A anul suresh ahima B shweta X Y now i have a db like which i want to fill up with grade. this table need data maping from...

Hello All i am making a dashboard and need anybody's help to complete the same. in attached file there are two columns B and c, filled with data and pie chart value depends on these column data. for now pie chart is considering entire B & C column for chart data range but i want ... there is...

Dear All, i had tried to get the result through search option but not get the extact answer what i am looking for. refer below mention code, whenever i entered my password, it shows the exact words, (what my password is) in Input option, but i want it should show the "*******....." instead...

Good Morning All. i don't know whether it is logically possible or not but, what i am trying to do .. i am making a dashboard for senior management and currently we are handling more then 150 clients. There is a specific location where all the files and folders are saved. A folder (org name)...

Hello All, i am in dilemma for this thread from around more than an year. i already read http://chandoo.org/forum/threads/requesting-help-on-data-validation-based-on-information-from-a-different-cell.4529/#post-23667 link on chandoo.org website but sorry, my Requirement is little different...

Hello, I am creating a booking engine module for a hotel website. As every hotel has defined number of rooms with defined room category, the concern is in checking the availability of a particular room type for a particular date. The purpose of the module is that if a user enters arrival...

Good Afternoon all, can anyone please suggest the VBA code to automatically create a master from another excel tabs. i dont have any idea regarding same. :( Thanks to all in advance.!!

Hi, can anyone please suggest VBA code to automate mail that supports pictures also. a link is attached here in which i want add picture in outlook body well but its not supporting. https://www.dropbox.com/s/98jk411zod6uea6/Ajanta%20confirmation%20voucher.xlsx please suggest the code for...

can anyone please help out for same. i want excel formula/VBA code to find out the address of last NON EMPTY CELL in a specific row. i had tried the below one but wrong result found. please HELP :( =ADDRESS(ROW($A$4),MAX(NOT(ISBLANK($A4:$AH4))*COLUMN($A4:$AH4)))..... with Ctrl+shift+enter...

Hi, can anyone help me to update msado15.dll in active x control. I had coded VBA program through which we can extract MS-Access table and displays it on Excel.previously this program works very fine, but after getting system formatting it sows the error (Run time Error - 430 Class does not...

Hi all, can anyone suggest the VBA code to create a loop depend on check box value. what exactly i want... There are 50 check boxes on a sheet.. for true value of each check box its corresponding cell text get uploaded in db..as like If .CheckBox1.Value = True Then...

Hi, I am Beginner in VBA. i am working on a project in which if you update any client name in your db and tagged with project manager then it will automatically link with Project manager sheet. Now, i want to add a new worksheet for every new entry in column A ... means column A of...