$$Excel-Macros$$ Re: Add and remove text box on ever time button click.

2014-11-26 Thread Mandeep Baluja
why dont you hide buttons on click and unhide on another On Monday, November 17, 2014 4:10:26 PM UTC+5:30, Rupesh Patil wrote: > > Hello experts, > > I need your help,I have one userform which attached with mail for your > reference, what I need is add text boxes vertical on button every time

Re: $$Excel-Macros$$ Add and remove text box on ever time button click.

2014-11-26 Thread Rupesh Patil
Hello Expert, No one has solution, that is ok, at least give me some hint so that I can do it my own. On Thu, Nov 20, 2014 at 7:26 PM, Paul Schreiner wrote: > OK, I'll take a look at this as soon as I get some things I'm PAID to do > taken care of! > > > *Paul* > ---

$$Excel-Macros$$ VBA Functions and methods.

2014-11-26 Thread Mandeep Baluja
Where can I find a list of all methods and functions for VBA in Excel. I want it in readable format not while searching with the object explorer. various website is showing but not a complete information in single link. Regards, Mandeep Baluja Excel Specialist. https://www.linkedin.com/profile

Re: $$Excel-Macros$$ Sum downtime for equipment with overlap periods

2014-11-26 Thread Paul Schreiner
Could you double-check your calculation again? in your sample, transction #6 (12:30-14:30) is completely contained within transaction #5 (12:00-16:00) so would not contribute to the total. my calculation comes up with 5:50 instead of 6:20 Paul - “Do all th

Re: $$Excel-Macros$$ Re: Introduce Yourself !!

2014-11-26 Thread Vaibhav Joshi
hey welcome, keep sharing your knowledge! Fijne Avond! + *I did not do this for you. God is here working through me for you.* On Wed, Nov 26, 2014 at 4:47 PM, Muneera Shabana wrote: > Hello buddies, > > This is Muneera Khan from Amsterdam, the Netherlands Currently working > as Busine

$$Excel-Macros$$ Re: Macro help needed for converting all the xls files into csv & placing the csv files

2014-11-26 Thread Mandeep Baluja
Sub XLS_to_CSV() Dim wb As Workbook Dim strFile As String, strDir As String SourcePath = "C:\Users\pc\Desktop\45.November.2014\" strFile = Dir(SourcePath & "*.xlsx") Do While strFile <> "" Set wb = Workbooks.Open(Filename:=SourcePath & strFile, Local:=True) newpath = "C:\Users

$$Excel-Macros$$ Re: Macro help needed for converting all the xls files into csv & placing the csv files

2014-11-26 Thread Mandeep Baluja
Sub CSV_to_XLS() Dim wb As Workbook Dim strFile As String, strDir As String SourcePath = "C:\Users\pc\Desktop\45.November.2014\" strFile = Dir(SourcePath & "*.xlsx") Do While strFile <> "" Set wb = Workbooks.Open(Filename:=SourcePath & strFile, Local:=True) newpath = "C:\Users

Re: $$Excel-Macros$$ Re: Shortcut required for this format !!

2014-11-26 Thread XLS S
Dear, we are not concerned about it. Thank u for your solution . Enjoy Team XLS On Wed, Nov 26, 2014 at 4:16 PM, Mandeep Baluja wrote: > No I don't want to check you knowledge. I had given the solution to share > knowledge. As far your team is concerned you are far b

$$Excel-Macros$$ Re: Introduce Yourself !!

2014-11-26 Thread Muneera Shabana
Hello buddies, This is Muneera Khan from Amsterdam, the Netherlands Currently working as Business Process Analyst for Market Risk Management at ING Bank. I love museums, travelling, painting, arts & fashion! I highly appreciate all the contributers here providing very good supportAn

$$Excel-Macros$$ Macro help needed for converting all the xls files into csv & placing the csv files

2014-11-26 Thread Muneera Shabana
Good Morning, Hope you are having a great day! *Objective: I want to convert all the excel files (.xls,.xlsx etc) in a folder to .csv files (with original file names) & place the csv file in another target folder.* I am not an excel expert, however I managed to write the below piece of cod

Re: $$Excel-Macros$$ Re: Shortcut required for this format !!

2014-11-26 Thread Mandeep Baluja
No I don't want to check you knowledge. I had given the solution to share knowledge. As far your team is concerned you are far better than me. On Wednesday, November 26, 2014 4:07:51 PM UTC+5:30, XLS S wrote: > > is this your question for help...do you want to check our knowledge? > >

Re: $$Excel-Macros$$ Re: Shortcut required for this format !!

2014-11-26 Thread XLS S
is this your question for help...do you want to check our knowledge? . Enjoy Team XLS On Wed, Nov 26, 2014 at 4:02 PM, Mandeep Baluja wrote: > build this hope this help someone else. > > Sub Format_to_time() > > Selection.NumberFormat = "[h]:mm:ss" > Selection.Font.Bol

$$Excel-Macros$$ Re: Shortcut required for this format !!

2014-11-26 Thread Mandeep Baluja
build this hope this help someone else. Sub Format_to_time() Selection.NumberFormat = "[h]:mm:ss" Selection.Font.Bold = True End Sub On Wednesday, November 26, 2014 3:29:40 PM UTC+5:30, Mandeep Baluja wrote: > > [h]:mm:ss > > What is the keyboard shortcut to set the time in this format. > --

Re: $$Excel-Macros$$ Shortcut required for this format !!

2014-11-26 Thread XLS S
Sorry, in excel there is no shortcut related specify format... you can use ctrl+shift+@ for general time format . Enjoy Team XLS On Wed, Nov 26, 2014 at 3:29 PM, Mandeep Baluja wrote: > [h]:mm:ss > > What is the keyboard shortcut to set the time in this format. > > --

$$Excel-Macros$$ Shortcut required for this format !!

2014-11-26 Thread Mandeep Baluja
[h]:mm:ss What is the keyboard shortcut to set the time in this format. -- 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 t

Re: $$Excel-Macros$$ Sum downtime for equipment with overlap periods

2014-11-26 Thread son nguyen
Dear Ganesh Thank for your advise but i found out there are some mistake in your formula.Please you refer enclosed file and I hope you might give new solution. Son 2014-11-26 13:26 GMT+07:00 Ganesh N : > Dear son nguyen, > > PFA > > Regards, > Ganesh N > > On Wed, Nov 26, 2014 at 10:03 AM, Gane