Home |
Search |
Today's Posts |
#1
|
|||
|
|||
problem with the command - method "UpdateFromFile"
Dear Friends!
I already asked for help with the method "UpdateFromFile". The aswer from a member of our group was: "help is OK". I am sorry, but I need a piece of code, containing the command. I am not shure what must precede the command!!! My old question is stil the same: I need to update ( with VBA ) actual sheet on local PC from the sheet which is located on the server on a shared harddisk. Method: UpdateFromFile in my code does not work properly. . Where could I find more complex information about this methhod (command)? I would be happy to see a piece of code including the command. Arnost Katolicky |
#2
|
|||
|
|||
Having looked at the Help on Excel VB the code it shows is (you've probably
seen it) ActiveWorkbook.UpdateFromFile There would be no preceeding code for it. Are you sure though that this is the function that you want to use? From readin help this seems only useful if the workbook is open in read-only and you want to update from the active workbook. Is this what you are trying to do? Do you want to (re-)post your code? J "Arnost Katolicky" wrote: Dear Friends! I already asked for help with the method "UpdateFromFile". The aswer from a member of our group was: "help is OK". I am sorry, but I need a piece of code, containing the command. I am not shure what must precede the command!!! My old question is stil the same: I need to update ( with VBA ) actual sheet on local PC from the sheet which is located on the server on a shared harddisk. Method: UpdateFromFile in my code does not work properly. . Where could I find more complex information about this methhod (command)? I would be happy to see a piece of code including the command. Arnost Katolicky |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Display Problem | Excel Discussion (Misc queries) | |||
Problem with Array Formulas and ISNUMBER | Excel Worksheet Functions | |||
Freeze Pane problem in shared workbooks | Excel Discussion (Misc queries) | |||
Row Autofit problem Excel 2003 | Excel Discussion (Misc queries) | |||
Paper Tray selection Problem, | Excel Discussion (Misc queries) |