Are you saying that you'd like a macro that:1) Prompts you to select a
folder.2) Opens all Excel files in the selected folder.
??
Paul-----------------------------------------
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-----------------------------------------
From: Chandra Shekar <chandrashekarb....@gmail.com>
To: excel-macros@googlegroups.com; rockerna...@gmail.com
Sent: Friday, August 28, 2015 4:24 AM
Subject: $$Excel-Macros$$ Re: Delivery Status Notification (Failure)
Hello, I need to select folder and wat ever excel files are there in that
folder I need to work on it. Is there any way to do this? Even I cannot able to
send mail to excel-macros group accidentaly i got unsubscribed may I know wat
is the procedure to subscribe again Regards, Chandru
On Fri, Aug 28, 2015 at 12:27 PM, Chandra Shekar <chandrashekarb....@gmail.com>
wrote:
Hello, I need to select folder and wat ever excel files are there in that
folder I need to work on it. Is there any way to do this? Regards, Chandru
On Wed, Aug 26, 2015 at 12:25 PM, Chandra Shekar <chandrashekarb....@gmail.com>
wrote:
Hello, I need to choose files from folder itself is there any way to do this?
Regards, Chandru
On Tue, Aug 25, 2015 at 2:09 PM, Mail Delivery Subsystem
<mailer-dae...@google.com> wrote:
Hello chandrashekarb....@gmail.com,
We're writing to let you know that the group you tried to contact
(excel-macros) may not exist, or you may not have permission to post messages
to the group. A few more details on why you weren't able to post:
* You might have spelled or formatted the group name incorrectly.
* The owner of the group may have removed this group.
* You may need to join the group before receiving permission to post.
* This group may not be open to posting.
If you have questions related to this or any other Google Group, visit the Help
Center at http://groups.google.com/support/.
Thanks,
Google Groups
----- Original message -----
X-Received: by 10.13.213.201 with SMTP id x192mr27147882ywd.12.1440491996057;
Tue, 25 Aug 2015 01:39:56 -0700 (PDT)
Return-Path: <chandrashekarb....@gmail.com>
Received: from mail-yk0-x22f.google.com (mail-yk0-x22f.google.com.
[2607:f8b0:4002:c07::22f])
by gmr-mx.google.com with ESMTPS id
v73si3005308ywa.3.2015.08.25.01.39.56
for <excel-macros@googlegroups.com>
(version=TLSv1.2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128);
Tue, 25 Aug 2015 01:39:56 -0700 (PDT)
Received-SPF: pass (google.com: domain of chandrashekarb....@gmail.com
designates 2607:f8b0:4002:c07::22f as permitted sender)
client-ip=2607:f8b0:4002:c07::22f;
Authentication-Results: gmr-mx.google.com;
spf=pass (google.com: domain of chandrashekarb....@gmail.com designates
2607:f8b0:4002:c07::22f as permitted sender)
smtp.mailfrom=chandrashekarb....@gmail.com;
dmarc=pass (p=NONE dis=NONE) header.from=gmail.com
Authentication-Results: mx.google.com;
dkim=pass header.i=@gmail.com
Received: by mail-yk0-x22f.google.com with SMTP id i184so148546847ykb.2
for <excel-macros@googlegroups.com>; Tue, 25 Aug 2015 01:39:56 -0700
(PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
d=gmail.com; s=20120113;
h=mime-version:in-reply-to:references:date:message-id:subject:from:to
:content-type;
bh=1OAj658jBw5p5ir9c33FWSlIdAWtFy0HTQiFZ4JPVx4=;
b=mx4dCzzgT4T5K0tqoECacpawFTZYKafHv217bV+6RWImcKFgpCPrN7bxpbAgaWwKkw
KFjljq1OnVtFa0hxZn52zgFBSs6yW3B5UFC2zXqJb4OEg2URMKYVaQoI7yQNiztZ91vI
308CxycsbauUudyZWv87bcdRFRrIvSZOlhfSdBMbgNXY6i2MkVrdVhwHPnVu6akq0axP
zhgktry9j+4eIm0eZGn2BAXyC3ASUpwxmNATs9bcM4olH/bDZTHdnLqbB9zRpHpY4lWN
m/TeUyk8popWbWbtpk+JSviiWoJbX2xqTzFpL010mkfaIWCSvGarqqWDt6/5TqVysn30
u8Og==
MIME-Version: 1.0
X-Received: by 10.129.44.139 with SMTP id s133mr35121531yws.161.1440491995939;
Tue, 25 Aug 2015 01:39:55 -0700 (PDT)
Received: by 10.37.105.65 with HTTP; Tue, 25 Aug 2015 01:39:55 -0700 (PDT)
In-Reply-To:
<cao32_wsr15acctznj72rz70h23a+gs7lacektsprxjxmjzr...@mail.gmail.com>
References: <cao32_wsid9trwxxfmkd16v7djxmi_rgcmkdzpoddgdg-7-t...@mail.gmail.com>
<1322010657.8505724.1440158164436.javamail.ya...@mail.yahoo.com>
<cao32_wsr15acctznj72rz70h23a+gs7lacektsprxjxmjzr...@mail.gmail.com>
Date: Tue, 25 Aug 2015 14:09:55 +0530
Message-ID: <CAO32_Wu6ku=z5x9npuyda6fmzu1owggh+d5a2ev7bwefzuj...@mail.gmail.com>
Subject: Re: $$Excel-Macros$$ Re: Error : FileDialog
From: Chandra Shekar <chandrashekarb....@gmail.com>
To: excel-macros@googlegroups.com
Content-Type: multipart/alternative; boundary=001a1141e82ab84d62051e1ead28
Hello,
I need to pick the folder and what ever excel file is there I need to work
on it. If I choose Filepicker I can able to choose only one file at a time
but I need to choose folder itself.
Regards,
Chandru
On Mon, Aug 24, 2015 at 12:09 PM, Chandra Shekar <
chandrashekarb....@gmail.com> wrote:
> Hello,
>
> Thanks for explaining it. Sorry for the late reply.
>
> Regards,
>
> Chandru
>
> On Fri, Aug 21, 2015 at 5:26 PM, Paul Schreiner <schreiner_p...@att.net>
> wrote:
>
>> I think the confusion is in the portion of the terms themselves:
>> msoFileDialogFilePicker
>> mso: Micro Soft Object
>> File: FileSYSTEM (not a "file")
>> Dialog: Interactive communication tool
>> File/Folder: Type of object to select.
>> Picker: purpose of the object
>>
>> So, basically, msoFileDialogFilePicker is a flag telling the Filesystem
>> Dialog method to return the name of a selected FILE,
>> msoFileDialogFolderPicker returns the name of a selected FOLDER.
>>
>> *Paul*
>> -----------------------------------------
>>
>>
>>
>>
>>
>>
>>
>> *“Do all the good you can,By all the means you can,In all the ways you
>> can,In all the places you can,At all the times you can,To all the people
>> you can,As long as ever you can.” - John Wesley*
>> -----------------------------------------
>>
>> ------------------------------
>> *From:* Chandra Shekar <chandrashekarb....@gmail.com>
>> *To:* excel-macros@googlegroups.com
>> *Sent:* Friday, August 21, 2015 12:55 AM
>> *Subject:* Re: $$Excel-Macros$$ Re: Error : FileDialog
>>
>> Hello,
>>
>> Its working now may I know what is different between
>> msoFileDialogFilePicker and msoFileDialogFolderPicker.
>>
>> Thanks in advance.
>>
>> Regards,
>>
>> Chandru
>>
>>
>>
>> On Thu, Aug 20, 2015 at 2:54 PM, Mandeep Baluja <rockerna...@gmail.com>
>> wrote:
>>
>> use this line
>>
>> Set diaFolder = Application.FileDialog(msoFileDialogFilePicker)
>>
>> regards,
>> mandeep baluja
>>
>>
>>
----- Message truncated -----
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.
