Sub Copy_One_File_Only()
FileCopy "D:\Bla_Bla_Bla\SOS\SourceFolder\FileName.pdf",
"E:\WOW\AngelinaJoly\DestinFolde\FileName.pdf"
End Sub
On Sun, May 29, 2011 at 11:06 PM, PAB wrote:
> Hi
>
> Using VBA in Excel 2003 is it possible to select a pdf file in a
> folder and move it to ano
hai...viewer.
your asking the prombem? how to change landscape to portrait data
ans: just copy all the cells : Go to paste special - transpose
--
--
Some important links for excel users:
1. Follow us
Thnx&Rgrdp
SUNIL B.N
-Original Message-
From: PAB
Sent: 29/05/2011 9:36:40 pm
Subject: $$Excel-Macros$$ Moving files from folder to folder
Hi
Using VBA in Excel 2003 is it possible to select a pdf file in a
folder and move it to another folder.
If not, how can I automate this procedu
can u pls give some light on this coding. i tried to debug but it jus have
sendkey F9.
so if i manually press F9 key in other workbook nothing happens there. can u
explain the logic of this macro.
>
>From: ChilExcel
>To: excel-macros@googlegroups.com
>Sent: Sun, 29 May, 2011 8:42:50 PM
>Subjec
Hi,
what is the significance of -- just before TEXT in the below formula. this
formula works same even without --.
>
>From: Sixthsense
>To: excel-macros@googlegroups.com
>Sent: Sun, 29 May, 2011 3:55:33 PM
>Subject: Re: $$Excel-Macros$$ How to change Date format in to number
>
>Hi Prabhu,
>
Hi
try:
For Each objAdapter In colAdapters
Cells(1, 1) = "Physical address: " & objAdapter.MACAddress
Next objAdapter
End Sub
On Sun, May 29, 2011 at 4:46 PM, Rajesh K R wrote:
> HI
>
> What are the changes required to get the result in a cell instead of msg
> box.
>
> Regards
>
> Rajesh kainikk
Hi
Using VBA in Excel 2003 is it possible to select a pdf file in a
folder and move it to another folder.
If not, how can I automate this procedure.
Thanks
Paul
--
--
Some important links for excel users:
1. Follo
Hi ,
Thanks for the response. This did solve part of my problem.However when I
split the cell containing more than 255 characters using text to columns
options. I see only the first 255 characters getting split, others are just
ignored. Let me know how I can get away with this issue.
Other member
Hi Prabhu,
see if the enclosed file helps
Regards
Umesh
On Sun, May 29, 2011 at 9:55 AM, Prabhu wrote:
> Hi Friends,
>
> I have attached a sheet, which contains space in prefix and suffix.
>
> But below formula is not working.
>
> Kind do the needful.
>
>
> --
>
>
Hi Prabhu,
Try the below formula in cell B2.
=IF(AND(ISNUMBER(A2),LEN(A2)=5),--TEXT(A2,"MMDD"),"")
Drag the B2 cell formula to the remaining cells of B Column based on the
Column-A data.
At the same time the same is provided in the attached excel for better
understanding.
Hope that helps!
Hi Prabhu,
just convert those dates into below format using below formula.
lets say in col A17 thr is date thn in col B17 type this formula.
=TEXT(A17,"mmdd")
A B
5/29/2011 20110529
>
>From: Prabhu
>To: excel-macros@googlegroups.com
>Sent: Sun, 29 May, 20
Hi Prabhu,
Try the below formula in cell B2.
=TRIM(SUBSTITUTE(A2,CHAR(160),""))
At the same time the same is provided in the attached excel for better
understanding.
Hope that helps!
---
*Sixthsense
**:) Man of Extreme & Innovative Thoughts :)
*
On Sun, May 29, 2011 at 9:55 AM, Prabhu wrote:
HI Prabhu,
You can use the trim command...
and another solution is that u can use 'Text to columns' action under 'Data'
menu and then take fixed width...
On Sun, May 29, 2011 at 9:55 AM, Prabhu wrote:
> Hi Friends,
>
> I have attached a sheet, which contains space in prefix and suffix.
>
>
Hi
Try
Sub Format()
Dim LR, i As Long
LR = Range("A" & Rows.Count).End(xlUp).Row
For i = LR To 2 Step -1
Range("A" & i).Offset(0, 1).Value = Range("A" & i).Value
Range("A" & i).NumberFormat = "mmdd"
Range("A" & i).Offset(0, 1).NumberFormat = "mmdd"
Next i
End Sub
Thanks
Mahesh
On Sun, M
Hi Prabhu
Try
'=TRIM(SUBSTITUTE(A2,CHAR(160),CHAR(32)))
http://office.microsoft.com/en-us/excel-help/remove-spaces-from-the-beginning-and-end-of-a-cell-HP003056131.aspx
Thanks
Mahesh
On Sun, May 29, 2011 at 9:55 AM, Prabhu wrote:
> Hi Friends,
>
> I have attached a sheet, which contains sp
=VALUE(TEXT(A2,"MMDD"))
On May 29, 9:05 am, Prabhu wrote:
> Hi Friends,
>
> I have change my cell which in the date format ex.MMDD or DDMM to
> original number i.e smiler to
> type date.I have attached the sheet in which Column A shows date format and
> Column B is what i need to conv
=RANDBETWEEN(X,Y) Where X is a number greater than Y Example,
=RANDBETWEEN(1,500) will give random numbers ranging from 1 and 500
On May 29, 7:29 am, Suryaprasad wrote:
> Hi Experts,
>
> Need a formula or a code for the sample sheet Attached, this is about the
> generating a random based numbers
Dear Dew,
Rank is already starting from 1. Please check and revert with some
more details. Thanks.
Best Regards,
DILIPandey
On 5/20/11, dewbro2 wrote:
> How can I make this rank start with 1 instead of zero.
>
> On Jul 7 2010, 2:41 am, Dilip Pandey wrote:
>> HI Subbu,
>>
>> I hope you have f
HI
What are the changes required to get the result in a cell instead of msg box.
Regards
Rajesh kainikkara
On 5/28/11, GoldenLance wrote:
> This is because MAC addresses are attached physically to the network
> adapter hardware and not to the base computer itself. Computers with
> multiple ne
19 matches
Mail list logo
