Saving a range of excel cells as a script file (scr.) without "Save As" prompt screen

[blake.dennis]

I'm trying to write scripts in excel which can be then used in AutoCAD. So i have a range of cells in excel (column I) which i would like to save directly to a script file. I've found bits and pieces of code online and worked through it, however, i want the macro to save directly over the existing script file without displaying the save as prompt menu. This is the code i have so far which requires saving at the prompt menu. Any help would be much appreciated. I've attached the code below.

Please Login or Register  to view this content.

[gmr4evr1]

After your Dim statements add

Please Login or Register  to view this content.

Before End Sub add

Please Login or Register  to view this content.

See if that works for you.

[blake.dennis]

Hi gmr4evr1, suppressing the alerts doesn't seem to work. I think because "Save As" is a dialog box. I was trying to insert an "Application.Activeworkbook.Saveas" statement but couldn't figure out how to save it as scr. file.

[shg]

If I understand your question,

Please Login or Register  to view this content.

[blake.dennis]

Hi shg,
Thanks heaps, that's perfect. i'll have to run it at work in conjunction with AutoCAD, but it seems to work like a charm.

Thanks again.

[shg]

You're welcome.