RE: $$Excel-Macros$$ Macro to navigate through a Java Web-Page Options

2011-06-13 Thread Rajan_Verma
\Hope it will help you For Each oHTML_Element In HTMLDoc.getElementsByTagName(Export) If oHTML_Element.Type = submit Then

$$Excel-Macros$$ Job

2011-06-13 Thread ashish koul
Recruiter- Susan Monica susan.mon...@htcindia.com *Experience required for Job:* 1 - 5 years *Job Annual Salary:* 1.0 - 5.0 Lacs *Job location:* Singapore A marketing information company specialized in conducting customer service satisfaction surveys in various industries. Job: VBA Programmer

Re: $$Excel-Macros$$ Re: Data retrive from AccuWeather.com rain forcast

2011-06-13 Thread rajan verma
yeah.. it is possible.. On Mon, Jun 13, 2011 at 1:05 PM, Manish pansari.man...@gmail.com wrote: Hello EE, Pls suggest. Is it not possible ?? If its possible, I am ready to pay to devlop this module for me.. :) awaiting for your reply.. Regds, Manish Pansari +91 9810 88 8281 On Jun

Re: Fw: $$Excel-Macros$$

2011-06-13 Thread sandeep chhajer
dear excel guru, thanks for the reply and sorry for late reply. the macro only searches excel files containing the specified word but not pdf or doc file.I do need the same for pdf and doc file. thanks in advance. On 08/06/2011, ashish koul koul.ash...@gmail.com wrote: try this rename

$$Excel-Macros$$ Saving an Excel sheet as a UTF8 .txt and .csv - have code, need modifications!

2011-06-13 Thread Major Bandwith
Hi all, I have some Excel sheets that I want to save as a UTF8 file in .txt and .csv formats, using a VBA macro. I've found the following code: code starts 'Function saves cText in file, and returns 1 if successful, 0 if not Public Function writeOut(cText As String, file As String) As Integer

Re: $$Excel-Macros$$ Transpose Data by Formula

2011-06-13 Thread John A. Smith
STDEV(i), Excellent! Works like a charm. If I would like to add a formula to the total column, that would only pick up only the Order Qty amount, how would I do that? (the order number is a six digit number and adds to the total) I would use =SUMIF(A$25:Z$25,Order Qty,A26:Z26) after the fact,

$$Excel-Macros$$ help in vba coding and excel function

2011-06-13 Thread Bhushan Sabbani
Dear Excel Expert and Ashish, pls look into the above excel file If I am changing the % value in Q1,Q2,Q3, Jan Feb Mar then total changes in B16 but I want the total to be as in b3 for that I have to or the % value in d2 --

Re: RE: $$Excel-Macros$$ Please help to make my project good.

2011-06-13 Thread GoldenLance
=SUM(OFFSET(A5,0,0,MATCH(MAX(A$5:A$999),A$5:A$999,1),1)), copy this to A2, and then copy across to other cells -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links :

Re: $$Excel-Macros$$ Macro to navigate through a Java Web-Page Options

2011-06-13 Thread Don Flak
H, I tried the code and got a VB run-time error. Run-time error '424'; Object required There error highlights the yellow line below. Here is the code as I have it installed. ' TEST Macro ' Macro recorded 6/10/2011 by Don Flak ' ' Dim ie As Object Set ie =

$$Excel-Macros$$ List Box

2011-06-13 Thread Richard
I am trying to populate a list box with the results of a query. I have created the following code, which only populates the first column of a two column listbox. The items in MyArray are present for both bolumns. Dim MyArray() ReDim MyArray(mycount, 1) usrGLDist.lstOutput.ColumnCount = 2

RE: RE: $$Excel-Macros$$ Please help to make my project good.

2011-06-13 Thread Susan
Thank you! From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of GoldenLance Sent: Monday, June 13, 2011 7:14 AM To: excel-macros@googlegroups.com Subject: Re: RE: $$Excel-Macros$$ Please help to make my project good.