Its being created in this For loop:
FOR XclRow = 4 TO 0 STEP -1
CurrRowNo = 17 + XclRow
cRange_From = "A" + ALLTRIM(STR(CurrRowNo)) + ":B" +
ALLTRIM(STR(CurrRowNo))
.ActiveSheet.RANGE(cRange_From).SELECT
cRange_To = "A" + ALLTRIM(STR(CurrRowNo+ShiftCount)) ;
+ ":B" + ALLTRIM(STR(CurrRowNo+ShiftCount))
-----Original Message-----
From: ProfoxTech [mailto:[email protected]] On Behalf Of Richard Kaye
Sent: Friday, December 11, 2015 2:03 PM
To: [email protected]
Subject: RE: An Excel Automation Insert Issue...
How are you creating cRange_To?
--
rk
-----Original Message-----
From: ProfoxTech [mailto:[email protected]] On Behalf Of Kurt Wendt
Sent: Friday, December 11, 2015 2:00 PM
To: [email protected]
Subject: RE: An Excel Automation Insert Issue...
Hey Matt - thanks for your reply. I didn't yet get things fully sorted out. In
particular - I'm having a problem trying to move a set of Cells. I even tried
doing this in Excel - as a Macro - and then looking at the VBA code it produced
- and then tried to re-implement that in FoxPro - but, its not working and
giving me errors.
The VBA code line was:
Selection.Cut Destination:=Range("A12:B12")
I tried to implement in VFP as:
oExcel .Selection.Cut("Range(cRange_To)")
And even this way:
oExcel .Selection.Cut(cRange_To)
But, both of those are giving me errors. I know I'm close to the answer - just
not quite there...
And - sure - if you could point me to your VFUG articles - that would be cool
too!
Thanks,
Kurt
-----Original Message-----
From: ProfoxTech [mailto:[email protected]] On Behalf Of M Jarvis
Sent: Friday, December 11, 2015 1:41 PM
To: [email protected]
Subject: Re: An Excel Automation Insert Issue...
On Thu, Dec 10, 2015 at 10:45 AM, Kurt Wendt <[email protected]>
wrote:
> <snip>
> FYI - I did try searching the ProFox Archives - but, could not find a
> specific reference to the Insert command having to do with Automation.
> I found a reference to the VFUG website - and Matt Jarvis doing a
> whole series on Office Automation - but, I could not find that series
> after creating an account on VFUG!
>
> TIA,
> Kurt Wendt
> Consultant
>
I'm still here... I believe you said in another post that you thought you had
it sorted out. Not saying my series on VFUG will solve your issue but I can
probably dig up the articles if you like.
--
Matt Jarvis
Eugene, Oregon USA
--- StripMime Report -- processed MIME parts --- multipart/alternative
text/plain (text body -- kept)
text/html
---
[excessive quoting removed by server]
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/80838f1ca795b14ea1af48659f35166f266...@drexch02.corp.globetax.com
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
