Hello,
I did something similar a few days ago, think that will work for you!
Set serverone = GetObject("\\server1\PLAN2010.xlsm")
Set servertwo GetObject("\\server1\PLAN2005.xlsm")
serverone.Worksheets("plan1").Cells(1, 1).Value =
servertwo.Worksheets("plan1").Cells(1, 1).Value
Application.DisplayAlerts = False
serverone.Close
servertwo.close
Application.DisplayAlerts = True
Att,
Ulisses Flores
לוהים הוא האש מכלה
-----Mensagem original-----
De: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] Em
nome de PowerProgrammerWes
Enviada em: terça-feira, 9 de fevereiro de 2010 17:46
Para: MS EXCEL AND VBA MACROS
Assunto: $$Excel-Macros$$ extracting data from a closed workbook
I have a workbook pulling api data on a server and would like to be
able to upon request, extract a range of data and paste into a
different workbook on a different computer (has access to server). Is
there a quick code to solve this issue. I do not want to have to open
the physical workbook on my active computer, simply pull from the
server computer.
-wes
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
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
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,700 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
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
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,700 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
