>
> 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
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
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,
>
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
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,
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
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
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
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
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
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
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
12 matches
Mail list logo