| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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!!! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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!!! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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!!! |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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!!! |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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!!! |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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!!! |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Link a Cell to Information on a Web page | Excel Discussion (Misc queries) | |||
| Link page header with cell contents | Excel Worksheet Functions | |||
| Link from Excel cell to page in PDF | Excel Worksheet Functions | |||
| if i sort cell that has link to another page how to keep link | Excel Discussion (Misc queries) | |||
| if i sort cell that has link to another page how to keep link | Excel Discussion (Misc queries) | |||
Hybrid Mode
