Struck in the middle of xml creation

[Vinod]

Hi All,

I've been generating xml using Application.ExportXML statement. Macro will
create new folder and generates 1000 xmls as per data. After generating 20
files I'm getting following error " Error number 2001: You canceled the
previous operation".

How to resolve this?

My observation after facing the same issue 4 times:
Each xml generation has been taking 15 Sec.
scenario #1:
After 3 minutes I've looked at folder properties where xmls are generating

scenario #2:
After 5 minutes I've looked at 'C' drive properties where xmls are generating.

Please helme out by sharing your thought and ideas whill will be appreciated.

Advanced Thanks
Vinod

 

[Stefan Hoffmann]

hi Vinod,

I've been generating xml using Application.ExportXML statement. Macro will
create new folder and generates 1000 xmls as per data. After generating 20
files I'm getting following error " Error number 2001: You canceled the
previous operation".

Why do you have to create such a lot of XML files?

How to resolve this?

Maybe a timing issue, try calling DoEvents before or after creating each
file.


mfG
--> stefan <--

 

[Vinod]

Thanks Stefan for your response.

Could you please elaborate it you comment with example if possible?
Maybe a timing issue, try calling DoEvents before or after creating each

file.

In debug mode its working, I've written Debug.Print Now before and after
generating each xml.

Regards
Vinod

 

[a a r o n . k e m p f]

I use SQL Server and XML all the time-- it's just more powerful when
you use a real database

Select EmployeeID, FirstName, LastName
From Employees
Where DivisionID = 12
FOR XML AUTO

this works great in SQL Server-- maybe if you used a database with a
future (like SQL Server-- the worlds most popular database) then maybe
you wouldn't have to deal with Jet bugs that are a decade old

-Aaron

 

[Aaron Kempf knows nothing]

Would somebody come show me how to use computers. I get
so confused that I start posting all stupid and moronic answers
to questions I'll never have the brain power to understand.

 

[Vinod]

Hey Aaron I too have same feeling. We have to do some thing to change the
world of the forum script language. I believe that the change should start
from here only.