commandbutton on workbook assistance
No problem!
"laughing gravy" wrote:
aha. Your a star.
thks
"Pflugs" wrote:
Try using workbook objects to make it easier to designate ranges. For
instance:
dim collectWB as Workbook, applyWB as Workbook
set collectWB = ThisWorkbook
'....collect data, etc
set applyWB = Workbooks.Open Filename:=(your file path here)
Then you can reference ranges using these workbook objects without having to
switch back and forth. For example, if you wanted to put the result into A1
on a sheet named "Total", you could use:
applyWB.sheets("Total").range("a1").value = result
'change this variable to work for you
Hope this helps.
Pflugs
"laughing gravy" wrote:
Hi
I've dropped a commandbutton onto a work book. The button collects data from
that work book when clicked and opens a different workbook to apply the data
collected on to the new workbook. Alls good until I program a range/cell I
want the data dumped into when I get an error 1004 message. The program still
seems to be pointing at the first workbook. Any ideas how I get it to focus
on the new workbook?
"laughing gravy" wrote:
Hi
I've dropped a commandbutton onto a work book. The button collects data from
that work book when clicked and opens a different workbook to apply the data
collected on to the new workbook. Alls good until I program a range/cell I
want the data dumped into when I get an error 1004 message. The program still
seems to be pointing at the first workbook. Any ideas how I get it to focus
on the new workbook?
|