$$Excel-Macros$$ MS Access Group
Hi All, Is there any such group for MS Access and SAS as well ? Rgds, Kaushal -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
Re: Fwd: $$Excel-Macros$$ Un hide a workbook
Hi Vijay, File was hidden from the standard window command. Praveen has already answered this query. Thanks & Rgds, Rgds, Kaushal -Original Message- From: "P.VIJAYKUMAR" Date: Wed, 17 Jul 2013 12:56:25 To: Subject: Re: Fwd: $$Excel-Macros$$ Un hide a workbook Respected Kaushal, I think that the file is saved as read only and modifications and editing are prohibited.The procedure of saving the excel file or any office file as read only is as per the following link http://support.microsoft.com/kb/214094.You can see the file but hen you open the file the sheets are not displayed.If that is the case the file is marked for read only and can be modified or edited only with a password.Please look into the link and if you need further information you can google for the procedure.If you want to alter the file contents ask for the viewing and editing passwords from the person who made the file read only. Regards, Vijaykumar On Wed, Jul 17, 2013 at 6:00 PM, Kaushal Kumar mailto:kaushal.anal...@live.com> > wrote: Apologies, I can not share that file Rgds, Kaushal -Original Message- From: Pravin Gunjal mailto:isk1...@gmail.com> > Date: Wed, 17 Jul 2013 12:26:18 To: mailto:excel-macros@googlegroups.com> > Subject: Fwd: $$Excel-Macros$$ Un hide a workbook post the file at group. -- Forwarded message -- From: Kaushal Kumar mailto:kaushal.anal...@live.com> <mailto:kaushal.anal...@live.com <mailto:kaushal.anal...@live.com> > > Date: Wed, Jul 17, 2013 at 5:54 PM Subject: $$Excel-Macros$$ Un hide a workbook To: Excel VBA Group mailto:excel-macros@googlegroups.com> <mailto:excel-macros@googlegroups.com <mailto:excel-macros@googlegroups.com> > > Dear All, When I am opening an excel file it seems it is open but not visible. Seems like entire workbook is as been hidden. Can someone please help how can we retrieve that file. Rgds Kaushal Rgds, Kaushal -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com <mailto:excel-macros%2bunsubscr...@googlegroups.com> <mailto:excel-macros%2bunsubscr...@googlegroups.com <mailto:excel-macros%252bunsubscr...@googlegroups.com> > . To post to this group, send email to excel-macros@googlegroups.com <mailto:excel-macros@googlegroups.com> <mailto:excel-macros@googlegroups.com <mailto:excel-macros@googlegroups.com> > . Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com <mailto:excel-macros%2bunsubscr...@googlegroups.com> . To post to this group, send email to excel-macros@googlegroups.com <mailto:excel-macros@googlegroups.com> . Visit this group at http://gro
Re: Fwd: $$Excel-Macros$$ Un hide a workbook
Apologies, I can not share that file Rgds, Kaushal -Original Message- From: Pravin Gunjal Date: Wed, 17 Jul 2013 12:26:18 To: Subject: Fwd: $$Excel-Macros$$ Un hide a workbook post the file at group. -- Forwarded message -- From: Kaushal Kumar mailto:kaushal.anal...@live.com> > Date: Wed, Jul 17, 2013 at 5:54 PM Subject: $$Excel-Macros$$ Un hide a workbook To: Excel VBA Group mailto:excel-macros@googlegroups.com> > Dear All, When I am opening an excel file it seems it is open but not visible. Seems like entire workbook is as been hidden. Can someone please help how can we retrieve that file. Rgds Kaushal Rgds, Kaushal -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com <mailto:excel-macros%2bunsubscr...@googlegroups.com> . To post to this group, send email to excel-macros@googlegroups.com <mailto:excel-macros@googlegroups.com> . Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
$$Excel-Macros$$ Un hide a workbook
Dear All, When I am opening an excel file it seems it is open but not visible. Seems like entire workbook is as been hidden. Can someone please help how can we retrieve that file. Rgds Kaushal Rgds, Kaushal -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
$$Excel-Macros$$ Too many cell formats
Dear All, I am trying to change the format of a cell in an excel sheet. It gives me a pop-up box as 'Too many cell formats', which is not allowing me to change the format. Could you please help me solving that issue ? Many thanks, Kaushal Rgds, Kaushal -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
$$Excel-Macros$$ MS Access query last modified name
Dear All, I understand its an excel forum. But just wondering if anybody has got any idea to identify the last modified by user name for MS Access queries. Need to identify the user who has made changes in a query of MS Access 2003. Appreciate your help regarding this and apologies for asking an access question in an excel forum. Rgds, Rgds, Kaushal -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
RE: $$Excel-Macros$$ Help me
Hi Vijayajith, Data validations can be created from one workbook to another workbook. Example: Attached are the two workbook 1. Source_Book.xlsx 2. My_Book.xlsx My list is available in Source_Book - sheet1 - range("A1:A5") and my validation is in workbook - My_Book.xlsx - Sheet1 - Range("A1") Procedure: First create a name range in the workbook Source_Book with the range "A1:A5" as "Month" and now open the workbook My_Book and define a new name as My_List as "Source_Book.xlsx!Month" Now you can use this new define name "My_List" as your validation list However, it now not recommended to use a validation list from a different workbook as the user will not be able to use the validation if the workbook which carries the list is not open. Best Regards,Kaushal Kumar Date: Tue, 15 Nov 2011 19:20:58 +0530 Subject: $$Excel-Macros$$ Help me From: vijayajith...@gmail.com To: excel-macros@googlegroups.com Hi Gurus, Is this possible to do data validation from one workbook to another workbook ? Can you give me one example? Thanks -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com My_Book.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet Source_Book.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
RE: $$Excel-Macros$$ excel vba If IsEmpty(Range) code problem
Hi Seba, You are missing a small thing.. I have made the required correction in your code. Sub testPogoja() If IsEmpty(Range("A1")) Then Exit Sub Else Range("B5").Value = 8 End If End Sub Best Regards,Kaushal Kumar > Date: Thu, 10 Nov 2011 07:48:10 -0800 > Subject: $$Excel-Macros$$ excel vba If IsEmpty(Range) code problem > From: sebastjan.hri...@gmail.com > To: excel-macros@googlegroups.com > > Hi, > > I am testing this fairly simple code for some other purposes but I > always get the value 8 regardless of value in A1: > > > Sub testPogoja() > If IsEmpty("A1") Then > Exit Sub > Else > Range("B5").Value = 8 > End If > End Sub > > > I also tried > > Sub testPogoja() > If IsEmpty("A1") = True Then > Exit Sub > Else > Range("B5").Value = 8 > End If > End Sub > > > and no luck. > What am I doing wrong? > > regards > seba > > -- > FORUM RULES (934+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, > Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not > get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > -- > To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com