_____
From: Erick C
To: MS EXCEL AND VBA MACROS
Sent: Tue, May 25, 2010 12:42:24 PM
Subject: Re: $$Excel-Macros$$ Need macro help - Need to sort, cut and paste
Paul -
I changed the part of the code that you suggested, and it is working
fine.
Again, I am still quite a novice with
Dear All,
I want to Print Page Number "N of M" in Footer by Group-wise (i.e. ID
Wise) through Access Database Report Design. Kindly give some
guideline or VB Code to do the same.
Rgds,
Manas.
--
--
Some important lin
hrough to see what it is doing.
>
> You should find the problem then.
>
> sorry for the confusion (and sarcasm) ;)
>
> Paul
>
>
> From: Erick C
> To: MS EXCEL AND VBA MACROS
> Sent: Mon, May 24, 2010 3:41:51 PM
> Subject: Re: $$E
_____
From: Erick C
To: MS EXCEL AND VBA MACROS
Sent: Mon, May 24, 2010 3:41:51 PM
Subject: Re: $$Excel-Macros$$ Need macro help - Need to sort, cut and paste
Hi Paul -
I tried the code you provided without making any modifications and I
had a few issues.
Just for a bit of background:
StrOut = StrOut & StrDelim & " "
> > StrOut = StrOut & StrDelim & " "
> > StrOut = StrOut & StrDelim & "00"
> > StrOut = StrOut & StrDelim & Format(Cells(R, 2
XCEL AND VBA MACROS
Sent: Fri, May 21, 2010 11:55:43 AM
Subject: Re: $$Excel-Macros$$ Need macro help - Need to sort, cut and paste
Hi Paul -
Thanks for the reply. Let me attempt to answer your questions and
hopefully clarify a bit.
1. I am using Excel 2003
2. All of the steps prior to the code I
;) '22
> StrOut = StrOut & StrDelim & "BNYM"
> StrOut = StrOut & StrDelim & "000000000"
> StrOut = StrOut & StrDelim & " "
>
> f.Writeline StrOut
>
trDelim & "BNYM"
StrOut = StrOut & StrDelim & "0"
StrOut = StrOut & StrDelim & " "
f.Writeline StrOut
End If
Next R
f.Close
'----------------------
Good morning everybody -
I am still quite a novice when it comes to VB and writing codes, so
any help I can get would be greatly appreciated. I am currently
working on a code that takes data from a xls file that I download and
convert it to a text file. I found an older posting with an example
t