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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help Opening file on network
Hi,
You have to change the current drive. Use ChDrive(Path) Regards Jean-Yves "Mikeice" wrote in message ... HI There Got some code off the forum here and modified but still can't get to 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. -- Mikeice ------------------------------------------------------------------------ Mikeice's Profile: http://www.excelforum.com/member.php...o&userid=22467 View this thread: http://www.excelforum.com/showthread...hreadid=388968 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help Opening file on network
If your file is on a network share as: \\employee\call quality\data.xls
Then change this line: sFile = ThisWorkbook.Path & "\\Employee\Call Quality\Data.xls" to just: sFile = "\\Employee\Call Quality\Data.xls" If your file is under the folder that contains the workbook that's running the code: Then change this line: sFile = ThisWorkbook.Path & "\\Employee\Call Quality\Data.xls" to just: sFile = ThisWorkbook.Path & "\Employee\Call Quality\Data.xls" (you had an extra backslash.) Mikeice wrote: HI There Got some code off the forum here and modified but still can't get to 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. -- Mikeice ------------------------------------------------------------------------ Mikeice's Profile: http://www.excelforum.com/member.php...o&userid=22467 View this thread: http://www.excelforum.com/showthread...hreadid=388968 -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help Opening file on network
Oops. I didn't notice the subject. Try the first suggestion.
Dave Peterson wrote: If your file is on a network share as: \\employee\call quality\data.xls Then change this line: sFile = ThisWorkbook.Path & "\\Employee\Call Quality\Data.xls" to just: sFile = "\\Employee\Call Quality\Data.xls" If your file is under the folder that contains the workbook that's running the code: Then change this line: sFile = ThisWorkbook.Path & "\\Employee\Call Quality\Data.xls" to just: sFile = ThisWorkbook.Path & "\Employee\Call Quality\Data.xls" (you had an extra backslash.) Mikeice wrote: HI There Got some code off the forum here and modified but still can't get to 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. -- Mikeice ------------------------------------------------------------------------ Mikeice's Profile: http://www.excelforum.com/member.php...o&userid=22467 View this thread: http://www.excelforum.com/showthread...hreadid=388968 -- Dave Peterson -- Dave Peterson |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help Opening file on network
Thanks guys You rock!! Worked perfectly : -- Mikeic ----------------------------------------------------------------------- Mikeice's Profile: http://www.excelforum.com/member.php...fo&userid=2246 View this thread: http://www.excelforum.com/showthread.php?threadid=38896 |
Reply |
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) |