Search results for query: *

Sure Bro i have uploaded my sample files and details to u plz see the pic that i have attached

I have mentioned the details plz see this post 6 May 20 20:03 6 May 20 20:04 i mentioned the problem this code is pasting the data incorrectly to 2.csv

No bro I have a Great respect for vba coders But this is my first time in engtips & i never ever registered and asked anything on tektips

the output should be

Sub Step14() Dim w1 As Workbook, w2 As Workbook, w3 As Workbook Set w1 = Workbooks.Open("C:\Users\WolfieeeStyle\Desktop\1.xls") Set w2 = Workbooks.Open("C:\Users\WolfieeeStyle\Desktop\2.csv") Set w3 = Workbooks.Open("C:\Users\WolfieeeStyle\Desktop\3.xlsx") Dim Ws1 As Worksheet, Ws2 As...

SkipVought I dont need ur tip I already have a conversation with ids whatever he suggest & will provide i will accept that But SkipVought I dont need ur tips and suggestions

Sub COPYpaste() Dim w1 As Workbook, w2 As Workbook, w3 As Workbook ' Set w1 = Workbooks.Open("C:\Users\Desktop\sample1.xls") Set w1 = Application.ActiveWorkbook ' Set w2 = Workbooks.Open("C:\Users\Desktop\sample2.csv") ' Set w3 = Workbooks.Open("C:\Users\Desktop\sample3.xlsx") ' I have moved all...

Yes i ran the macro Dis Sir & i mentioned the error details to u also

vba will be placed in a seperate file macro.xlsm i have three files 1.xls & 2.csv & 3.xlsx In 1.xls first row has headers so dont count that In 1.xls count the total number of rows that has data and copy the 3.xlsx sheet3 first row(first complete row copy) and paste that much time of 3.xlsx...

Sir if my macro contains many errors so plz make a new macro i am getting error i shared u al details I am not a professional one

Set rngOut = Ws2.Range("A1:" & Lc3Ltr & Lenf1 & "") getting error with this line

Instead of that i am geeting this after runing macro

Sure Sir all details are give below 1.xls first row has headers so dont count that In 1.xls count the total number of rows that has data and copy the 3.xlsx sheet3 first row(first complete row copy) and paste that much time of 3.xlsx first row of sheet3 to 2.csv suppose 1.xls has data in 5 rows...

Hey There Sub COPYpaste() Dim w1 As Workbook, w2 As Workbook, w3 As Workbook Set w1 = Workbooks.Open("C:\Users\Desktop\sample1.xls") Set w2 = Workbooks.Open("C:\Users\Desktop\sample2.csv") Set w3 = Workbooks.Open("C:\Users\Desktop\sample3.xlsx") Dim Ws1 As Worksheet, Ws2 As Worksheet, Ws3 As...