| Home |
| Search |
| Today's Posts |
|
|
|
#1
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
