Struck in the middle of xml creation

  • Thread starter Thread starter Vinod
  • Start date Start date
V

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
 
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".
Click to expand...
Why do you have to create such a lot of XML files?
How to resolve this?
Click to expand...
Maybe a timing issue, try calling DoEvents before or after creating each
file.


mfG
--> stefan <--
 
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.
Click to expand...

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

Regards
Vinod
 
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
 
a a r o n . k e m p f @ g m a i l . c o said:
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.
Click to expand...
 
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.
 
Back
Top