Hi,
If someone could provide me with a solution for this it would be much appreciated. I have some excel templates that dump information into another local excel workbook (collection.xls) on the sheet named "datasheet". I use a button on the template with the following code to carry over information from specific cells in the template into specific fields in the "datasheet":
Private Sub CommandButton1_Click()
Application.ScreenUpdating = False
Dim x As String
Dim rngSheetName As Range
Dim c As Range
Dim ws As Worksheet
Dim rng As Range
Dim wb As Workbook
Dim source As String
Set wb = Workbooks("Collection.xls")
Set ws = Workbooks("Collection.xls").Worksheets("Datasheet")
Set rngSheetName = ws.Range("G16:G40")
source = ("Template.xls")
My question is, what if the workbook "Collection.xls" was not local and was on a server, how would I modify this code to point to it? Is it possible to do this remotely with excel and would I be able to maintain two way communication between the files. Thanks
If someone could provide me with a solution for this it would be much appreciated. I have some excel templates that dump information into another local excel workbook (collection.xls) on the sheet named "datasheet". I use a button on the template with the following code to carry over information from specific cells in the template into specific fields in the "datasheet":
Private Sub CommandButton1_Click()
Application.ScreenUpdating = False
Dim x As String
Dim rngSheetName As Range
Dim c As Range
Dim ws As Worksheet
Dim rng As Range
Dim wb As Workbook
Dim source As String
Set wb = Workbooks("Collection.xls")
Set ws = Workbooks("Collection.xls").Worksheets("Datasheet")
Set rngSheetName = ws.Range("G16:G40")
source = ("Template.xls")
My question is, what if the workbook "Collection.xls" was not local and was on a server, how would I modify this code to point to it? Is it possible to do this remotely with excel and would I be able to maintain two way communication between the files. Thanks