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

2013-12-27 Thread ashish koul
enable macros 1 choose browse button and select the folder having the files and then choose file to import from first combobox 2 choose the sheet name from 2nd combo box 3 click on import button to import data Regards Ashish On Sat, Dec 28, 2013 at 3:34 AM, Linda C wrote: > Yes, there is

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

2013-12-27 Thread Linda C
Yes, there is only one sheet in those import files. Thanks! On Friday, 27 December 2013 12:21:09 UTC-5, ashish wrote: > > excel files will have only one sheet right? > > > On Fri, Dec 27, 2013 at 10:48 PM, Linda C > > wrote: > >> Hi ashish, >> >> Thanks for the quick reply! >> >> The data range

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

2013-12-27 Thread ashish koul
excel files will have only one sheet right? On Fri, Dec 27, 2013 at 10:48 PM, Linda C wrote: > Hi ashish, > > Thanks for the quick reply! > > The data range to be imported (A1 to Z20) is fixed for all the import > files. > > Sorry, I may not understand your second question. Ideally, the > mast

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

2013-12-27 Thread Linda C
Hi ashish, Thanks for the quick reply! The data range to be imported (A1 to Z20) is fixed for all the import files. Sorry, I may not understand your second question. Ideally, the master.xlsx file will have a button in tab 1 to import "FileA_Main.xlsx" and another button in tab 2 to import "Fi

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

2013-12-27 Thread koul . ashish
Is ur range fixed and do you want to append also or add the data in seperate tabs only Sent on my BlackBerry® from Vodafone -Original Message- From: Linda C Sender: excel-macros@googlegroups.com Date: Fri, 27 Dec 2013 08:40:19 To: Reply-To: excel-macros@googlegroups.com Subject: $$Exc

$$Excel-Macros$$ Importing Excel Files

2013-12-27 Thread Linda C
Hello, I have trouble creating a macro to import excel files into an active workbook with UI. Let's say there are multiple excel files (.xlsx) in the folder "C:\Import Files". These files have the following file names: "FileA_Main.xlsx" "FileA_Sub.xlsx" "FileB_Main.xlsx" "FileB_Sub.xlsx" The

$$Excel-Macros$$ Re: Please provide the code for data entry as mentioned in excel

2013-12-27 Thread pmyk
Have you changed the names of Text Boxes and Command Button as per my code? What portion is not working? On Friday, December 27, 2013 8:20:50 PM UTC+5:30, renuka chari wrote: > > Dear sir > this code is not working > > Please provide the alternate solution > > > > On Monday, 16 December 2013 20:3

$$Excel-Macros$$ Re: Please provide the code for data entry as mentioned in excel

2013-12-27 Thread renuka chari
Dear sir this code is not working Please provide the alternate solution On Monday, 16 December 2013 20:30:22 UTC+5:30, renuka chari wrote: > > Thank you sir, > i will check this once and tell you > > thanks once again > > > On Thursday, 12 December 2013 22:24:33 UTC+5:30, pmyk wrot

$$Excel-Macros$$ Post from Userform Converts Numbers to Text

2013-12-27 Thread Hilary Lomotey
Hello Experts, can someone pls advice how i can avoid any postings i make from a userform converting to text instead of a number. 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.fa