VFPxWorkbookXLSX: "SaveTableToWorkbookEx" method shows Windows file copy dialogs

[Rajesh Karunakaran]

Dear all,

I am writing contents of a DBF file to a XLSX file using the VFPxWorkbookXLSX library.
When the "SaveTableToWorkbookEx" method is running, it shows the native Windows' file copy dialogs.



Is there a way to disable these?

 

[Scott24x7]

Do you have the source code for VFPxWorkbookSLSX?

 

[Rajesh Karunakaran]

Yes, it shows the code if I Set Step On.

 

[Scott24x7]

What instruction in the code results in this occurring?

Also, what is the state of the following:

SET TALK
SET SAFETY
SET NOTIFY

You can put in something like the following:
MESSAGEBOX("SET TALK =" + SET("TALK"))
... etc.
And it will give you the state, without SETTING STEP ON, which can sometimes alter what you get. (Who was it that said "The act of observation changes the outcome" What that Heisenberg? Oppenheim? My scientist quotes are a little rusty.)
I prefer to test these types of things "live" sometimes and avoid SET STP ON unless there is some kind of syntax or logic error I'm trying to track down.

 

[Rajesh Karunakaran]

Scott,

The following line causes the Windows native dialogs to appear.

loShell.NameSpace(tcZipFile).MoveHere(loFile, FOF_SILENT)

This is in the "AddFilesToZip" method.

Obviously, loShell is created as below

loShell  = CREATEOBJECT("shell.application")

 

[Scott24x7]

Rajesh, look at how the "MoveHere" works. This is likely utilizing Windows level call (whether you realize it or not). If you change how that works, then you can make this dialog disappear. But you aren't showing me the code, so I can't help you.