$$Excel-Macros$$ Re: Pick data from one workbook to another workbook

2012-02-09 Thread Vishwamitra Mishra
Hi Can you explain which data you want to put where? Or do you want take all the details and paste in other sheet as it is? On Feb 9, 4:52 pm, Karan Singh wrote: > Dear all, > > I need your help in vba. I have to pick data from one work to another > workbook's sheets. I'v attached format & the sa

Re: $$Excel-Macros$$ Save As today date

2012-01-19 Thread Vishwamitra Mishra
Try this: Below Code will popup an input box for you to enter the path of the file and name and then it will automatically append the todays name and save it as your given location. - ThisWorkbook.SaveAs InputBox("Enter the Path") & Day(Now) & "-" & Month(N

Re: $$Excel-Macros$$ GTIN Calculator in Excel Formula and Excel Macro

2012-01-02 Thread Vishwamitra Mishra
gt; Would this be easier > =A1 & 10 - MOD( SUMPRODUCT(MID(A1, {1,2,3,4,5,6,7,8,9,10,11}, 1) * > {3,1,3,1,3,1,3,1,3,1,3}), 10) > > Don Guillett > SalesAid Software > dguille...@gmail.com > > > > > > > > -Original Message- > From: Vishwamitra Mishra > S

$$Excel-Macros$$ GTIN Calculator in Excel Formula and Excel Macro

2012-01-02 Thread Vishwamitra Mishra
I have written a Formula and Macro to calculate all types of GTIN. If you want that workbook, kindly let me know. For more detail about the Formula and Macro kindly visit this link: http://www.learnexcelmacro.com/2011/11/gtin-calculator-in-excel/ -- FORUM RULES (934+ members already BANNED for v

$$Excel-Macros$$ Strip HTML in Excel

2012-01-01 Thread Vishwamitra Mishra
Hi All, I have written a function to strip HTML from a String kept in a Cell. How to use this UDF (User Defined Function), you can visit this link: http://www.learnexcelmacro.com/2011/12/strip-html-how-to-remove-html-tags-from-a-string-in-vba/ -