Hello All,
Pl help & try to solve my problem.
Regards,
Suyog
On Tuesday, 25 March 2014 11:59:37 UTC+5:30, Suyog Kulkarni wrote:
>
> Hello Vicky,
>
> I'm not at all coping data from any where otherwise I would have used the
> "paste special". I'm pulling data from software & which some times
Hello! Sorry for my English (Google translator)!
I would like to write an Excel macro that can save to a different folder of
the active, two or three sheets belonging to the folder where I'm working.
It's possible? Thanks for your help
Stefano
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Exce
If you know which cells to copy, use this:
Sheets("Sheet1").Select
Range("A2:B20").Select
Selection.Copy
Sheets("Sheet2").Select
Range("A2").Select
ActiveSheet.Paste
On Tuesday, March 25, 2014 8:55:17 PM UTC+5:30, Kene wrote:
>
> I have a database and want to populate data int
SImple and good suggestion.
On Thursday, March 27, 2014 11:30:27 PM UTC+5:30, Rupesh Patil wrote:
>
> PFA,
>
>
>
>
> On Thu, Mar 27, 2014 at 8:19 PM, Capt. Jack Sparrow
>
> > wrote:
>
>> Hi Team,
>>
>> I need to extract only the text from the alphanumeric string, can you
>> please help me with
Hi All,
Pls fin above attached sheet in which Query sheet when i type any word
related to Item code ELEC0001 (Kindly see the master sheet) it will search
the Item Name automatically. But when i put bulb it's not showing any vale
as well as Item name also.
hence request you to kindly help me on th
If you'd add me on chat, you will know when I am online.
PS: The group doesn't need to be bothered about it, so let's just keep it
between us.
Thanks & regards,
Abhsihek
On Fri, Mar 28, 2014 at 12:31 AM, Prabhu Pinky wrote:
> Yea sure...please let me know your feasible time to contact.
> On 2
Yea sure...please let me know your feasible time to contact.
On 27-Mar-2014 11:32 PM, "Abhishek Jain" wrote:
> You may please contact me via chat.
>
> Thanks
>
>
> On Thu, Mar 27, 2014 at 10:30 PM, Prabhu Pinky wrote:
>
>> No abhi...since its official... Am unable to share...
>> On 27-Mar-2014 6:
A sample file would help understand better.
Thanks.
On Thu, Mar 27, 2014 at 8:28 PM, Tommy wrote:
> Hi,
>
> i am stuck on my project, an i am still a noob on VBA :P
>
> i have a userform with 4 textboxes and a combobox with 5 options that
> link each one to 5 sheets.
> Sheets (A,B,C,D and E)
You may please contact me via chat.
Thanks
On Thu, Mar 27, 2014 at 10:30 PM, Prabhu Pinky wrote:
> No abhi...since its official... Am unable to share...
> On 27-Mar-2014 6:00 PM, "Abhishek Jain" wrote:
>
>> Please provide more info or screenshot of the screen where you have to
>> input the dat
PFA,
On Thu, Mar 27, 2014 at 8:19 PM, Capt. Jack Sparrow wrote:
> Hi Team,
>
> I need to extract only the text from the alphanumeric string, can you
> please help me with a formula.
>
> Sample data attached
>
> 12Mum159 Mum 46Kol2335 Kol 63Ch270 Ch 180Del307 De
>
> Regards,
>
>
> --
> Ar
Ashish,
The code works great!!! How could it be modified to create a new Excel
document for each Word table discovered? Kindly advise. Thank you,
Michael
On Wednesday, October 2, 2013 1:09:44 AM UTC-4, ashish wrote:
>
> try this
>
> Sub import_word_table_to_excel()
> Application.DisplayAlert
No abhi...since its official... Am unable to share...
On 27-Mar-2014 6:00 PM, "Abhishek Jain" wrote:
> Please provide more info or screenshot of the screen where you have to
> input the date generating the report.
>
> Regards, Abhishek
>
>
>
> On Thu, Mar 27, 2014 at 5:41 PM, Prabhu Pinky wrote:
Hi,
i am stuck on my project, an i am still a noob on VBA :P
i have a userform with 4 textboxes and a combobox with 5 options that link
each one to 5 sheets.
Sheets (A,B,C,D and E)
Combobox with options ( 1,2,3,4 and 5)
textboxes (textnorth, textsouth,textwest and texteast)
when i choose opti
Hi Team,
I need to extract only the text from the alphanumeric string, can you
please help me with a formula.
Sample data attached
12Mum159 Mum 46Kol2335 Kol 63Ch270 Ch 180Del307 De
Regards,
--
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
Hi all,
Can someone tell me why i am getting this error---The "sendusing"
confugration value is invalid.
i am working on access version 2010.and using this code.
Sub sendmail()
Dim imsg As Object
Dim iconf As Object
Dim flds As Object
Dim schema As String
Dim stremailId As String
Dim strpasswor
Hi
You can format cell as DD-Mmm- or
you can use formula =text(ref,"DD-Mmm-) where ref is your reference
cell.
Thanks
On Thu, Mar 27, 2014 at 4:52 PM, Neeraj Chauhan
wrote:
> Dear experts,
>
>
>
> We have given below date format how to convert right format of date like
> 13-Jan-2014
Please provide more info or screenshot of the screen where you have to
input the date generating the report.
Regards, Abhishek
On Thu, Mar 27, 2014 at 5:41 PM, Prabhu Pinky wrote:
> Yes abhi...it shld be in vba excel. Pls help
> On 26-Mar-2014 3:30 PM, "Abhishek Jain" wrote:
>
>> Does it have
Yes abhi...it shld be in vba excel. Pls help
On 26-Mar-2014 3:30 PM, "Abhishek Jain" wrote:
> Does it have to be Excel VBA?
>
> I am sure there are many FTP clients that support automated and scheduled
> transfers (upload or download). If you want that I can look into some.
>
> Regards,
>
> Abhis
Dear experts,
We have given below date format how to convert right format of date like
13-Jan-2014
TT Modified Date & Time
13/01/2014
15/01/2014 19:51
2-Nov-14
1-Jun-14
2-Nov-14
15/01/2014 19:57
1-Jun-14
13/01/2014 17:10
15/01/2014 19:47
18/01/2014 15:44
From:
i means to say that u have know of vba excel web scrapting book .
i want to learn . web scrapting .
On Thu, Mar 27, 2014 at 3:21 PM, Divaker Pandey wrote:
> please explain what is your purpose.
>
> Divaker
>
>
> On Wed, Mar 26, 2014 at 10:45 AM, pramodb35 wrote:
>
>> Hi Excel Expert,
>>
>>
From: Neeraj Chauhan [mailto:neerajchauhan...@gmail.com]
Sent: Thursday, March 27, 2014 4:04 PM
To: 'excel-macros@googlegroups.com'
Subject: help required urgently
Dear experts,
We have givne below date format how to convert right format of date like
13-Jan-2014
TT Modified Date
1. change date format in d/mm/
2. change text to column
3.now use date function to combined date again
Divaker
On Thu, Mar 27, 2014 at 4:04 PM, Neeraj Chauhan
wrote:
> Dear experts,
>
>
>
> We have givne below date format how to convert right format of date like
> 13-Jan-2014
>
>
>
> TT Mo
Dear experts,
We have givne below date format how to convert right format of date like
13-Jan-2014
TT Modified Date & Time
13/01/2014
15/01/2014 19:51
2-Nov-14
1-Jun-14
2-Nov-14
15/01/2014 19:57
1-Jun-14
13/01/2014 17:10
15/01/2014 19:47
18/01/2014 15:44
Descr
Dear Vallinayagam
This sheet are password protected so I can not see the coding of copy paste.
Kindly provide the coding or file containing without password.
Thanks
Ashish
On Thu, Mar 27, 2014 at 3:28 PM, Vallinayagam wrote:
> Hi,
>
> Attached file contains a macro which will be useful for you
Priyanka pls find the formula
After subtracting the two dates
Day()*24+hour()*60+min()
On Mar 23, 2014 12:45 AM, "Abhishek Jain" wrote:
> Yes, it will. As long as the dates and times are in correct format so as
> Excel reads them as values to allow subtraction, it will work. I just used
> simple
please explain what is your purpose.
Divaker
On Wed, Mar 26, 2014 at 10:45 AM, pramodb35 wrote:
> Hi Excel Expert,
>
> I am Pramod. Any have idea that any kind of book available in market for
> Web scrpting by excel vba
> I am newly developer of excel vba. and also suggest me that can i use
>
best way to calculate date difference.
using text function.
See in attached sheet.
Divaker
On Thu, Mar 27, 2014 at 2:25 PM, Priyanka Sachdeva <
priyanka.sachdeva...@gmail.com> wrote:
> Thanks All ! .. It worked
>
>
> On Mon, Mar 24, 2014 at 9:22 AM, Ashish Kumar
> wrote:
>
>> Hi Priyanka,
>>
pfa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of ram sharma
Sent: Thursday, March 27, 2014 11:17 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ How to show numeric number larger than 20 digits in
CSV file
i have 20 digit number in
Thanks All ! .. It worked
On Mon, Mar 24, 2014 at 9:22 AM, Ashish Kumar wrote:
> Hi Priyanka,
>
> PFA
>
>
> Thanks
> Ashish
>
>
> On 23 March 2014 17:35, Priyanka Sachdeva
> wrote:
>
>> Thanks Abhishek,
>>
>> Yes, I did see the formula. Never knew it would be that straight forward
>>
>> Will gi
29 matches
Mail list logo