Re: $$Excel-Macros$$ Re: Create Multiple Excel Files from One file

2016-01-06 Thread Kalyan Dutta
Mandeep, Yes... It worked... Both the output files are showing Employee Id. Thank you so much for your help. I really appreciate your time,effort and attitude to help others. Regards, On Wed, Jan 6, 2016 at 5:07 AM, Mandeep Baluja wrote: > Let me know !! > > Sub

Re: $$Excel-Macros$$ Re: Create Multiple Excel Files from One file

2016-01-06 Thread Kalyan Dutta
Mandeep, Your code worked except small glitch. The output file of Craig Smith showing employee Id at the top of the file , whereas, Kelly Davis output file missing employee Id. See the attached file. On Wed, Jan 6, 2016 at 12:18 AM, Mandeep Baluja wrote: > Try This

Re: $$Excel-Macros$$ Re: Create Multiple Excel Files from One file

2016-01-06 Thread Mandeep Baluja
Let me know !! Sub CreateSheetsDemo() Dim wb As Workbook Dim wbtemp As Workbook Dim Workrng As Range Dim uniquename As Variant Dim Dic As Object Dim lr As Long: lr = Sheets("Order").Cells(Rows.Count, 4).End(xlUp).Row mypath = ThisWorkbook.Path & "\"

$$Excel-Macros$$ Merge cell entries & flash/blink cell for conditional formatting - no reply ??

2016-01-06 Thread big smile
-- Forwarded message -- From: big smile Date: 6 January 2016 at 11:23 Subject: $$Excel-Macros$$ Merge cell entries & flash/blink cell for conditional formatting To: excel-macros@googlegroups.com Respected all Can some body help me in this queries

Re: $$Excel-Macros$$ Download data of a Google sheet in excel sheet with VBA

2016-01-06 Thread Mandeep Baluja
Hey Devendra, The issues is while using a sendkeys method procedure send the keys one by one not once at that time. Therefore it is opening the compact controls of Google spreadsheet without going into actual control. Looking for the procedure which can process the keycombination at once :(.

Re: $$Excel-Macros$$ Download data of a Google sheet in excel sheet with VBA

2016-01-06 Thread Devendra Sahay
Hi Mandeep, I have tried to run this code & it running properly. Its opening the file but unable to download the file because we have given the Keys to (*File Menu+Download*) but there is another more options in- *Download As. * So how we will handle this issue. On Mon, Jan 4, 2016 at 3:31

Re: $$Excel-Macros$$ Re: Create Multiple Excel Files from One file

2016-01-06 Thread Mandeep Baluja
Glad to help !!! Regards, Mandeep baluja > -- 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/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread

Re: $$Excel-Macros$$ Excel Need to Assign Weekly OFF by Formula

2016-01-06 Thread mohd sadiq
Dera Team , Please help on the same On Mon, Jan 4, 2016 at 4:34 PM, mohd sadiq wrote: > Hello Pankaj , > > Pls help on the same > > On Thu, Dec 10, 2015 at 7:01 PM, mohd sadiq > wrote: > >> Hello , >> >> I need put Week OFF (WO) basis of

$$Excel-Macros$$ Client in Houston TX need Senior SCADA Engineer Need Locals

2016-01-06 Thread MADHU-GenuineItLlc
Hi Partner, Hope you are doing great … Please send resume to ma...@genuineitllc.com *Senior SCADA Engineer* *Location: Houston TX* *Duration: 12 months* *Need Locals in person interview MUST* On behalf of our client in the Oil and Gas sector we are is looking for a Senior SCADA

Re: $$Excel-Macros$$ Excel Need to Assign Weekly OFF by Formula

2016-01-06 Thread Pankaj Sharma
it's already done i think.. pfa *Pankaj Sharma * *MIS Analyst* *Greater Kailash-1, New Delhi* *Email * *p ankaj123...@gmail.com * *Skype** pankaj.sharma_pj* On Wed, Jan 6, 2016 at 6:15

$$Excel-Macros$$ Client in Peachtree City, GA need SAP WM Technical Consultant

2016-01-06 Thread MADHU-GenuineItLlc
Hi Partner, Hope you are doing great … Please send resume to ma...@genuineitllc.com *SAP WM Technical Consultant* *Location: Peachtree City, GA 30269* *Duration: 3 Months* *​* *Job Details* Works closely to ensure that the project(s) are delivered on-time, on-budget, and to the client’s