$$Excel-Macros$$ Re: Trovare l'errore

2014-03-28 Thread Stefano Tagliaferri
When I use the command 'SHELL' to execute an external function of the system, as I can know if this command was successful or if there were errors? I have tried to perform an upload from Excel using the command: Shell "ftp-s:" & MyFileTxt but how do I know if the upload was successful? th

$$Excel-Macros$$ Trovare l'errore

2014-03-28 Thread Stefano Tagliaferri
QUANDO SI usa il Comando 'SHELL' per eseguire Una Funzione Esterna di Sistema, vieni E POSSIBILE Sapere Se quel Comando E andato a buon fine oppure se ci Sono staticamente ERRORI? Io ho Provato d eseguire il caricamento delle Nazioni Unite da Excel Mediante il Comando: Shell "ftp-s:" & MyFileTx

Re: $$Excel-Macros$$ Help required on formula

2014-03-28 Thread Pramod Singh
hey what u want can u enplane complete... On Sat, Mar 29, 2014 at 8:08 AM, Jocky Beta wrote: > Hi, > I have already assigned formula but its showing error. > > Please help me. > > Regards > > > On Fri, Mar 28, 2014 at 1:51 PM, Jocky Beta wrote: > >> Hi, >> >> Please help me on this _ >> >> >>

Re: $$Excel-Macros$$ Help required on formula

2014-03-28 Thread Jocky Beta
Hi, I have already assigned formula but its showing error. Please help me. Regards On Fri, Mar 28, 2014 at 1:51 PM, Jocky Beta wrote: > Hi, > > Please help me on this _ > > > Regards > > > On Fiday, March 28, 2014, Jocky Beta wrote: > > Hi All, > > > > Pls fin above attached sheet in which Q

Re: $$Excel-Macros$$ error while sending email with gmail (using CDO)

2014-03-28 Thread Ricardo®
Hi, try change SmtpserverPort to 465. Basole On Fri, 28 Mar 2014 09:20:54 -0300, excel-macros@googlegroups.com wrote: > -- 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/dis

Re: $$Excel-Macros$$ error while sending email with gmail (using CDO)

2014-03-28 Thread priti verma
Hi , Thanks for reply.but now i am getting below error- "The transport failed to connect to the server." On Fri, Mar 28, 2014 at 5:07 AM, Ricardo(R) wrote: > Hi Priti Verma, try this: > > Sub sendmail() > Dim imsg As Object > Dim iconf As Object > Dim flds As Object > Dim schema As String > D

Re: $$Excel-Macros$$ error while sending email with gmail (using CDO)

2014-03-28 Thread Ricardo®
Hi Priti Verma, try this: Sub sendmail() Dim imsg As Object Dim iconf As Object Dim flds As Object Dim schema As String Dim stremailId As String Dim strpassword As String stremailId = InputBox("emailid") strpassword = InputBox("password") Set imsg = CreateObject("CDO.Message") Set iconf = Cre

Re: $$Excel-Macros$$ extracting zip codes from addresses

2014-03-28 Thread Naveen Kumar M N
Hi, can we try this also? =MID(B2,LEN(B2)-14,6) From Naveen On Fri, Mar 28, 2014 at 3:17 PM, joseph liech wrote: > thanks for your attention. > please help me. > > > On Thu, Mar 27, 2014 at 12:05 AM, Divaker Pandey wrote: > >> can you provide please sample file. >> >> Divaker >> >> >> On Wed,

RE: $$Excel-Macros$$ extracting zip codes from addresses

2014-03-28 Thread Ravinder
=LEFT(TRIM(RIGHT(SUBSTITUTE(B2," ",REPT(" ",100)),200)),SEARCH(" ",TRIM(RIGHT(SUBSTITUTE(B2," ",REPT(" ",100)),200 From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of joseph liech Sent: Friday, March 28, 2014 3:18 PM To: excel-macros@googlegroups.com Subj

Re: $$Excel-Macros$$ extracting zip codes from addresses

2014-03-28 Thread Anoop K Sharma
Hi Joseph, Please have a look at attached one.. The formula'll work for 5 digit Zip code only. On Fri, Mar 28, 2014 at 3:17 PM, joseph liech wrote: > thanks for your attention. > please help me. > > > On Thu, Mar 27, 2014 at 12:05 AM, Divaker Pandey wrote: > >> can you provide please sample fil

Re: $$Excel-Macros$$ extracting zip codes from addresses

2014-03-28 Thread joseph liech
thanks for your attention. please help me. On Thu, Mar 27, 2014 at 12:05 AM, Divaker Pandey wrote: > can you provide please sample file. > > Divaker > > > On Wed, Mar 26, 2014 at 5:51 PM, joseph liech wrote: > >> hi everyone >> >> i have looked around most postings here but none was similar to m

RE: $$Excel-Macros$$ Save only a few sheets

2014-03-28 Thread Ravinder
Pls provide attachement From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Stefano Tagliaferri Sent: Friday, March 28, 2014 12:05 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Save only a few sheets Hello! Sorry for my English (Google

Re: $$Excel-Macros$$ Help required on formula

2014-03-28 Thread Jocky Beta
Hi, Please help me on this _ Regards On Fiday, March 28, 2014, Jocky Beta wrote: > Hi All, > > Pls fin above attached sheet in which Query sheet when i type any word related to Item code ELEC0001 (Kindly see the master sheet) it will search the Item Name automatically. But when i put bulb it's

Re: $$Excel-Macros$$ Save only a few sheets

2014-03-28 Thread Anoop K Sharma
Share your Excel file On Fri, Mar 28, 2014 at 12:04 PM, Stefano Tagliaferri wrote: > > > Hello! Sorry for my English (Google translator)! > I would like to write an Excel macro that can save to a different folder > of the active, two or three sheets belonging to the folder where I'm > working. >