请问下excel中的复制和粘贴操作怎么做呢?vba中的解释很郁闷怎么翻译成vc? Range("C2:F4").Select
Selection.Copy
Range("C5").Select
ActiveSheet.Paste
谢谢老牛...
Selection.Copy
Range("C5").Select
ActiveSheet.Paste
谢谢老牛...
解决方案 »
- 使用MoveTo和LineTo来画曲线,出现锯齿,如何才能消除锯齿,来使曲线平滑?
- VC中jpgdll.dll(将bmp文件转换为jpg)怎么会用呀?(有源代码最好了)
- 子窗口调用父窗口中的函数与构造函数传参的问题
- 有CString如何转换到char*,
- 各位,好!如何确定有滚动条的界面图片上点的象素,滚动条拖动了,图片某点的位置该怎样计算呢?
- 怎样根据IP地址(或MAC)知道是本机上的哪块网卡(当然本机上有多块网卡),或者根据网卡知道IP?
- Question about CWebBrowser2
- 一个奇怪的问题,我让D=1.732,double m_D=0.001*D=-9.2559631349318e+061
- -=-=求教!如何不通过文件全名(如他的后缀或其它方法)取得文件在系统图标中的索引=-=-=-=-=-=-=-
- 怎样通过mfc中的对话框去增删改查由通过odbc连接的数据库
- 显示PNG文件时怎么显示有透明度的图片?
- 一个关于WinMain的问题。
就是将Range("C2:F4").Select
Selection.Copy
Range("C5").Select
ActiveSheet.Paste
这段代码转换成vc代码:( 谢谢
http://www.vckbase.com/code/listcode.asp?mclsid=17&sclsid=1713&page=1
_Application app;
_Worksheet ws;
Range range;
range = ws.GetRange(COleVariant("C"), COleVariant("C"));
range.Select();
Selection selection;
selection.AttachDispatch(app.GetSelection());
selection.Copy();range = ws.GetRange(COleVariant("E"), COleVariant("E"));
range.Select();
COleVariant covOptional((long)DISP_E_PARAMNOTFOUND, VT_ERROR);
ws.Paste(covOptional, covOptional);
CRange range
CWorksheet sheet
CApplication m_ExcelApplication...
this->range = this->sheet.get_Range(COleVariant("B4"),COleVariant("E6"));
range.Select();CSelection selection;selection.AttachDispatch(this->m_ExcelApplication.get_Selection());
selection.Copy();this->range.get_Range(COleVariant("E4"),COleVariant("E4"));
range.Select();COleVariant covOptional2((long)DISP_E_PARAMNOTFOUND, VT_ERROR);
this->sheet.Paste(covOptional2,covOptional2);
http://support.microsoft.com/kb/178783
this->range = this->sheet.get_Range(COleVariant("B4"),COleVariant("E6"));
改为
this->range.AttachDispatch(this->sheet.get_Range(COleVariant("B4"),COleVariant("E6")));
range = this->sheet.get_Range(COleVariant("A1"),COleVariant("B10")); range.Select();
range.Copy(covOptional2); CRange range2;
range2 = this->sheet.get_Range(COleVariant("A11"),COleVariant("B21")); VARIANT vt2;
vt2.vt = VT_DISPATCH;
vt2.pdispVal = range2.DetachDispatch(); sheet.Paste(vt2,covOptional2); range2.ReleaseDispatch();
谢谢啦
谢谢啦