Error 440 Export destination file cannot be opened 1

[stewm]

I'm getting an annoying peice of code that refuses to work with me. I'm trying to save a simple report out to a .csv without any luck.

I'm getting Error: 440 Export destination file cannot be opened. The path is correct. I even tried just sending it to c:\ and still nothing. What could be the cause?

Dim objImpromptuApp as Object
Dim objImpromptuRep as Object

Set objImpromptuApp = CreateObject("CognosImpromptu.Application")
objImpromptuApp.Visible True
objImpromptuApp.OpenCatalog _
"F:\Reports\pkgsale.cat", _
C_BATCH_ID, _
C_BATCH_PW, _
C_BATCH_DB_ID , _
C_BATCH_DB_PW

Set objImpromptuRep = objImpromptuApp.OpenReport ("F:\Reports\Customer.imr",W8_Parm)
objImpromptuRep.Export "F:\Reports\Customer.csv", "x_ascii.flt"

objImpromptuRep.CloseReport
objImpromptuApp.CloseCatalog
Set objImpromptuApp = Nothing

Any suggestions? Thanks,


Mark Stewart
Senior Analyst
Consultants Club Corp.
Windsor, Ontario
Canada

http://www.consultantsclub.biz

 

[griffindm]

Mark,

In general this error only appears when the file cannot be written. Reasons include:
directory invalid
no OS write permissions
file already exists (kill file before writing!)

From what you've said, I would think only the last cause might be involved.

Dave G.



The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"
Want good answers? Read FAQ401-2487 first!

http://www.decisionsupportgroup.com

 

[stewm]

Turns out I'm not a part of the Windows group that you need to be in order to write to that folder.

Mark Stewart
Senior Analyst
Consultants Club Corp.
Windsor, Ontario
Canada

http://www.consultantsclub.biz