|
link to a cell in another page in vbe..
hi all !!
i need that !! how do i write in vb editor the link to a cell in another page.. like this: aWS.Range("C28") = C:\sourcepage\sheet1\cell_A27 i also need no edit link prompt in case that page doesn't exist... ty!!! |
link to a cell in another page in vbe..
hi pls123
the link to a cell in another page.. Another workbook I think ??? Maybe this give you a few ideas http://www.rondebruin.nl/summary2.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "pls123" wrote in message ... hi all !! i need that !! how do i write in vb editor the link to a cell in another page.. like this: aWS.Range("C28") = C:\sourcepage\sheet1\cell_A27 i also need no edit link prompt in case that page doesn't exist... ty!!! |
link to a cell in another page in vbe..
sure..
in another workbook... "Ron de Bruin" wrote: hi pls123 the link to a cell in another page.. Another workbook I think ??? Maybe this give you a few ideas http://www.rondebruin.nl/summary2.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "pls123" wrote in message ... hi all !! i need that !! how do i write in vb editor the link to a cell in another page.. like this: aWS.Range("C28") = C:\sourcepage\sheet1\cell_A27 i also need no edit link prompt in case that page doesn't exist... ty!!! |
link to a cell in another page in vbe..
Range("c28").Select
ActiveCell.FormulaR1C1 = _ "='C:\path\[workbookname.xls]Sheet1'!R27C1" "pls123" wrote: hi all !! i need that !! how do i write in vb editor the link to a cell in another page.. like this: aWS.Range("C28") = C:\sourcepage\sheet1\cell_A27 i also need no edit link prompt in case that page doesn't exist... ty!!! |
link to a cell in another page in vbe..
im sorry all i explained bad...
i need to copy paste that cell's value ... to here... and i need just visual basic..not formula... because i can have need to cancel other workbook but i need the value to stay.. ty "dmoney" wrote: Range("c28").Select ActiveCell.FormulaR1C1 = _ "='C:\path\[workbookname.xls]Sheet1'!R27C1" "pls123" wrote: hi all !! i need that !! how do i write in vb editor the link to a cell in another page.. like this: aWS.Range("C28") = C:\sourcepage\sheet1\cell_A27 i also need no edit link prompt in case that page doesn't exist... ty!!! |
link to a cell in another page in vbe..
you can open the workbook with the information you need copy the data you
need paste the values to the new location and then close the workbook Workbooks.Open Filename:= _ "C:\path\workbookwithinfo.xls" . Windows("workbookwithinfo.xls").Activate Range("your range here").Select Selection.Copy Windows("Book1").Activate Range("your destination range here").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False "pls123" wrote: im sorry all i explained bad... i need to copy paste that cell's value ... to here... and i need just visual basic..not formula... because i can have need to cancel other workbook but i need the value to stay.. ty "dmoney" wrote: Range("c28").Select ActiveCell.FormulaR1C1 = _ "='C:\path\[workbookname.xls]Sheet1'!R27C1" "pls123" wrote: hi all !! i need that !! how do i write in vb editor the link to a cell in another page.. like this: aWS.Range("C28") = C:\sourcepage\sheet1\cell_A27 i also need no edit link prompt in case that page doesn't exist... ty!!! |
link to a cell in another page in vbe..
IM WORKING ON IT ty p !!
"dmoney" wrote: you can open the workbook with the information you need copy the data you need paste the values to the new location and then close the workbook Workbooks.Open Filename:= _ "C:\path\workbookwithinfo.xls" . Windows("workbookwithinfo.xls").Activate Range("your range here").Select Selection.Copy Windows("Book1").Activate Range("your destination range here").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False "pls123" wrote: im sorry all i explained bad... i need to copy paste that cell's value ... to here... and i need just visual basic..not formula... because i can have need to cancel other workbook but i need the value to stay.. ty "dmoney" wrote: Range("c28").Select ActiveCell.FormulaR1C1 = _ "='C:\path\[workbookname.xls]Sheet1'!R27C1" "pls123" wrote: hi all !! i need that !! how do i write in vb editor the link to a cell in another page.. like this: aWS.Range("C28") = C:\sourcepage\sheet1\cell_A27 i also need no edit link prompt in case that page doesn't exist... ty!!! |
| All times are GMT +1. The time now is 10:38 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com