Click here to Skip to main content
15,908,020 members
Home / Discussions / C / C++ / MFC
   

C / C++ / MFC

 
GeneralPorting VC++ 6.0 -> VC++.net 2003 Help Requested Pin
Larry J. Siddens28-Aug-03 4:27
Larry J. Siddens28-Aug-03 4:27 
GeneralRe: Porting VC++ 6.0 -> VC++.net 2003 Help Requested Pin
valikac28-Aug-03 6:12
valikac28-Aug-03 6:12 
Generalexcel automation Pin
act_x28-Aug-03 4:21
act_x28-Aug-03 4:21 
GeneralRe: excel automation Pin
will138328-Aug-03 4:33
will138328-Aug-03 4:33 
GeneralRe: excel automation Pin
David Crow28-Aug-03 7:19
David Crow28-Aug-03 7:19 
GeneralRe: excel automation Pin
Malcolm Smart22-Oct-04 11:37
Malcolm Smart22-Oct-04 11:37 
GeneralRe: excel automation Pin
David Crow22-Oct-04 11:42
David Crow22-Oct-04 11:42 
GeneralRe: excel automation Pin
Malcolm Smart28-Oct-04 2:49
Malcolm Smart28-Oct-04 2:49 
Thanks all for the time taken (again!). I managed to get this far cribbing code from here and there. I am virtually there in what I want to do - it's very basic...

A1 : D4 - a 4x4 grid. I can update any value no problem. When all cells are populated, I need to drop the first column, and move the remaining 3 columns along. The VBA for this is...


Range("B1:D4").Select<br />
Range("B1:D4").Cut Desitination:=Range("A1:C4")<br />
Range("A1:C4").Select



My interpretation (using the API) is

lpDisp = sheet.GetRange(COleVariant("B1") , COleVariant("D4")<br />
range.AttachDispatch(lpDisp);<br />
range.Select();<br />
range.Cut(COleVariant("A1:C4"));


and I get 'Cut method of Range class failed'.

Any chance of you spoon feeding me this last bit please?

Cheers







*********************************************
The sooner you fall behind, the longer you have to catch up.
GeneralDialog (Modal) based MFC Application, fails to respond properly to 'Minimize-All', 'Restore on click from taskbar-entry', etc Pin
ohadp28-Aug-03 3:34
ohadp28-Aug-03 3:34 
GeneralRe: Dialog (Modal) based MFC Application, fails to respond properly to 'Minimize-All', 'Restore on click from taskbar-entry', etc Pin
David Crow28-Aug-03 3:39
David Crow28-Aug-03 3:39 
GeneralRe: Dialog (Modal) based MFC Application, fails to respond properly to 'Minimize-All', 'Restore on click from taskbar-entry', etc Pin
ohadp28-Aug-03 3:51
ohadp28-Aug-03 3:51 
GeneralCreating and saving to a file Pin
NewHSKid28-Aug-03 2:29
NewHSKid28-Aug-03 2:29 
GeneralRe: Creating and saving to a file Pin
David Crow28-Aug-03 2:40
David Crow28-Aug-03 2:40 
GeneralRe: Creating and saving to a file Pin
NewHSKid28-Aug-03 2:55
NewHSKid28-Aug-03 2:55 
GeneralRe: Creating and saving to a file Pin
Ravi Bhavnani28-Aug-03 3:05
professionalRavi Bhavnani28-Aug-03 3:05 
GeneralRe: Creating and saving to a file Pin
David Crow28-Aug-03 3:06
David Crow28-Aug-03 3:06 
GeneralRe: Creating and saving to a file Pin
NewHSKid28-Aug-03 3:36
NewHSKid28-Aug-03 3:36 
GeneralRe: Creating and saving to a file Pin
David Crow28-Aug-03 3:41
David Crow28-Aug-03 3:41 
Generalchar to WCHAR Pin
arturapps28-Aug-03 2:27
arturapps28-Aug-03 2:27 
GeneralRe: char to WCHAR Pin
David Crow28-Aug-03 2:42
David Crow28-Aug-03 2:42 
Generalrun batch file contents from application...help experts Pin
rohit.dhamija28-Aug-03 2:17
rohit.dhamija28-Aug-03 2:17 
GeneralRe: run batch file contents from application...help experts Pin
David Crow28-Aug-03 2:23
David Crow28-Aug-03 2:23 
GeneralRe: run batch file contents from application...help experts Pin
rohit.dhamija28-Aug-03 2:49
rohit.dhamija28-Aug-03 2:49 
GeneralRe: run batch file contents from application...help experts Pin
David Crow28-Aug-03 2:54
David Crow28-Aug-03 2:54 
GeneralRe: run batch file contents from application...help experts Pin
rohit.dhamija28-Aug-03 3:10
rohit.dhamija28-Aug-03 3:10 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.