Search results

Hi Narayan, Thanks for your answer. Yes I did. As suggested in the two references, the array is declared as public in a separated module in which all the variable used in several procedure are declared. Another way to ask the question is: what should VBA forces to initialize a public variable...

Hi Serene, Instead of integrating the existing list in your randomization algorithm, I suggest you check its existence by a simple lookup. If the PIN exists, just recall the randomization routine , if not, the process continues. It could look like: sub random() randomization algorithm call...

Hi the forum, In the Workbook_Open event in ThisWorkbook, I fill an array defined as “Public arrmsg() as variant”. A debug.print confirms that the variable “arrmsg” contains the information. Problem. When I want to use an element of this array in a procedure belonging to another module (not in...

Problem solved. I changed the activeX combox in a dropdown form control. Harry

Hi the forum, In a VBA application, I create a new worksheet on each run. In this worksheet, an ActiveX combo box is created and populated by code. How can I capture the Change event on the combo box otherwhere than in the new sheet? Thanks in advance for your answers. Harry

Hi Sir JB7, Thanks for your answer. The document in reference explains how to read the properties in a specific environment. My goal is to modify the properties of an AVI file in a VBA procedure, apparently, it is not obvious. Have a nice weekend. Harry

Hi shrivallabha, Thanks for answering my post. I have carefully read the document referred by the hyperlink. Without having downloaded the dll, I fear that it is only working for OLE files and AVI or MP4 are not OLE.. It is not mentioned that this dll is for Office 2010. Finally, it poses...

Hi the forum, Is there a VBA function to change the metadata of (AVI) files, for example:author, subject, category)starting from an Excel spreadsheet It is perhaps important to know that these properties, although visible, are not accessible via the properties dialog. Thanks for any advice...

Hi dam_l Thanks for your answer. I found TigoTago tp retrieve the metadata but this soft doesn't export them. A very interesting function allows any change on some metadata. I start a new thread to automatize the changes with VBA Hi Marc L. Thanks for your advice. I change a little bit...

Hi the forum, I have many "AVI" family files with metadata specifying the location, date, ... Is it possible in Excel VBA - Either to read the metadata directly from the hard drive and use them for selection; - Either to extract them to feed an Excel spreadsheet. Thanks in advance for any...

Hi Shrivallabha, Some credit is indeed required to send a sms with skype. See my post above as response to Debraj Roy: sendsms is no more supported by skype4com. The only solution seems to be a command instruction. (http://dev.skype.com/desktop-api-reference#SENDING_SMS_MESSAGES) Regards Harry

Hello the forum, I want to thank everyone who was involved in this thread; thanks to Colin Legg which identified the problem or better the lack of problem. I persisted with VBA whether the retrieved information was probably related to another language. Many thanks to Debraj Roy and Narayan911...

Hi Debraj Roy, It's been a while since I'm working on the problem So I glean information on the net. It is so that the method suggested in your link is out-of-date "Re: sms from Excel Options le ‎07-08-2011 00:24 ..... it's not public knowledge that SendSms no longer works." The only...

Hi Debraj Roy, Thanks for your quick answer. I do not think whether it is a Declare problem.But you did not have all the elements. This is the advice coming from the Skype development platform. "Skype4COM may well be used in a 64 bit environment. Skype works itself into 32 bits. You have to...

Hello forum, In a Win7 and Excel 2010 both 64-bits environment, I have to use in a VBA procedure a 32-bits dll. To do this, I need to compile the VBA code in 32 bits. Could someone explain to me what this means and, more importantly, how to do that. Thank you in advance for your answers. Harry

Hi Phil, A suggestion, why don't use a pivot table with a calculated field "employee%*employee_effort". It should give: Row Labels Sum of Field1 100 50% 200 94% Hope it can help Harry

Hi Colin Legg, Nothing like a little slice of Excel for breakfast. My thanks are especially warm that your explanation is simple and understandable. I appreciate your suggestion to solve the problem with a pivot table. But this Excel approach is not operational; There sole purpose was to...

Hi SirJB7, On the bottom, you are absolutely right, the VBA solution should be preferred. My call to the forum had as sole purpose to understand why the SMALL function displays zero in case of positive values. Regards Harry

Hi the forum Hi SirJb7 I strongly agree with your comment on the elapsed time. In fact, I wrote a VBA routine to find the extreme min or max temperature by day. But as it is not easy to check the relevance of the results with a large amount of data, I imagined an Excel approach that should...

Hi Luke M Thanks or your answer. All the cells in the range contain date. I uploaded the file with DropBox. It can help to understand the problem https://www.dropbox.com/s/m1nwzh7zv72xga7/min%20per%20day.xlsx Regards Harry

Hi Alanna, for a table like this Aster 60 1,8 Aster 70 2 tulip 60 1,5 tulip 70 1,75 I suggest the sumproduct function: =SUMPRODUCT((A1:A4 = "tulip")*(B1:B4=60)*(C1:C4)) as array formula thus confirm with ctrl-shift-enter Regards Harry

Hi the forum, I want to retrieve the absolute min temperature per day from 1833 to 2012. The date and the min are in B2 to C65384 The day numbers are in F2-F32 and the month numbers are in G1-R1 I developed a formula to analyze the data: {=SMALL(IF((LEFT(TEXT($B$2:$B$65384;"dd/mm/yyyy");2)...

Hello the forum, Hi SirJB7, Thank you for your answer. As always, your rational approach allows you to get to the bottom of things and your explanations are very clear. If crosstabs are very useful for syntheses, calculated fields however limit the use of function, eg vlookup is not allowed...

Hi bobhc, Thank you for your answer. My Windows "Region and Language" settings require the semicolon in Excel formulas instead of the comma. So there is no difference between the two formulas. Best regards Harry

Hi bobhc If you open the link included in the first post, you will find that the formula you propose is exactly the same I used. It leads to an erroneous result and is the basis of my query on this forum. Thank you for your answer Have a nice weekend Harry