Re: $$Excel-Macros$$ Importing Excel Files

2013-12-29 Thread Anoop K Sharma
just use below line Application.GetOpenFilename ("All Excel File (*.xls*),*.xls*") On Sun, Dec 29, 2013 at 8:49 PM, Linda C wrote: > Hi Ashish, > > Is it possible to actually show all the excel files (both .xls and .xlsx > version) after clicking Browse button so I can directly click the file

$$Excel-Macros$$ Listbox data adding problem

2013-12-29 Thread Renukachari Kasee
Dear Experts, Please provide the solution for the attached worksheet. problem was written in the excel please go through that. thanks -- 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.fac

Re: $$Excel-Macros$$ Importing Excel Files

2013-12-29 Thread Linda C
Hi Ashish, Is it possible to actually show all the excel files (both .xls and .xlsx version) after clicking Browse button so I can directly click the file to be imported? Instead of clicking the drop-down button to scroll to the file? The reason is the files name could be very long and it wou

Re: $$Excel-Macros$$ Need help - Need Help Inserting Single of double quotes into strings in vba...

2013-12-29 Thread ashish koul
Dim abc2 As String abc2 = """xyz""" MsgBox abc2 see if it works On Sun, Dec 29, 2013 at 6:17 PM, Avinash Kumar Mahato wrote: > I really need your help in this query > > Expecting output is *"NeedHelp"* > > I have already tried below vba codes for this, but these are not working > so can you pl

$$Excel-Macros$$ Need help - Need Help Inserting Single of double quotes into strings in vba...

2013-12-29 Thread Avinash Kumar Mahato
I really need your help in this query Expecting output is *"NeedHelp"* I have already tried below vba codes for this, but these are not working so can you please provide any other solution. 1. Dim MyVar As String = ""NeedHelp"" 2. Dim MyVar As String = """NeedHelp""" 3. Dim MyVar As String =