How to prevent download dialog box appearing with vba

[Alwexis]

Hello, I have a strange problem.

I have a connection to web API that downloads a file when i refresh it. I use a button with simple vba code to refresh it on demand. When i click on it, the download dialog box appears and i can choose to open/save/cancel.

However, when i run ANY other macro in this workbook that for example create another connection to this web API (but of course not to the download file method), the query for file download seems to "refresh" itself and suddenly the download dialog box appears...

I quoted "refresh" because i dont see it refreshing itself, just the dialog appears out of nowhere...

save.PNG

I disabled all background queries and i tried the Application.EnableEvents = False but it doesnt seems to work...

Any idea what is happening and how can i simply kill this dialog box with vba? The only situation when it should appear is when i manually click on Download button in my sheet...

Alex

[xladept]

Try:

Please Login or Register  to view this content.

And if that doesn't work then

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.