Issues with Application.DisplayAlert = False

**euro_andres** · 10-25-2012, 11:46 AM

Hi Community;

First of all I want to introduce myself, my name is Euro and I'm a Macro programmer beginner, having said that I want to thank all the forum community for the amazing amount of information that it is available here, even if this is my first post I ve been browsing the forums for knowledge for some days now.

Having said that, let s go to the point. This is the first Macro that I'm writing, and what it does is basically downloads data from the internet and arranges it in the appropiate format to create a Pivot Table from the database. I'm pretty satisfied with its performance, but I want to remove the annoying alert when it closes the workbook "Do you Want to save?" etc. In order to not have to be clicking the alerts while it downloads. However, when I add the Application.DisplayAlert = False into my code, the macro fails to copy the information to the database spreadsheet. The error is "1004 Microsoft Excel Cannot paste the data" (On the Underlined + Bold Statement below).
My Code :

Please Login or Register  to view this content.

**JBeaucaire** · 10-25-2012, 03:04 PM

How about:

Please Login or Register  to view this content.

**Winon** · 10-25-2012, 03:15 PM

There is no real need for this line in your Code:

Please Login or Register  to view this content.

I would just delete it.

**JBeaucaire** · 10-25-2012, 04:31 PM

@Winon: That is his current codeline of choice to close the reference file he opened. None of this is really how it should be done.

@Euro: Can you decribe briefly what your macro actually does, specifically? I can guess at most of it, but your description would help. We can probably give you a much more succinct macro to do this.

**Winon** · 10-25-2012, 04:57 PM

@ JBeaucaire,

That is his current codeline of choice to close the reference file he opened.

But you may suggest:

Please Login or Register  to view this content.

**euro_andres** · 10-25-2012, 05:07 PM

Hi All, Thanks for your reply!
Actually, now the macro decided to function with the original code described above, I don't know why it wouldn't work in the first place because I was just adding a command to not have to click manually on the windows alert.
Basically there is an input table, where you put the specifications of the information you want to download, there is a column with a text managing formula that creates the link to the specified information, the macro basically opens the internet source copies the info from the temporary excel file and sorts it into a spreadsheet on the file on a format that will allow the creation of a pivot table on the future.
Regarding omitting the closewindow would leave numerous temporary excel files open, as the macro sorts the input table and opens the different links.

**euro_andres** · 10-25-2012, 05:23 PM

I notice that you are astonished with the messiness of my code, please understand that I'm teaching myself and have only a couple of months of experience, I will appreciate any sugestion and constructive critic, that helps me be to a better developer.

**LeapingLizard** · 10-25-2012, 05:34 PM

Yes it definitely needs structure. Look at all the examples of coding the forum contributors submit and you will see a big difference. Good job with the coding it is just that you need structure. You will get better trust me especially when you have to debug it yourself.

LeapingLizards