Re: $$Excel-Macros$$ copy data without opening file

[hanumant shinde]

thanks rajan. this is really great. i didnt know abt this. thanks again



>
>From: Rajan_Verma 
>To: excel-macros@googlegroups.com
>Sent: Tue, 5 July, 2011 12:53:47 PM
>Subject: RE: $$Excel-Macros$$ copy data without opening file
>
> 
>No, We cant Copy the data from Closed Workbook.. but we can get the Data by 
>Using Full Reference of cell .. Like
> 
>='C:\Users\Xl_Lover\Desktop\[ForDownload[Sheet1]]Sheet1'!A1
> 
> 
>From:excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
>Behalf Of ankur
>Sent: Tuesday, July 05, 2011 12:13 PM
>To: excel-macros@googlegroups.com
>Subject: Re: $$Excel-Macros$$ copy data without opening file
> 
>hi hanumant
>
>you may find this to be useful
>
>http://spreadsheetpage.com/index.php...a_closed_file/ 
>
>Have A Nice Time & Enjoy Life
>
>Regards:
>CMA Ankur Pandey
>(Someone Different)
>
>I'm not the best but i'm not like the rest~~
>
>
>On Tue, Jul 5, 2011 at 12:40 AM, hanumant shinde  
wrote:
>Hi friends,
>
>is there any way where we can copy data from closed workbook "A" and paste it
>into workbook "B" which is open?
>
>--
>--
>
>Some important links for excel users:
>1. Follow us on TWITTER for tips tricks and links : 
>http://twitter.com/exceldailytip
>2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>3. Excel tutorials at http://www.excel-macros.blogspot.com
>4. Learn VBA Macros at http://www.quickvba.blogspot.com
>5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
>To post to this group, send email to excel-macros@googlegroups.com
>
><><><><><><><><><><><><><><><><><><><><><><>
>Like our page on facebook , Just follow below link
>http://www.facebook.com/discussexcel
> 
>-- 
>--
>
>Some important links for excel users:
>1. Follow us on TWITTER for tips tricks and links : 
>http://twitter.com/exceldailytip
>2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>3. Excel tutorials at http://www.excel-macros.blogspot.com
>4. Learn VBA Macros at http://www.quickvba.blogspot.com
>5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
>To post to this group, send email to excel-macros@googlegroups.com
> 
><><><><><><><><><><><><><><><><><><><><><><>
>Like our page on facebook , Just follow below link
>http://www.facebook.com/discussexcel
-- 
>--
>
>Some important links for excel users:
>1. Follow us on TWITTER for tips tricks and links : 
>http://twitter.com/exceldailytip
>2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>3. Excel tutorials at http://www.excel-macros.blogspot.com
>4. Learn VBA Macros at http://www.quickvba.blogspot.com
>5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
>To post to this group, send email to excel-macros@googlegroups.com
> 
><><><><><><><><><><><><><><><><><><><><><><>
>Like our page on facebook , Just follow below link
>http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
<<~WRD000.jpg>>

Re: $$Excel-Macros$$ copy data without opening file

[hanumant shinde]

thanks ashish but i dont want to open it coz file is on server and it takes 
lots 
of time to open n close. so is there any way to reduce opening and closing 
time? 
file size is in few KB but it takes 1 min to open n close the file.



