$$Excel-Macros$$ Re: SOS! Help! Loading another workbook in the current workbook - cells not updating!

2010-09-28 Thread LunaMoon
Anybody thanks? On Sep 27, 6:33 pm, LunaMoon wrote: > SOS! Help! Loading another workbook in the current workbook - cells > not updating! > > Hi all, > > Please help me. I have spent quite a few days on this but couldn't get > it work. > > On Excel file A.xls, I h

$$Excel-Macros$$ SOS! Help! Loading another workbook in the current workbook - cells not updating!

2010-09-27 Thread LunaMoon
SOS! Help! Loading another workbook in the current workbook - cells not updating! Hi all, Please help me. I have spent quite a few days on this but couldn't get it work. On Excel file A.xls, I have 5 file names(Excel files) in A1 to A5 on "sheet1"... and in that A.xls file I have the following V

$$Excel-Macros$$ How do I copy some cells(including formatting) and save as image file using VBA?

2010-09-24 Thread LunaMoon
How do I copy some cells(including formatting) and save as image file using VBA? Ultimately, I want to do that via COM or ActiveX server. Yet I think VBA is the starting point. So lets start from VBA. How to do that in VBA? I know how to open and close the Excel sheet. But what's the command i