Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Get a workbook to import data when openeing and export when closi.
How can I get excell to import data from a closed workbook. Then when changes
have been made, export and save the data to the workbook the data came from, overwriting what is contained in it. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Get a workbook to import data when openeing and export when closi.
why not just open the closed WB with code, make all the
changes with code the save and close the WB with code. ChDir "S:\PUBLIC\Some" Workbooks.Open Filename:="\\data\PUBLIC\youfile.xls" put code to make changes goes here ActiveWorkbook.Save ActiveWorkbook.Close -----Original Message----- How can I get excell to import data from a closed workbook. Then when changes have been made, export and save the data to the workbook the data came from, overwriting what is contained in it. . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Get a workbook to import data when openeing and export when closi.
I cant do that as the code that is in the current workbook is written in a
way that it has to be the only one open. Otherwise it falls over with Run Time errors. If it where that easy I would not be bald from pulling my hair out. :-) " wrote: why not just open the closed WB with code, make all the changes with code the save and close the WB with code. ChDir "S:\PUBLIC\Some" Workbooks.Open Filename:="\\data\PUBLIC\youfile.xls" put code to make changes goes here ActiveWorkbook.Save ActiveWorkbook.Close -----Original Message----- How can I get excell to import data from a closed workbook. Then when changes have been made, export and save the data to the workbook the data came from, overwriting what is contained in it. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import and Export Text data | Excel Discussion (Misc queries) | |||
Import / export data | New Users to Excel | |||
import/export data from a workbook | Excel Discussion (Misc queries) | |||
data import and export in to access | Excel Discussion (Misc queries) | |||
Create workbook for data export and then data import? | Excel Programming |