>
>From: ashish koul 
>To: excel-macros@googlegroups.com
>Sent: Tue, 5 July, 2011 1:32:58 PM
>Subject: Re: $$Excel-Macros$$ copy data without opening file
>
>
>i suggest you hide the workbook from which you are copying the data if you 
>dont 
>want to show it to the user 
>
> 
> 
>http://akoul.blogspot.com/search/label/Hide%20and%20Unhide%20a%20workbook%20in%20vba
>
> 
>
> 
>On Tue, Jul 5, 2011 at 12:53 PM, Rajan_Verma  wrote:
>
>No, We cant Copy the data from Closed Workbook.. but we can get the Data by 
>Using Full Reference of cell .. Like
>> 
>>='C:\Users\Xl_Lover\Desktop\[ForDownload[Sheet1]]Sheet1'!A1
>> 
>> 
>>From:excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
>>Behalf Of ankur
>>Sent: Tuesday, July 05, 2011 12:13 PM
>>To: excel-macros@googlegroups.com
>>Subject: Re: $$Excel-Macros$$ copy data without opening file
>> 
>>hi hanumant
>>
>>you may find this to be useful
>>
>>http://spreadsheetpage.com/index.php...a_closed_file/ 
>>
>>Have A Nice Time & Enjoy Life
>>
>>Regards:
>>CMA Ankur Pandey
>>(Someone Different)
>>
>>I'm not the best but i'm not like the rest~~
>>
>>
>>On Tue, Jul 5, 2011 at 12:40 AM, hanumant shinde  
>wrote:
>>Hi friends,
>>
>>is there any way where we can copy data from closed workbook "A" and paste it
>>into workbook "B" which is open?
>>
>>--
>>--
>>
>>Some important links for excel users:
>>1. Follow us on TWITTER for tips tricks and links : 
>>http://twitter.com/exceldailytip
>>2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>3. Excel tutorials at http://www.excel-macros.blogspot.com
>>4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>>To post to this group, send email to excel-macros@googlegroups.com
>>
>><><><><><><><><><><><><><><><><><><><><><><>
>>Like our page on facebook , Just follow below link
>>http://www.facebook.com/discussexcel
>> 
>>-- 
>>--
>>
>>Some important links for excel users:
>>1. Follow us on TWITTER for tips tricks and links : 
>>http://twitter.com/exceldailytip
>>2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>3. Excel tutorials at http://www.excel-macros.blogspot.com
>>4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>>To post to this group, send email to excel-macros@googlegroups.com
>> 
>><><><><><><><><><><><><><><><><><><><><><><>
>>Like our page on facebook , Just follow below link
>>http://www.facebook.com/discussexcel-- 
>>
>>--
>>
>>Some important links for excel users:
>>1. Follow us on TWITTER for tips tricks and links : 
>>http://twitter.com/exceldailytip
>>2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>3. Excel tutorials at http://www.excel-macros.blogspot.com
>>4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>>To post to this group, send email to excel-macros@googlegroups.com
>> 
>><><><><><><><><><><><><><><><><><><><><><><>
>>Like our page on facebook , Just follow below link
>>http://www.facebook.com/discussexcel
>>
>
>
>-- 
>
>Regards
> 
>Ashish Koul
>akoul.blogspot.com
>http://akoul.posterous.com/
>
>akoul.wordpress.com
>My Linkedin Profile
> 
> 
>PBefore printing, think about the environment.
 
>
-- 
>--
>
>Some important links f

Re: $$Excel-Macros$$ copy data without opening file

[hanumant shinde]

Hi Ankur,

this is FANTASTIC. thanks a lot.


>
>From: ankur 
>To: excel-macros@googlegroups.com
>Sent: Tue, 5 July, 2011 12:16:06 PM
>Subject: Re: $$Excel-Macros$$ copy data without opening file
>
>check this also
>one sample file and explanations is given
>http://www.vbaexpress.com/kb/getarticle.php?kb_id=454
>Have A Nice Time & Enjoy Life
>
>Regards:
>CMA Ankur Pandey
>(Someone Different)
>
>I'm not the best but i'm not like the rest~~
>
>
>
>On Tue, Jul 5, 2011 at 12:13 PM, ankur  wrote:
>
>hi hanumant
>>
>>you may find this to be useful
>>
>>http://spreadsheetpage.com/index.php...a_closed_file/ 
>>Have A Nice Time & Enjoy Life
>>
>>Regards:
>>CMA Ankur Pandey
>>(Someone Different)
>>
>>I'm not the best but i'm not like the rest~~
>>
>>
>>
>>
>>On Tue, Jul 5, 2011 at 12:40 AM, hanumant shinde  
>wrote:
>>
>>Hi friends,
>>>
>>>is there any way where we can copy data from closed workbook "A" and paste it
>>>into workbook "B" which is open?
>>>
>>>--
>>>--
>>>
>>>Some important links for excel users:
>>>1. Follow us on TWITTER for tips tricks and links : 
>>>http://twitter.com/exceldailytip
>>>2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>>3. Excel tutorials at http://www.excel-macros.blogspot.com
>>>4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>>5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>>To post to this group, send email to excel-macros@googlegroups.com
>>>
>>><><><><><><><><><><><><><><><><><><><><><><>
>>>Like our page on facebook , Just follow below link
>>>http://www.facebook.com/discussexcel
>>>
>>
>
-- 
>--
>
>Some important links for excel users:
>1. Follow us on TWITTER for tips tricks and links : 
>http://twitter.com/exceldailytip
>2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>3. Excel tutorials at http://www.excel-macros.blogspot.com
>4. Learn VBA Macros at http://www.quickvba.blogspot.com
>5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
>To post to this group, send email to excel-macros@googlegroups.com
> 
><><><><><><><><><><><><><><><><><><><><><><>
>Like our page on facebook , Just follow below link
>http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ copy data without opening file

