VBA save and close not saving!

[barcodezebra]

Hi There


I've written a macro to paste some data into a template that I can use for creating a Configuration Package in Navision.


The final line of the macro should save and close the template but it doesn't. It closes without saving. As far as I can see it's a bog standard line of VBA that everyone uses so I'm not sure why it's not working for me.


Can anyone help? The code is

Workbooks("GL Transaction Import Template.xlsx").Close SaveChanges:=[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]True

Cheers[/FONT]
​

<style></style>

 

[RoryA]

Welcome to the forum.

Does it make any difference if you use two explicit calls:

With Workbooks("GL Transaction Import Template.xlsx")
   .Save
   .Close
End With

If not, can you post the rest of the code too, please?

 

[Legacy 421546]

Depending on your environment, my bet is that the workbook is saved but in another folder. With a good search tool, search for your file all over the place.

 

[barcodezebra]

Depending on your environment, my bet is that the workbook is saved but in another folder. With a good search tool, search for your file all over the place.

Oh God! The burning shame! You're absolutely right. And not only are you right but the path to the document is specified earlier in the code when I ask VBA to go off and open it for me.

What a clown.

Thanks for your help!
<style></style>

 

[barcodezebra]

Thanks Rory


That works but, to my eternal shame, so did my original code. I was just looking for the workbook in the wrong place.


I feel properly foolish!<style></style>

 

[RoryA]

Well, at least the problem is resolved!