Closing CSV File without being prompted to save

[alexkeel79]

I wrote a script to copy data from a series of CSV files in a directory into an excel spreadsheet. When I'm done copying the date I close the CSV files. I am trying to figure out how to close the files without being prompted to save the file. I have tried the following:

importWkbk.Save
importWkbk.Close False

WHich works for regular .xls files but doesn't seem to work for CSV files. ANy ideas?

Thanks...

 

[Loomah]

Hi
It might be a pain but...

With Workbooks("MyCSV.csv")
    .Saved = True
    .Close
End With

;-)

If a man says something and there are no women there to hear him, is he still wrong?
How do I get the best answers?​

 

[xlbo]

application.displayalerts = false
importWkbk.Close False
application.displayalerts = true


.....or Loomah's way - dunno if that will work though as it appears to be a default message whether or not you save the file...

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[Loomah]

xlbo
Funny you should say that but I tried going down the displayalerts route and it didn't work for me!!

But hey, that's often just me!

;-)

If a man says something and there are no women there to hear him, is he still wrong?
How do I get the best answers?​

 

[Loomah]

But as is often the case, the cat may be skinned in an almost endless number of ways.

This takes me back to an earlier life when I was just really starting to get to grips with a little VBA. This is the sort of method I used to close the csv files I used then

If Workbooks("csv_no_headers.csv").Saved = False Then SendKeys "N"
Workbooks("csv_no_headers.csv").Close

But looking back, it's just silly!

;-)

If a man says something and there are no women there to hear him, is he still wrong?
How do I get the best answers?​

 

[xlbo]

LOL - I remember doing stuff like that too

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question