General information
Title:
Preventing VBA code saving
I have written a application in Excel97 to automate a data collection task. It works great, but the file is now larger than the user would like it becase of the VBA code.
What I do is this: Open up a raw data file, import it into a sheet in my workbook, and then save the workbook of with a new name specified in the raw data file. My customer would like it if the new file did not contain any VBA code. Is their a specific parmeter in the saveAs command that will allow this?
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only