Search results

its already in .xlsb format and containing the size of 12 mb:oops:

@ Deepak, its 12 MB file after zipped. have very less data and lots of graphics. Its good to share?

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...

Thanks Hui for the suggestion, no connection found.. :(

Thanks all for suggestions but :( none of the worked out for me, checked all graphics series and data none of the chart/graph contained link, and try to find with "[" but output shows no data found. My more reasons which stops me to break the link.

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...

Thanks all for your support. Hui sir@ I am not able to upload file beacuse of Access Denied.. file upload by Azumi is perfect. shrivallabha@ code is perfect but showing error when drag to other columns. Thanks in advance for help.

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...

Hi Luke, I want to look out the vba code for same. I tried to open from the link given above but think so the website get revamped. and also when tried to search it out then not able to find the exact wat i was looking for. Can you please share the updated link for same or on some other...

Hi Coolkiran, My requiremnt is exactly same what you have and what you have mentioned in your thread opening line. Can you please share the VBA code to browse the file path for opening the xls/csv file through vba code. Thanks in advance for the same. Shweta

Dear All, would request you to please suggest:- In a dynamic excel pie chart, if we want to show category name with legends on graph, for only those values which are zero. is it possible? i am very confused here. Thanks in advance for same. file attached with dummy data for reference.

Dear Debraj, Thanks for your reply. but how can i select the checkbox. My Requirment is for dynamic chart based on checkbox selection and de-selection. (value and category have to be visible but colorless in case of de-selection) Also, i tried to achieve my requirement with a New Idea. I...

Dear Narayan Sir, Thank you so much for your response. i have learned a new property of checkbox.(linked) can you please clear few more doubts:- 1) ca we linked checkbox with different tab(in same worksheet) 2) it is possible that when we un-select any checkbox then its value will still...

Thanks both for your replies. looking for the same which replied by Narayank sir. but sir there is a question. 1) please suggest how we do it? 2) if we add any check box then, can it done automatically?

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...

Thanks Brij, Got the answer.

Again Stuck, :(. There is a little change in PM1 tab. Let suppose, if every month is split into 2 parts, (First 15 Days and last 15 days) and in main sheet we want to fetch the value of last 15 days data only, then what should be the modified formula for same. please help.:confused:

Thanks SirJB7. understood. Will try and and share the result.

Thanks both (Luke & Haseeb).. i am not very expert in Excel and Access (both:mad:). I read both the formula but need to put extra effort to understand the formula of Haseeb. Both formula's are working fine. Thank you everybody for the same.

Hi All, Need little more assistance in same. i have attached a file in which 4 more tabs are added (sheet with PM name). What i am trying, whenever we select any PM and APM name in Main tab then this will select the data from Respective PM tab automatically display the Month Wise score in main...

Thanks Sirjb7, but please confirm where we get the result of "debug.print" command. i am not able to see the result after click on command 2.

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...

Sorry Narayan Sir.. for confusing Statement... i got my result in your first formula. Actually My basic motive was to know the availability of vacate Room at any day of the Month. Many Thanks for the same. :)

Hello All, Suddenly there is a new challenge comes in same concept.... Please confirm should i continue with the same thread or need to create a new one. Problem explanation is: - Now we want to watch the entire Month Booking e.g. From Month start Date to end date. i had tried below...

Thank lohithsriram.. actually i am new with Macros. Could you please tell me the logic of using "option explicit" because with using option explicit function some other macros stop working. it will be really helpful if you tell me little about this.