It is not always A41.
The next free cell depends on the content of the csv file.The problem is how to identify the next free cell in the first column(i.e cell(*,1). & to indicate the source of the file in a column in the excell file.
Thanks
DONE1
Last Activity: Feb 5 '07, 08:32 AM
Joined: Nov 1 '06
Location:
-
CSV file import into Excel sheet
Hello,
I am trying to import 4 separate csv files from 4 different servers into an excel sheet.I want to write a macro which will automate this.Also, i want to append the name of the server for each file in next free column.
How do i ensure that the next csv file does not overwrite the previous import.i.e to make sure that next free cell (*,1) is selected before the next import.Here is what i have been able to generate so far:
... -
Can anybody help me out.Leave a comment:
-
TextFile Automation
Hello,
I have written a macro that will import 4 different text files into 1 excel worksheet.
After each import i append an ID(5th column) to distingush the source of the data.
My problem is how to make sure that it always imports starting from the next free cell & to make sure it appends the ID correctly.
Here is what i have for now:
...Code:Range("A1").Select With ActiveSheet.QueryTables.Add(Connection:= -
Thank you so muchLeave a comment:
-
Compare two Table(Any efficient way)
I wrote a code as follows to compare 2 tables on diff worksheet.
Each work sheet has about 6000 Rows.
The code works but appears to Work very slow.
Is there a more efficient way to do it.
...Code:Sub MergeTable() ' '' Dim ROW1 As Long Dim ROW2 As Long Dim C1 As String Dim C2 As String Dim C3 As String Dim C4 As String ROW1 = 2 Do While Sheets("TABLE2").Cells(ROW1, -
Thanks for your help...Leave a comment:
-
Thank you, The code works.
But i would like to know what the arguement (DesiredWord) in the Function (Word)
is for.
Private Function Word(DesiredWor d As Long, FromString As String) As String...Leave a comment:
-
Copying/Pasting Text from/to Cells
Hello There,
I am trying to write a macro that will copy part of Text in a Cell & then paste in another cell.
For example,
assume cell A1="ABE_BC1 AbTS 11 bisTSport 2", I would like to copy/Paste "11" in cell A2 & 2 IN cell A3 .How do i achieve this with a macro instead?
Can anyone help?
CELL A1 = ADDRESS CELL B1 = BOARD CELL C1 = SLOT
CELL A2 = ABE_BC1 AbTS 11 bisTSport...
No activity results to display
Leave a comment: