$$Excel-Macros$$ All text box need to be enter

Dear Team, I am creating one tool in user form, it contains 3 textboxes, need help on fallowing If textbox3 fill with information then check for textbox4, if filled with information then check for textbox5. If all textbox 3, 4 & 5 are filled with information then go to remaining process. I

$$Excel-Macros$$ Macro for data indexing

Dear friends, I attached a sheet it has a data set A I need to convert data into data set B for cleaning (value is comma separated) & after cleaning and unique i have to put that data into same format as data set A i.e. comma separated on appropriate serial number i have a huge data set to clea

Re: $$Excel-Macros$$ VBA Code to Import Excel table in Word file

Dear Ravinder Thanks for reply but how to do it.Pls give me guidance or give modified code. Regards Amar On Tue, Apr 1, 2014 at 9:31 PM, ravinder negi wrote: > have u added the library word object library in vba > > > On Mon, Mar 31, 2014 at 10:02 PM, amar takale wrote: >> >> Dear Ravinder >>

Re: $$Excel-Macros$$ Show links which to other Data source

Sub find_links() Dim extlinks Dim j As Long, k As Long Dim wkb As Workbook Dim rng As Range, cl As Range Dim links1 As String Dim links2 As String Set wkb = Workbooks.Add wkb.Sheets(1).Range("a1").Value = "Cell Address" wkb.Sheets(1).Range("b1").Value = "Formula"

$$Excel-Macros$$ help on #VALUE! and #NUM! error

Hi Team, Please find the attached sheet in winch i have already put the formula for finding particulate values. but it me shows #VALUE! and #NUM! error. It would be very helpful if somebuddy will help me to rectify the same. Regards Jocky -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And

Re: $$Excel-Macros$$ Convert PDF to Excel - single file with 12000 pages

I tried saving the PDF as Text and importing it in Excel, it didn't work. Do you have a sample macro or something that I can try? Thanks. On Tue, Apr 1, 2014 at 11:24 PM, Ricardo(R) wrote: > Hi Abhishek Jain, > > If the formatting of the PDF files is standardized, you can create a macro > to c

$$Excel-Macros$$ macro to insert a range based on cell value

Hello I am stumped. I need a macro that will insert a range of cells based on criteria of another cell. I have attached a sample spreadsheet. Can anyone help me figure this out? TYIA, Joy -- 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) ! Jo

Re: $$Excel-Macros$$ Convert PDF to Excel - single file with 12000 pages

Hi Abhishek Jain, If the formatting of the PDF files is standardized, you can create a macro to convert to TXT and then import into excel and then save in xlsx format automatically for all pages. Regards, Basole. 2014-04-01 11:30 GMT-03:00 Abhishek Jain : > Hi Friends, > > I have a PDF fil

Re: $$Excel-Macros$$ VBA Code to Import Excel table in Word file

have u added the library word object library in vba On Mon, Mar 31, 2014 at 10:02 PM, amar takale wrote: > Dear Ravinder > > VBA Code not working.Attached Error Screen shot here.Pls see & guide > me.I have no knowledge of VBA. In excel there are no show "Microsoft > Word library " in Tools-refe

$$Excel-Macros$$ Convert PDF to Excel - single file with 12000 pages

Hi Friends, I have a PDF file with some 11800+ pages in it (around 28 MB). Is there a way I can convert it in Excel format using a macro or a tool? Many thanks for help. Regards, Abhishek -- 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

Re: $$Excel-Macros$$ Need macro for repetative formatting

Hello All, Pl advice on mail below. Am I asking something very difficult ? If anybody can help that can save my lots of time. Pl do the needful. Regards, Suyog > On Tuesday, 25 March 2014 11:59:37 UTC+5:30, Suyog Kulkarni wrote: >> >> Hello Vicky, >> >> I'm not at all coping data from any whe

$$Excel-Macros$$ Show links which to other Data source

Dear experts, My workbook containing large no. of sheets & formulas, but I want to show those formulas which containing links to other data source of file. Kindly know me how to check it. -- Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Sp