If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Copying Data between Workbooks
As new versions of a spreadsheet system are released, I
would like to add a button that will allow a user to select the previous version ( file locations and name ) of the program and then have excel import the relevant data from that workbook to the new workbook. Any help would be appreciated. Thanks |
#2
|
|||
|
|||
Copying Data between Workbooks
You are a bit frugal with your info, why not just use
filename=Application.getopenfilename("Excel Files (*.xls), *.xls") you could also use an inputbox where you would put the path name etc However if you know where the old workbook is why not just hard code the macro to open the old file? -- No private emails please, for everyone's benefit keep the discussion in the newsgroup. Regards, Peo Sjoblom "Steve" wrote in message ... As new versions of a spreadsheet system are released, I would like to add a button that will allow a user to select the previous version ( file locations and name ) of the program and then have excel import the relevant data from that workbook to the new workbook. Any help would be appreciated. Thanks |
Thread Tools | |
Display Modes | |
|
|