All,
I'm struggling with the following: I want to copy data from one workbook to another. Instead of programming the folder and workbook name as public constant in VB, I would like have textboxes in Excel where these folder and workbook names can be given. How do I do this?
This is how I programmed it now in a module, followed by some public subs to open the source workbook, copy the data etc. called by a commandbutton:
Public Const source_dir = "D:\My Documents\03 Klanten\Eurovet\data premix\"
Public Const source_file = "OEEpremixweek 2010.14.xls"
Public Const source_tab1 = "Week"
Public Const target_dir = "D:\My Documents\03 Klanten\Eurovet"
Public Const target_file = "Trends OEE Premix v04.xls"
Public Const target_tab1 = "historie"
In other words: in a sheet in Excel the user should be able to indicate in 4 textboxes what is going to be the source_dir, source_file, target_dir and target_file.
Bookmarks