Re: $$Excel-Macros$$ Need help resolving runtime errors and crashes (or different approach)

Hi Sean you can use it will "all xls" or "all xlsx" On Fri, Oct 21, 2011 at 9:20 AM, Sean wrote: > Hi sir, and thank you for your assistance. > > I like your macro very much. Sadly, it does not bring joy. However, > it has helped me to discover that the problem is not with my system or > ve

Re: $$Excel-Macros$$ How to learn vba

Dear sandeep/Mr. excel, Please find attached Sheet with Example. -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Fri, Oct 21, 2011 at 11:13 AM, wrote

Re: $$Excel-Macros$$ How to learn vba

Dear Dilip, It wud have been gr8 if u also explain the codes in brief..when to use which type code. Thanks and regards CA Sandeep Kr Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: Dilip Pandey Sender: excel-macros@googlegroups.com Date: Fri, 21 Oct 2011 11:09:0

$$Excel-Macros$$ Restrict cell format not values

Hello members, Thanks for your great participation in the group. I have a query too. I want to restrict the cell format , so that user should not be able to change the format but enter the values. If the currency format is dollar or percent, the should be able to enter values only and should not

Re: $$Excel-Macros$$ How to learn vba

Hi, Below are the explanation of looping codes:- Looping codes Do While/ Until "conditon" Exit Do Loop ` Do - - Exit Do - - Loop While / Until "condition"

Re: $$Excel-Macros$$ Need help resolving runtime errors and crashes (or different approach)

Hi sir, and thank you for your assistance. I like your macro very much. Sadly, it does not bring joy. However, it has helped me to discover that the problem is not with my system or version of Excel. The problem is with the target files, which cause cause Excel to crash on opening. I suspect t

Re: $$Excel-Macros$$ Need help resolving runtime errors and crashes (or different approach)

As a follow-up, running the macro against files which have been converted (using OpenOfficeCalc) to .xls files produces a spreadsheet that is very useful, proving that my difficulty is not in the macro. And oh, how I wish I could use it against all the .xlsx files! Warm regards, -Sean- On Oct 20

Re: $$Excel-Macros$$ Digest for excel-macros@googlegroups.com - 18 Messages in 7 Topics

Hai Macros, I want to make the condittional formatting for A Coloumn in an Excel sheet, Condition is " It should only allow Alphabets [a-zA-z] and should not allow any special characters and numbers.Could you please help me out in this regard, Thanks Sai On 17 October 2011 05:05,

Re: $$Excel-Macros$$ Need help resolving runtime errors and crashes (or different approach)

hi Sean try this macro. select the folder which is having all the excel files. On Fri, Oct 21, 2011 at 2:08 AM, Sean wrote: > Hi and thanks for your interest in my post. > > I'm using in MSExcel 2007 and using code I've found in various forums > and published by MVPs, to perform some column

$$Excel-Macros$$ Re: HELP REQUIRED

Hi vijay, You can do that by using ASAP utilities. There are hosts of other features. below link is for you. http://www.asap-utilities.com/ hope this will meet your requirement. Regards Vishwanath On Oct 20, 8:49 pm, vijayajith VA wrote: > HI, > > I have 10 to 15 tabs with different name in one

$$Excel-Macros$$ Need help resolving runtime errors and crashes (or different approach)

Hi and thanks for your interest in my post. I'm using in MSExcel 2007 and using code I've found in various forums and published by MVPs, to perform some column copying . Some of the code were macros, and one is an add-in. All fail, but with different faults. I used a macro from Microsoft 'Merge

Re: $$Excel-Macros$$ How to learn vba

thanks setiyowati.for that link.Pls do update this mail when ever anybody comes across new linksThanks in advance. On Fri, Oct 21, 2011 at 4:36 AM, STDEV(i) wrote: > Dear Mr excel, > > You are welcome to visit your brother here > http://www.mrexcel.com/articles.shtml#VBA > > best regards > ~

Re: $$Excel-Macros$$ Removing specific characters from a string of text

Hello Zeunasc; Try the attached. Enter a start date in A2, & End date in A4. HTH Haseeb -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldaily

Re: $$Excel-Macros$$ How to learn vba

Dear Mr excel, You are welcome to visit your brother here http://www.mrexcel.com/articles.shtml#VBA best regards ~siti your fans from indonesia On Thu, Oct 20, 2011 at 8:21 AM, Mr excel wrote: > Thanks all,for the replies.i had been working with the VBA macro > recorder.Its really very funny

Re: $$Excel-Macros$$ Extract from date and time

Hello Arslan; If you have real dates & time, doesn't need MOD function. A1 = some date & time; eg: 4/11/2011 08:39:20 PM Use in B1 for date, format as date =INT(A1) Use in C1 for time; format as time =A1-B1 HTH Haseeb -- -

Re: $$Excel-Macros$$ querry

Hello Nemi; You can also use simple HLOOKUP. =HLOOKUP(C2,I$3:T$105,MATCH(A2,H$3:H$105,0)+B2,0) C2, here column heading & B2 is the row values located in Col_H HTH Haseeb -- -- Some important links for excel users:

Re: $$Excel-Macros$$ Run time code error

I, myself not being able to understand this. On Oct 20, 4:24 pm, Sam Mathai Chacko wrote: > Unable to comment further without proper understanding of what could be this > strange issue. > > Regards, > > Sam > > On Fri, Oct 21, 2011 at 1:51 AM, Prakash Gusain > wrote: > > > > > > > Sam, > > > thi

Re: $$Excel-Macros$$ HELP REQUIRED

yes very much possible with hardly 5 lines of code (if u want it for time being). send us the file or use the below code in the file if u can. Sub Macro1() ChDir "Your Path" Dim wrksht As Worksheet         For Each wrksht In ThisWorkbook.Worksheets     wrksht.Select     wrksht.Copy     Activ

Re: $$Excel-Macros$$ Run time code error

Unable to comment further without proper understanding of what could be this strange issue. Regards, Sam On Fri, Oct 21, 2011 at 1:51 AM, Prakash Gusain wrote: > Sam, > > this is still giving me the same error. > > My code worked on one of my friends machine but not on mine. I > believe there

Re: $$Excel-Macros$$ Run time code error

Sam, this is still giving me the same error. My code worked on one of my friends machine but not on mine. I believe there is some problem with the settings in my VB editor and that is what I want to figure out. Prakash On Oct 20, 4:05 pm, Sam Mathai Chacko wrote: > Doesn't seem to have a prob

Re: $$Excel-Macros$$ ActiveX component can't create object

Not tested. When you create the OutLook object, try using CreateObject("Outlook.Application.12") for 2007, or .11 for 2003 (assuming you have outlook in 2003) Regards, Sam On Thu, Oct 20, 2011 at 9:35 PM, deepu wrote: > Hi Friends, > > Recently I've installed MS-Excel 2003 application on my sys

Re: $$Excel-Macros$$ Run time code error

Doesn't seem to have a problem at my side. Anyway, slightly modified the code, removed unwanted lines Sub FillInternetForm() Dim objIE As Object Set objIE = CreateObject("InternetExplorer.Application") objIE.Navigate "http://www.cvent.com/RFP/NewSupplierRequest.aspx?vtt=1"; objI

Re: $$Excel-Macros$$ Extract from date and time

The best Answer so far by XLS S! On Oct 20, 1:24 pm, XLS S wrote: > for only date use int() > and time use mod fuction > > On Tue, Oct 18, 2011 at 3:02 PM, Muhammad Arslan > wrote: > > > > > > > > > Dear Experts > > I need to disjoint date and time form a text. Help me out how to tackle in > > e

$$Excel-Macros$$ Run time code error

Sub FillInternetForm() Dim objIE As Object Set objIE = CreateObject("InternetExplorer.Application") objIE.Navigate "http://www.cvent.com/RFP/NewSupplierRequest.aspx? vtt=1" objIE.Visible = True Do While objIE.busy While objIE.busy DoEvents Wend Loop objIE.

Re: $$Excel-Macros$$ Extract from date and time

for only date use int() and time use mod fuction On Tue, Oct 18, 2011 at 3:02 PM, Muhammad Arslan wrote: > > > > Dear Experts > I need to disjoint date and time form a text. Help me out how to tackle in > excel using formual. Text is following > > 4/11/2011 08:39:20 PM > > Help me out hoping for

Re: $$Excel-Macros$$ Do not support any request of breaking passwords

Sure Ayush. Regards, Sam Mathai Chacko (GL) On Thu, Oct 20, 2011 at 10:48 PM, Ayush Jain wrote: > Noorain, Imaraan, Anish, Sam, Jayandra and rest of the group, > > Please do not post or support any query on breaking password of excel vba > file. > This is against the rules of this group. > > T

$$Excel-Macros$$ Do not support any request of breaking passwords

Noorain, Imaraan, Anish, Sam, Jayandra and rest of the group, Please do not post or support any query on breaking password of excel vba file. This is against the rules of this group. This is not acceptable and may lead to ban from the group. Take Care. Thanks. Regards Ayush Jain On Thu, Oct

Re: $$Excel-Macros$$ queary about a jpg file into excel or pdf file

Hey Karan, that's great yaar !!! ] On Wed, Oct 19, 2011 at 9:48 AM, karan 1237 wrote: > Hey Anil, > > Convert your image files in excel through online or download a software > from the website below : > > http://www.onlineocr.net/ > > > http://www.cometdocs.com/ > > > http://www.coolutils.com/O

$$Excel-Macros$$ VBA from Excel 2003 to 2010

I have designed a number of macros in Excel 2003 and had no problems when I upgraded to 2007. However I am having problems reported for users using my macros in Excel 2010 I do not want to upgrade to Excel 2010 at this time and I was wondering if there is any compatabilty checker I can use in Exc

$$Excel-Macros$$ Job- Required Excel Expert

Hi Excel Experts, We need some data analyst, Please see below all description related to job, Interested candidate reply me with their Resume. Experience: 2 - 4 Years Location: Noida Education: UG- Btech, BCA, BBA, Bsc IT, PG- MCA, Msc IT, MBA Industry Type: IT-Consulting Company

Re: $$Excel-Macros$$ Removing specific characters from a string of text

As a follow up question, I have to do this review once a quarter, and the remark dates will change. How would I, programmatically, parse out the date string, then use that in an if/then... say, if this line contains a date between 10/01/2011 and 12/31/2011. I know that the values are strings, so

Re: $$Excel-Macros$$ Removing specific characters from a string of text

Both of these solutions work great... should have paid more attention to the built in functions! Thank you both! On Oct 20, 4:23 am, NOORAIN ANSARI wrote: > Dear Zeunasc, > > Another Solution.. > =SUBSTITUTE(A1,"remark 10/19/2011"," ") > > -- > Thanks & regards, > Noorain Ansari >  *http://ex

$$Excel-Macros$$ ActiveX component can't create object

Hi Friends, Recently I've installed MS-Excel 2003 application on my system however I already MS-Excel 2007 on my system, now I can use both the versions, however I've noticed while developing a code that I'm not able create objects of other applications in MS-Excel, i.e., I's writing a code to con

Re: $$Excel-Macros$$ Doubt

Dear Bheema, Please try through below Link.. http://www.control.com/thread/1026218679 -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Thu, Oct 20, 2011

Re: $$Excel-Macros$$ Doubt

I am using 2003 office. On Thu, Oct 20, 2011 at 7:05 PM, NOORAIN ANSARI wrote: > Dear Bheema, > > It is possible,,, > In MS Access 2007 > > Goto : *Database Tools*-*Visual Basic*-In Right part Collaspe all > fields-Right Click and Project Properties-Protection and Set password with > Che

Re: $$Excel-Macros$$ querry

Sure SAM, Array is not necessary for thi. On Thu, Oct 20, 2011 at 7:48 PM, Sam Mathai Chacko wrote: > Formula =OFFSET(INDEX($H$1:$H$105,MATCH($A2,$H$1:$H$105,0)),$B2,$C2) > > > On Thu, Oct 20, 2011 at 4:13 PM, Sam Mathai Chacko wrote: > >> Don't think we need an array for that. Here's a simple f

Re: $$Excel-Macros$$ querry

Formula =OFFSET(INDEX($H$1:$H$105,MATCH($A2,$H$1:$H$105,0)),$B2,$C2) On Thu, Oct 20, 2011 at 4:13 PM, Sam Mathai Chacko wrote: > Don't think we need an array for that. Here's a simple formula that will > look from all the 7 tables without an array formula. > > Regards, > > Sam Mathai Chack (GL) >

Re: $$Excel-Macros$$ querry

Don't think we need an array for that. Here's a simple formula that will look from all the 7 tables without an array formula. Regards, Sam Mathai Chack (GL) On Thu, Oct 20, 2011 at 2:18 PM, dguillett1 wrote: > Please see my corrected macro solution? > > > Don Guillett > SalesAid Software > d

Re: $$Excel-Macros$$ Doubt

You cannot make the file/database an executable. However, like Noorain mentioned, you can password protect your VBA modules. None of the VBA environments in office (at least till 2011) has the feature to create an executable file like VB. Regards, Sam Mathai Chacko (GL) On Thu, Oct 20, 2011 at

Re: $$Excel-Macros$$ Doubt

Dear Bheema, It is possible,,, In MS Access 2007 Goto : *Database Tools*-*Visual Basic*-In Right part Collaspe all fields-Right Click and Project Properties-Protection and Set password with Checked Lock Project for viewing. -- Thanks & regards, Noorain Ansari *http://excelmacroworld.b

$$Excel-Macros$$ Doubt

Hai all. My query relates to MS ACCESS. Friends, how to make the MSACCESS designed form application an executable one. means how to hide code part. Because I made a form and want to give other users in my office. If anything went wrong my effort will goes to waste. So, I want to hide the code p

Re: $$Excel-Macros$$ Extract (Text & Numbers)

Thanks a lot neil but there is a query (Pincode) which has not solved yet. I've to extract Pin Code from the text as I'v written on mail & worksheet. Kindly help me in this. Thanks Kaяan

Re: $$Excel-Macros$$ Extract (Text & Numbers)

Hi Karan, Please find the attached sheet. I am trying my level best to help you . On Thu, Oct 20, 2011 at 1:55 PM, karan 1237 wrote: > Dear all, > > Help me in this..! > > > Kaяan > > >

Re: $$Excel-Macros$$ Extract (Text & Numbers)

Dear all, Help me in this..! Kaяan

Re: $$Excel-Macros$$ Removing specific characters from a string of text

Dear Zeunasc, Another Solution.. =SUBSTITUTE(A1,"remark 10/19/2011"," ") -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Thu, Oct 20, 2011 at 12:4

Re: $$Excel-Macros$$ Removing specific characters from a string of text

Hi, Try this: =REPLACE(A1, FIND("remark 10/19/2011", A1), LEN("remark 10/19/2011"), "") Regards, Swapnil. On Thu, Oct 20, 2011 at 12:43 AM, Zeunasc wrote: > I know that this is relatively easy, but it has been years since I > have done any Excel VBA. I am parsing out some firewall rules, an

Re: $$Excel-Macros$$ querry

Dear Nemi, Please see attached sheet with Solution as per your requirement. i hope it will help to u. -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Th