[The Phil]

I was going to make an excel file that would automatically list all of the profile files saved in my 2009 directory. I know that it is possible to get data from files using excel, but you need to know the location of the data. I was wondering if there was any information available that would tell me the location in the saved file of the status of the file (eg, carried forward, in partner review, completed). Is this information available?

Thanks

[Carl@Intuit]

If you are looking for the status you can use something like this:

Set FX09Client = FX09fileobj.Client
if FX09ClientClientStatus = csCompleted then
Status = "Completed"
end if...

It is an enumerated type so use the cs... to test for a certain status. Code hints in the VB editor will give you the list available.

[The Phil]

Carl@Intuit, on 12 March 2010 - 02:47 PM, said:

If you are looking for the status you can use something like this:

Set FX09Client = FX09fileobj.Client
if FX09ClientClientStatus = csCompleted then
Status = "Completed"
end if...

It is an enumerated type so use the cs... to test for a certain status. Code hints in the VB editor will give you the list available.

Thanks so much for resonding! I generally understand what you're saying. My experience with VB is limited so I'll if I can get it to work.