| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Why get Ref in my cells ?
Hi group
I'm change the link on my Worksheets via VBA code and all in fine but the results are wrong. All the time get REF errors. Why don't get my Results ? Here is my code: Private Sub ChangeMyLinkBath() ActiveWorkbook.ChangeLink Name:= _ "C:\My Project\MODULO SDN-SCI\Productos Requeridos\Mecanica\Documentos\Bombas\H.C. Bombas SCI .xls" _ , NewName:= _ "C:\My Project\H.C. Bombas SCI .xls" _ , Type:=xlExcelLinks End Sub Any Advisor is Wellcome Mario |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Why get Ref in my cells ?
Hi Mario,
Are you sure the filenames are correct in your code? Try this in the Immediate Window (Ctrl+g from the VBE): ?Dir$("C:\My Project\MODULO SDN-SCI\Productos Requeridos\Mecanica\Documentos\Bombas\H.C. Bombas SCI .xls") ?Dir$("C:\My Project\H.C. Bombas SCI .xls") Do you get values for each of these statements, or does one of them return an empty string? -- Regards, Jake Marx MS MVP - Excel www.longhead.com [please keep replies in the newsgroup - email address unmonitored] Mario Reiley wrote: Hi group I'm change the link on my Worksheets via VBA code and all in fine but the results are wrong. All the time get REF errors. Why don't get my Results ? Here is my code: Private Sub ChangeMyLinkBath() ActiveWorkbook.ChangeLink Name:= _ "C:\My Project\MODULO SDN-SCI\Productos Requeridos\Mecanica\Documentos\Bombas\H.C. Bombas SCI .xls" _ , NewName:= _ "C:\My Project\H.C. Bombas SCI .xls" _ , Type:=xlExcelLinks End Sub Any Advisor is Wellcome Mario |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Why get Ref in my cells ?
Hi, Jake thanks for the response
?Dir$("C:\My Project\MODULO SDN-SCI\Productos Requeridos\Mecanica\Documentos\Bombas\H.C. Bombas SCI .xls") ?Dir$("C:\My Project\H.C. Bombas SCI .xls") don't return anything what is happenig , please let me know ..! Mario "Jake Marx" escribió en el mensaje ... Hi Mario, Are you sure the filenames are correct in your code? Try this in the Immediate Window (Ctrl+g from the VBE): ?Dir$("C:\My Project\MODULO SDN-SCI\Productos Requeridos\Mecanica\Documentos\Bombas\H.C. Bombas SCI .xls") ?Dir$("C:\My Project\H.C. Bombas SCI .xls") Do you get values for each of these statements, or does one of them return an empty string? -- Regards, Jake Marx MS MVP - Excel www.longhead.com [please keep replies in the newsgroup - email address unmonitored] Mario Reiley wrote: Hi group I'm change the link on my Worksheets via VBA code and all in fine but the results are wrong. All the time get REF errors. Why don't get my Results ? Here is my code: Private Sub ChangeMyLinkBath() ActiveWorkbook.ChangeLink Name:= _ "C:\My Project\MODULO SDN-SCI\Productos Requeridos\Mecanica\Documentos\Bombas\H.C. Bombas SCI .xls" _ , NewName:= _ "C:\My Project\H.C. Bombas SCI .xls" _ , Type:=xlExcelLinks End Sub Any Advisor is Wellcome Mario |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel: match two cells in one sheet to two cells in another and return a third cells value | Excel Worksheet Functions | |||
| compare 2 column cells and return the adjacent columns cells data of the cell | Excel Worksheet Functions | |||
| display a range of cells editible cells based on matching date | Excel Worksheet Functions | |||
| Setting of input cells as blue font and formula cells as black fon | Excel Discussion (Misc queries) | |||
| trying to create an (almost) circular formula between cells and data validated cells with lists | Excel Worksheet Functions | |||
Hybrid Mode
