Hi,
better to use "Selection.TextToColumns" with text then use "Selection.Copy"
and "Selection.PasteSpecial Transpose:=True"
Sincerely,
ASD
2008/10/1 FF <[EMAIL PROTECTED]>
>
> Hi,
> I am trying to parse data from notepad to excel using VBA macro.
> A, B, C
> Field4 = 8.2
> Field5 = 6.7
> Field
Hi,
You can try the following VBA code.
Sincerely ,
ASD
* * *
Sub PutPeriods()
Dim lpString As String
Dim lpActiveString As String
Dim iCount As Integer
lpString = Space(2) & Trim(ActiveCell)
lpActiveString = ""
For iCount = 1 To Len(lpString) Step 1
If iCount Mod 3 <> 0 Then lpActiveString =
Hi Augustine,
You can use "=DAYS360(Start_date,End_date)/360"
Good Luck,
ASD
2008/10/6 Augustine <[EMAIL PROTECTED]>
Hi everybody,
I tried using the DateDif function in Ms-Office 2007 but its not working.
Is there any other way to activate the function since i heard that the
f