$$Excel-Macros$$ Client in SFO, CA need Senior Java Developer with Certification // Must have LinkedIn profile // 10+ yeras resume only

2016-03-29 Thread MADHU-GenuineItLlc
Hi Partner, Hope you are doing great … Please send resume to ma...@genuineitllc.com *Title : Senior Java Developer---** Must have LinkedIn profile* *Location :San Francisco, CA * *Duration :**5 months+* *10+ years as a Java software engineer* *Required Experience & Technical

$$Excel-Macros$$ Urgent need ServiceNow Consultant - Dallas, TX//need EAD,GC or USC.

2016-03-29 Thread MADHU-GenuineItLlc
*Title : ServiceNow consultant. * *Duration :Six months contract.* *This is a C2H position. so need EAD,GC or USC.* *Description * *Key Roles & Responsibilities**:* · Engage process owners and business stakeholders to translate business requirements into feasible functional

$$Excel-Macros$$ VERY URGENT -----Senior Filenet Architect -Hartford CT-Need GC or citizens

2016-03-29 Thread MADHU-GenuineItLlc
Hi Partner, Hope you are doing great … Please send resume to ma...@genuineitllc.com *Title :Senior Filenet Architect -Hartford CT Location: Hartford ,CT**Need GC or citizens * *Job Type:* FTE or C2H *Should be open to relocate or travel at customer location* *Description* ·

Re: $$Excel-Macros$$ Re: Need help

2016-03-29 Thread Paul Schreiner
 Ah... I think maybe we should rethink the logic here.In your statement:Set rngD = wshD.Range("G:G").Find(What:=Me.ComboBox1.Value, Lookat:=xlWhole)if Me.ComboBox1.Value is empty, you're looking in column G for "nothing".Does the .Find method return an empty range? or a range of which column G

$$Excel-Macros$$ Re: Need help

2016-03-29 Thread Karthik
Thanks Paul for your response.Here is the complete macro for better understanding. Sub Fetch_Click() Dim wshD As Worksheet Dim wshP As Worksheet Dim rngD As Range Dim rngP As Range Dim r As Long Dim m As Long Dim n As Integer Dim rngD2 As Range

Re: $$Excel-Macros$$ Need help

2016-03-29 Thread Paul Schreiner
Since I don't know anything about your workbook or the types of values, I'd suggest something like what follows.I've run into issues where Excel doesn't treat a "null" value and a "blank/empty" cell as the same.Plus, when using something like: wshD.Cells(r, "C")the "default" property is

Re: $$Excel-Macros$$ To Print .msg Files Saved in Folder

2016-03-29 Thread Paul Schreiner
Where did the .msg files come from?By looking online, it sounds like .msg files COULD be: MSG is a file extension for a mail message file format used by Microsoft Outlook and Exchange.  An MSG file can contain plain ASCII text for the headers and the main message body as well as hyperlinks and

Re: $$Excel-Macros$$ Help needed in Macro to send mails

2016-03-29 Thread Paul Schreiner
Mr. Shot: :) I don't believe you're being "ignored".I suspect it's more along the lines of:"How much effort do I/we have to put into trying to figure out what it is you want to do and do I/we have the expertise to address it". Your messages are a "little" confusing. You've posted a question on

Re: $$Excel-Macros$$ Help needed in Macro to send mails

2016-03-29 Thread Secret Shot
Hi Guys, Still waiting for some resolution in this group. Pls help. On Sat, Mar 26, 2016 at 12:46 AM, Secret Shot wrote: > Dear Experts, > > I want help in macro which can attach 4 mail with standard subject line > into one mail as an attachment and send that mail to a

Re: $$Excel-Macros$$ Query regarding auto hide rows in excell

2016-03-29 Thread GENIUS
http://www.techrepublic.com/blog/windows-and-office/excels-auto-outline-quickly-hides-data-details-to-simplify-viewing/ go to the above url or watch the following url on youtube https://www.youtube.com/watch?v=8j6KX6WDgEM -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?

$$Excel-Macros$$ To Print .msg Files Saved in Folder

2016-03-29 Thread Faisal Pk
Dear All, I have the below macro in excel which opens and takes print of a word file saved in a folder. In the same way i need to print .msg file saved in a folder, could you please guide me how to edit the macro to do the same. I am using Excel 2016. Appreciate if anybody could help me on this.

$$Excel-Macros$$ Need help

2016-03-29 Thread Karthik
Hello, I have formulated a macro to search data, from a worksheet, using user forms. User form has Date picker and couple of comboxes. Idea is to search between two dates along with two criterias. My problem is, macro doesnt function if I do not enter all the search criterias. Ideally, it