Dear Experts
I am attaching an userform with 2 textboxes. While on exit from the first
textbox I have given a msgbox alert for not keeping the box empty. But the
setfocus event is not working for it. Kindly guide me.
regards
shankar sb
--
FORUM RULES (986+ members already BANNED for violation
-- Dear group ,
Anybody have mererial for imacros .
*Thanks&Regards*
* *
* **Veerendra.Vanam*
*TOC TEAM*
* * *Bhagyanagar Electrical & Contractors**
****H.No-5-9-286/65,Plot No-65
Rajiv Gandhi Nagar,Near Andhra Jyothi Press,IE-Kukat
Hi Priyanka,
Please try it..
Sub CopyFilesFolder2Folder()
Dim fso
Dim sfol As String, dfol As String
sfol = "c:\MyFolder" ' change to match the source folder path
dfol = "e:\MyFolder" ' change to match the destination folder path
Set fso = CreateObject("Scripting.FileSystemObject")
On Error Resum
ok
Thanks viper for the help..
it works perfectly. need one of your favor also ,if i need to move the
files from one drive to another drive then how it could be possible?
I have tried the below one
CLS
C:
CD move /-y "C:\Documents and
Settings\Administrator\Desktop\sample\*sample.xlsx" "D:\New
Dear Rajan sir,
Plz send any material for I-Macro
On Thu, Feb 16, 2012 at 9:38 PM, Rajan_Verma wrote:
> Try to learn I-Macro
>
> ** **
>
> Rajan
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *dguillett1
> *S
Hi,
The following subroutine will do that:
Sub GetReportCount()
On Error GoTo getMail_err
Dim ns As Namespace
Dim Inbox As MAPIFolder
Dim Item As Object
Dim Atmt As Attachment
Dim FileName As String
Dim i As Integer
Set ns = GetNamespace("MAPI")
Set Inbox = ns.GetDefaultFolder(olFolderInbox)
i
Hi Don
The code works great. Just going thru how it does things. Your help
appreciated.
Thanks
Charlie
On Fri, Feb 17, 2012 at 6:32 AM, dguillett1 wrote:
> See attached
> Sub GetRequestedItemSheetSAS()
> what = InputBox("Enter item ie: bolt")
> Sheets.Add
> With ActiveSheet
> .Name = wh
Hi Sam,
its realy Great ! super
Thanks Sam
Regards
chandru
On Thu, Feb 16, 2012 at 11:39 PM, Sam Mathai Chacko wrote:
> Yeah I understand that, you just had to use the formula as I said. Here's
> the attachment...
>
>
>
> =IFERROR(INDEX(database!A$1:A$2500,SMALL(IF(LEN(SUBSTITUTE(UPPER(dat
Maybe, at each worksheet_change in the cell>put the value in a next
available cell in column and a time stamp in the next column. Then, just use
sumproduct formula or vba to get the max value between times...
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message-
From
Use this formula as an array in c8 and drag across
=IFERROR(INDEX(database!A$1:A$2500,SMALL(IF(LEN(SUBSTITUTE(UPPER(database!$A
$1:$A$2500),UPPER(Sheet2!$E$3),""))mailto:excel-macros@googlegroups.com]
On Behalf Of chandra sekaran
Sent: Thursday, February 16, 2012 7:34 PM
To: excel-macros@google
Dear Prajakt,
Please see attached sheet with explanation.
On Thu, Feb 16, 2012 at 5:04 PM, Prajakt Pande wrote:
> Dear,
>
> Good job, can you tell me how you made this.
>
> Regards,
> Prajakt Pande
>
>
> On Thu, Feb 16, 2012 at 3:27 PM, Shaik Waheed wrote:
>
>> Hi,
>> Please chek it
>>
>> On Thu
very professional design!
how can this beauty make?
(hidden columns and rows, shading .)
üdv:
Tamás
This message was sent using my mailing program. If you do not receive them ,
please write me an e-mail!
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com
Using DDE, I have a cell that is constantly updated in a worksheet.
(It is a stock price) How do I access and manipulate the
information? For instance, if I want to know the high price that this
value achieved between 8:00AM and 8:30AM and place it in another cell
in the workbook, how would i do
Dear,
Good job, can you tell me how you made this.
Regards,
Prajakt Pande
On Thu, Feb 16, 2012 at 3:27 PM, Shaik Waheed wrote:
> Hi,
> Please chek it
>
> On Thu, Feb 16, 2012 at 4:39 PM, Sanjib Chatterjee <
> chatterjee.kolk...@gmail.com> wrote:
>
>>
>> Dear Experts,
>>
>> Please see the attac
Try to learn I-Macro
Rajan
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of dguillett1
Sent: Feb/Thu/2012 07:58
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ InternetExplorer-automation work-Some crtical
External web queries I do
Thanks Sam and Don both are working good.
Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: "dguillett1"
Sender: excel-macros@googlegroups.com
Date: Thu, 16 Feb 2012 08:42:20
To:
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Round o
You could also use a data>filter>filterby 14 copy/paste values
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Mohammed Muneer
Sent: Thursday, February 16, 2012 7:12 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ plz, help on this to solve..
Regards,
Muneer,
CC...
Or try this
Sub RoundUpNonFormulasSAS()
Cells.SpecialCells(xlCellTypeConstants, 1).NumberFormat = "0.00"
End Sub
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Sam Mathai Chacko
Sent: Thursday, February 16, 2012 8:06 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$
External web queries I do a lot. Send me the info and I’ll take a look
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Veeru TOC
Sent: Thursday, February 16, 2012 6:38 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ InternetExplorer-automation work-Some crtical
Dear
Hi,
Sub kTest()
Dim obWSShell As Object
Dim strDTop As String
Dim objFSO As Object
Dim objFldr As Object
Set obWSShell = CreateObject("WScript.Shell")
Set objFSO = CreateObject("scripting.filesystemobject")
strDTop = obWSShell.SpecialFolder
Sub NumRoundTwo()
Dim rng As Range
With ActiveSheet.UsedRange
If Not .SpecialCells(xlCellTypeConstants, 1) Is Nothing Then
For Each rng In .SpecialCells(xlCellTypeConstants, 1)
rng.Value = Round(rng.Value, 2)
Next rng
End If
End
Dear Sandeep,
Can you share a sample workbook..
On Thu, Feb 16, 2012 at 7:08 PM, wrote:
> Dear Excel gurus,
>
> I have a sheet with figures and formulas.
> I want a macro which can convert all the numbers in to round off up to two
> decimal but not the formulas.
>
>
> Like if in any cell va
Dear Excel gurus,
I have a sheet with figures and formulas.
I want a macro which can convert all the numbers in to round off up to two
decimal but not the formulas.
Like if in any cell value is 22.455
Macro should do +round(22.455,2) automatically.
But if it is sum(a2:a9). It should remain same
Process
1
Drag Combobox From Developer-Insert-Form 2 Select Combobox and goto
Developer-Properties and Select Areal List and select Cell Link Cell 3 create
formula =ADDRESS(2,8+H1)&":"&ADDRESS(100,8+H1) 4 Create Offset Function
=OFFSET($H$1,0,$H$1,COUNTA(INDIRECT($B$12)),1),Copy it and Paste i
Dear Sir/Madam,
can you please send PDF format instead of "rar format" the following link
http://www.mediafire.com/?bs2dpn9qbwhih0n
Regards,
kishore
On Thu, Feb 9, 2012 at 1:00 AM, Mahesh parab wrote:
> Hi
>
> You can download ebooks from below links
>
>- *Excel 2007 VBA Macro Pro
if your file name is exactly sample.xlsx then use
C:
CD "C:\Documents and Settings\priyanka\desktop\sample"
DEL /q /s /f "sample.xlsx"
On Thu, Feb 16, 2012 at 6:07 PM, The Viper wrote:
> is "C:\Documents and Settings\priyanka\desktop\sample" the right path of
> your master folder?
>
> if not,
is "C:\Documents and Settings\priyanka\desktop\sample" the right path of
your master folder?
if not, change the path first and then file name
On Thu, Feb 16, 2012 at 6:02 PM, PrIyAnKa wrote:
> What i need to change in it? only file name
>
> Only red highlighted words need to change ?
>
>
>
>
What i need to change in it? only file name
Only red highlighted words need to change ?
CLS
C:
CD "C:\Documents and Settings\priyanka\desktop\sample"
DEL /q /s /f "sample.xlsx"
change the path and you can use the wildcards like below
DEL /q /s /f "*sample.xlsx"
or
DEL /q /s /f "sample*.xlsx"
paste the below code in notepad and save it with .bat extension and run
CLS
C:
CD "C:\Documents and Settings\priyanka\desktop\sample"
DEL /q /s /f "sample.xlsx"
change the path and you can use the wildcards like below
DEL /q /s /f "*sample.xlsx"
or
DEL /q /s /f "sample*.xlsx"
On Thu, Feb 16
Dear Laxman
Will it delete folder? or excel file from folders?
and i have 239 folders and in all those folders there is a file,i want to
delete that file
Dear All
Can we have a macro which go through sub folders and delete any specific
excel file, without giving each 239 folders path
On Thu, Fe
Once again thank you Sir for quick reply. But would you please show me the
process.
Regards,
Sanjib
On Thu, Feb 16, 2012 at 4:57 PM, Shaik Waheed wrote:
> Hi,
> Please chek it
>
> On Thu, Feb 16, 2012 at 4:39 PM, Sanjib Chatterjee <
> chatterjee.kolk...@gmail.com> wrote:
>
>>
>> Dear Expe
Dear Sanjib.
See attached sheet.
On Thu, Feb 16, 2012 at 4:39 PM, Sanjib Chatterjee <
chatterjee.kolk...@gmail.com> wrote:
>
> Dear Experts,
>
> Please see the attachment. I like store AREA1, AREA2 AND AREA3 in a combo
> box or in Text Box.
>
> Base on the value store in the combo Box or list b
Hi,
Please chek it
On Thu, Feb 16, 2012 at 4:39 PM, Sanjib Chatterjee <
chatterjee.kolk...@gmail.com> wrote:
>
> Dear Experts,
>
> Please see the attachment. I like store AREA1, AREA2 AND AREA3 in a combo
> box or in Text Box.
>
> Base on the value store in the combo Box or list box I like the n
Hi Maries,
Can u tell me how did u do that..
On Thu, Feb 16, 2012 at 3:25 PM, Maries wrote:
> Find the attachments..
>
>
> On Thu, Feb 16, 2012 at 1:35 PM, chandra sekaran
> wrote:
>
>> Hi ,
>>
>> Here with attchaed file we need smal macro when i type first
>> Letter than shown start wit
Dear PrIyANkAtyr this
Sub Delete_Folders_FS()
objFolder = "D:\Documents and Settings\lakshman-\Desktop\New Folder\*.*"
Set objFSO = CreateObject("Scripting.FileSystemObject")
objFSO.deletefolder objFolder
End Sub
LAKSHMAN
From: PrIyAnKa
To: excel-macros@
Find the attachments..
On Thu, Feb 16, 2012 at 1:35 PM, chandra sekaran wrote:
> Hi ,
>
> Here with attchaed file we need smal macro when i type first Letter
> than shown start with first if type second letter then based on my
> cretria shown all list can any one help me
>
> Like i ha
Hi ,
Here with attchaed file we need smal macro when i type first Letter
than shown start with first if type second letter then based on my
cretria shown all list can any one help me
Like i have name list example
Name Moahn Mohan Kumar Mohan Doss Mathan Mathan Kumar Ashok ashok
Dear Team
I have a folder named "ABC" on desktop, in that ABC folder i have about 239
sub folders and in that folders there is a file named".(Folder
Name) Performance file ..
I want to delete all those files with one macro click.
Example : main folder ABC -
Sub Folders : A
Thanks Dave,
thanks a lot for responding, i have attached the file to demonstrate what i
want to achieve, basically what i want is when a stock is selected i want
the needle to move to price of the stock, the stock prices are within the
range specified in the file attached headed" prices".
On Th
39 matches
Mail list logo
