Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automation remote saveing help needed
Hi,
Im trying to create a kind of price server in a central location on my netrwork as an Excel Sheet (Master) that i need updated from a few other identical looking sheets (remotes). Basically, i can get the info from the remote sheet(s) to the Master sheet, of which i have enabled the 'Share Workbook' function. My problem also i can use and change the info on the Master Sheet - the only way i can visually see the info on the Master sheet is if I physically save it at its pc location. This is no good to me. I need the Master worksheet to save everytime I change a figure on it and not just regular 5 minute intervals (the smallest interval setting there is). Ive tried to send the code remotely but that doesnt seem to help. Here is the code that i am using to connect with: Dim ExlMaster As Excel.Application Set ExlMaster = New Excel.Application With ExlMaster .Workbooks.Open Filename:="\\Kobra\Forwards Excel Master\Master.xls", Editable:=True End With ExlMaster.Quit Set ExlMaster = Nothing With this i can change all sorts of things and update the Master - but it only reflects the changes on the Master sheet itself is i manually press save in its workstation. If you can offer any suggestions i would be most grateful! Cheers Kelvin |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
saveing a spreadsheet as html want to keep the outline useable | Excel Discussion (Misc queries) | |||
problem saveing excell worksheet | Excel Discussion (Misc queries) | |||
Please help, Preparing properties automation needed? | Excel Discussion (Misc queries) | |||
Saveing workbook to a file as todays date daily | Excel Worksheet Functions | |||
Saveing a file (Confirm Replace) | Excel Programming |