gimli
04-05-2010, 11:32 AM
Hi all,
can someone help out with the following code
' code blah blah blah here
TgtBk.Sheets("Imported Data").Range("C3").Resize(225, 27) = Ray 'Change(225, 27), to suit columns and rows
Workbooks("test.xls").Close
End Sub
When the work book test.xls closes, I get a question box asking if I want to save changes. Is there some code to answer this question with no user interaction? also doing this in the backround so nobody sees it would also be great.
thanks much
can someone help out with the following code
' code blah blah blah here
TgtBk.Sheets("Imported Data").Range("C3").Resize(225, 27) = Ray 'Change(225, 27), to suit columns and rows
Workbooks("test.xls").Close
End Sub
When the work book test.xls closes, I get a question box asking if I want to save changes. Is there some code to answer this question with no user interaction? also doing this in the backround so nobody sees it would also be great.
thanks much