$$Excel-Macros$$ Re: Import file from Text Fil

2014-12-28 Thread Mandeep Baluja
> > Sub Macro1() > > Dim fName As String > > fName = Application.GetOpenFilename("Text Files (*.txt), *.txt") > If fName = "False" Then Exit Sub > With ActiveSheet.QueryTables.Add(Connection:="TEXT;" & fName, _ > Destination:=Range("$A$1")) > .Name = "IO Data1 (2)" > .F

$$Excel-Macros$$ Re: Need help to print only certain no of records from a payroll of employees

2014-12-28 Thread MRafique Ujjan
Dear Vabz! I can't find your last email. Plz send me your suggestion in this post. I'll be thankful to your Thanks On Friday, December 26, 2014 11:19:38 PM UTC+5, MRafique Ujjan wrote: > > Dear Experts! > > I am facing problem during printing of payroll because it consists > more than 1000

Re: $$Excel-Macros$$ Re: Import file from Text Fil

2014-12-28 Thread saravanan R
Hi Mandeep, This what I needed, but through VBA code. Because i Have to get this imported Data into other excel Template. Can you please share how we can proceed through VBA. thanks & regards, Saravanan R On Fri, Dec 26, 2014 at 5:28 PM, Mandeep Baluja wrote: > Want this result ? > Regards, >

Re: $$Excel-Macros$$ Re: Macro for Ageing of Inventory

2014-12-28 Thread C.G.Kumar
Dear Vaibhav, I would try to explain how we do it manually so that it is *Cell C-5 refers to quantity found after Physical Counting. (IT has some 900 rows of unique items).* To determine ageing of Inventory, the item code is looked into "Purchase Data". If material code is not available in purch

$$Excel-Macros$$ How to insert new row in a protected table formatted sheet

2014-12-28 Thread Victor Goni
I need a VBA Macro that could insert new row or delete row in a protected table formatted sheet (as attached). when sheet is unlocked i can isert a new row by pressing the tab button. I need a VBA Macro that could enable my users add more items purchased when the editable rows are insufficient,

Re: $$Excel-Macros$$ Data Fetch From Particular URL

2014-12-28 Thread Vaibhav Joshi
check this...http://www.wiseowl.co.uk/blog/s393/scraping-websites-vba.htm + *I did not do this for you. God is here working through me for you.* On Sun, Dec 28, 2014 at 12:43 PM, Rajeev Ranjan <06raj...@gmail.com> wrote: >HI, > > please guide, How to get the data from Web

Re: $$Excel-Macros$$ Help on coding to change cell value after every printing

2014-12-28 Thread Vaibhav Joshi
Hi check this.. Sub PrintForms() Dim StartRow As Integer Dim EndRow As Integer Dim Msg As String Dim i As Integer Sheets("Form").Activate StartRow = Range("StartRow") EndRow = Range("EndRow") If StartRow > EndRow Then Msg = "ERROR" & vbCrLf & "The startin

Re: $$Excel-Macros$$ Import file from Text Fil

2014-12-28 Thread Vaibhav Joshi
pl ignore last email.. + *I did not do this for you. God is here working through me for you.* On Sun, Dec 28, 2014 at 6:26 PM, Vaibhav Joshi wrote: > hi > > can you share sample data file.. > > > > + > *I did not do this for you. God is here working through me for you.* > > On Fri, Dec

Re: $$Excel-Macros$$ Import file from Text Fil

2014-12-28 Thread Vaibhav Joshi
hi can you share sample data file.. + *I did not do this for you. God is here working through me for you.* On Fri, Dec 26, 2014 at 4:32 PM, saravanan R wrote: > Hi Team, > > I have an query on Importing text file , delimit by "Seperator" and make > particular column to be text, and impor

Re: $$Excel-Macros$$ Need help to print only certain no of records from a payroll of employees

2014-12-28 Thread Vaibhav Joshi
hi you are trying ti print payslip? Check my last email where i have given you solution to it.. Cheers!! + *I did not do this for you. God is here working through me for you.* On Fri, Dec 26, 2014 at 11:49 PM, M.Rafique MRU wrote: > Dear Experts! > > I am facing problem during printing o

Re: $$Excel-Macros$$ What is this Cache stands for.

2014-12-28 Thread Vaibhav Joshi
HI This a hidden sheet created by an excel add-in which helps you to convert number to word. Cheers!! + *I did not do this for you. God is here working through me for you.* On Sat, Dec 27, 2014 at 11:47 AM, Sandeep Chhajer wrote: > Dear Excel Gurus, > > Please check the print screen attac

$$Excel-Macros$$ Help on coding to change cell value after every printing

2014-12-28 Thread Ashish Bhalara
Dear experts, I need to change cell value on every looping in below mention code. Sub PrintForms() Dim StartRow As Integer Dim EndRow As Integer Dim Msg As String Dim i As Integer Sheets("Form").Activate StartRow = Range("StartRow") EndRow = Range("EndRow") If S