[Venkatesan c]

Hi,

Just Try Copy &Paste it will work...

*Best Regards,*
*Venkat*
*
*

On Tue, Jul 5, 2011 at 12:40 AM, hanumant shinde wrote:

> Hi friends,
>
> is there any way where we can copy data from closed workbook "A" and paste
> it
> into workbook "B" which is open?
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*
*

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ copy data without opening file

[ashish koul]

i suggest you hide the workbook from which you are copying the data if you
dont want to show it to the user


http://akoul.blogspot.com/search/label/Hide%20and%20Unhide%20a%20workbook%20in%20vba



On Tue, Jul 5, 2011 at 12:53 PM, Rajan_Verma wrote:

>  *No, We cant Copy the data from Closed Workbook.. but we can get the Data
> by Using Full Reference of cell .. Like*
>
> * *
>
> *='C:\Users\Xl_Lover\Desktop\[ForDownload[Sheet1]]Sheet1'!A1*
>
> * *
>
> * *
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *ankur
> *Sent:* Tuesday, July 05, 2011 12:13 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ copy data without opening file
>
> ** **
>
> hi hanumant
>
> you may find this to be useful
>
> http://spreadsheetpage.com/index.php...a_closed_file/<http://spreadsheetpage.com/index.php/tip/a_vba_function_to_get_a_value_from_a_closed_file/>
> 
>
> [image: Image removed by sender. Reply With 
> Quote]<http://www.excelforum.com/newreply.php?do=newreply&p=2079066>
> 
>
>
> Have A Nice Time & Enjoy Life
>
> Regards:
> CMA Ankur Pandey
> (Someone Different)
>
> I'm not the best but i'm not like the rest~~
>
> 
>
> On Tue, Jul 5, 2011 at 12:40 AM, hanumant shinde 
> wrote:
>
> Hi friends,
>
> is there any way where we can copy data from closed workbook "A" and paste
> it
> into workbook "B" which is open?
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
> ** **
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com <http://akoul.blogspot.com/>
http://akoul.posterous.com/
*akoul*.wordpress.com <http://akoul.wordpress.com/>
My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830>


P Before printing, think about the environment.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
<<~WRD000.jpg>>

RE: $$Excel-Macros$$ copy data without opening file

[Rajan_Verma]

No, We cant Copy the data from Closed Workbook.. but we can get the Data by
Using Full Reference of cell .. Like

 

='C:\Users\Xl_Lover\Desktop\[ForDownload[Sheet1]]Sheet1'!A1

 

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of ankur
Sent: Tuesday, July 05, 2011 12:13 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ copy data without opening file

 

hi hanumant

you may find this to be useful

http://spreadsheetpage.com/index.php...a_closed_file/
<http://spreadsheetpage.com/index.php/tip/a_vba_function_to_get_a_value_from
_a_closed_file/>  

 <http://www.excelforum.com/newreply.php?do=newreply&p=2079066> Image
removed by sender. Reply With Quote


Have A Nice Time & Enjoy Life

Regards:
CMA Ankur Pandey
(Someone Different)

I'm not the best but i'm not like the rest~~



On Tue, Jul 5, 2011 at 12:40 AM, hanumant shinde 
wrote:

Hi friends,

is there any way where we can copy data from closed workbook "A" and paste
it
into workbook "B" which is open?

--

--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

 

-- 

--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
<<~WRD000.jpg>>

Re: $$Excel-Macros$$ copy data without opening file

[ankur]

hi hanumant

you may find this to be useful

http://spreadsheetpage.com/index.php...a_closed_file/
 [image: Reply With
Quote]

Have A Nice Time & Enjoy Life

Regards:
CMA Ankur Pandey
(Someone Different)

I'm not the best but i'm not like the rest~~


On Tue, Jul 5, 2011 at 12:40 AM, hanumant shinde wrote:

> Hi friends,
>
> is there any way where we can copy data from closed workbook "A" and paste
> it
> into workbook "B" which is open?
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ copy data without opening file

[hanumant shinde]

Hi friends,

is there any way where we can copy data from closed workbook "A" and paste it 
into workbook "B" which is open?

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel