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.
