Click to See Complete Forum and Search --> : msflexgrid - to do backup


DonRafouk
March 15th, 2001, 10:00 PM
Please help me with this code ..... the line

msfgrid.ApproxCount - 1 gives an error .....






iFileNumber = FreeFile

Open txtFileName For Output As #iFileNumber

For iNumRows = 0 To msfgrid.ApproxCount - 1

Print #iFileNumber, msfgrid.Columns(0).Text & "|" & msfgrid.Columns(1).Text & "|" & msfgrid.Columns(2).Text & "|" & msfgrid.Columns(3).Text & "|" & _
msfgrid.Columns(4).Text & "|" & msfgrid.Columns(5).Text & "|" & msfgrid.Columns(6).Text & "|" & msfgrid.Columns(7).Text & "|" & _
msfgrid.Columns(8).Text & "|" & msfgrid.Columns(9).Text & "|" & msfgrid.Columns(10).Text & "|" & msfgrid.Columns(11).Text & "|" & _
msfgrid.Columns(12).Text & "|" & msfgrid.Columns(13).Text & "|" & msfgrid.Columns(14).Text & "|" & msfgrid.Columns(15).Text & "|" & _
msfgrid.Columns(16).Text & "|" & msfgrid.Columns(17).Text & "|" & msfgrid.Columns(18).Text & "|" & msfgrid.Columns(19).Text & "|" & _
msfgrid.Columns(20).Text & "|" & msfgrid.Columns(21).Text & "|" & msfgrid.Columns(22).Text & "|" & msfgrid.Columns(23).Text & "|" & _
msfgrid.Columns(24).Text & "|"

DonRafouk

Iouri
March 16th, 2001, 07:11 AM
Instead of
For iNumRows = 0 To msfgrid.ApproxCount - 1
use
For iNumRows = 0 To msfgrid.Rows -1

Iouri Boutchkine
iouri@hotsheet.com

DonRafouk
March 16th, 2001, 08:11 PM
you are genius Iouri. yup, the code you gave me was good, I can do the backup. but I also did a bit of changes on the 'msfgrid.colums.text &' to 'msfgrid.coldata'

Thanks to the genius ........

P/s :Is there anyway I can buy you lunch?

DonRafouk

Iouri
March 17th, 2001, 10:02 AM
Any time. CAll me if you are in New York

Iouri Boutchkine
iouri@hotsheet.com