Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help Opening file on network
HI There Got some code off the forum here and modified but still can't get t work. Private Sub CommandButton3_Click() Dim sFile As String Dim Source As Range Dim Rdest As Range Set rSource = ThisWorkbook.ActiveSheet.Range("B2:I65") sFile = ThisWorkbook.Path & "\\Employee\Call Quality\Data.xls" Workbooks.Open sFile Set Rdest = ActiveWorkbook.Sheets(1).Range("A1") rSource.Copy.Rdest ActiveWorkbook.Close True End Sub Comes up with an error and highlights Workbooks.Open sFile Is it the path? Gurus help required Thanks Guys in advance -- Mikeic ----------------------------------------------------------------------- Mikeice's Profile: http://www.excelforum.com/member.php...fo&userid=2246 View this thread: http://www.excelforum.com/showthread.php?threadid=38896 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vista opening Excel Files across a network very slowly | Excel Discussion (Misc queries) | |||
Opening files from Network resource extremely slow | Excel Discussion (Misc queries) | |||
Opening read-only files on a network | Excel Discussion (Misc queries) | |||
excel 2007 opening files on network share | Excel Discussion (Misc queries) | |||
Opening a file in a macro (network) | Excel Discussion (Misc queries) |