Save as VBA function for Excel

Basically my data is coming from Controller in the form of (.Xlsx) format. I want to save it after 5 mint automatically with different extension & also generate a report at user define time.

I face a problem when i save a workbook in different extension at my Drive and then i open it for check, at this moment my VBA script goes on error. How i prevent from it
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Ryan ChongBusiness Systems Analyst , ex-Senior Application EngineerCommented:
>>at this moment my VBA script goes on error. How i prevent from it
instead of saving the opened workbook into another Excel file, you may just copy the content you want and paste (could be paste as values etc)/save it into a new Excel file instead.

will that make sense to you?

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
[ fanpages ]IT Services ConsultantCommented:
Where is the "VBA script"?

It will not be within the ".xlsx" format file initially (as a workbook with this extension does not contain any 'macro'/Visual Basic for Applications [VBA] code).

Let me see if I understand what you require from what you have provided so far...

a) A "Controller" gives you an MS-Excel (2007-2013 format) workbook file, saved with a ".xlsx" file extension.
b) You wish to (re-)save this file in an automated manner after 5 minutes (of usage/being open) with a different &, as yet, unspecified file extension.
c) At the point of saving the file in this manner you wish to generate a report; again, unspecified.
d) It sounds like the 5 minute interval is "user-defined".
e) Once saved "at my Drive", that you may mean is on your local filing system, on within a repository known as "myDrive" (or similar), if you re-open the workbook, some "VBA script" (that may, or may not, be in the workbook being opened), fails.
f) You would like to know how to prevent the "VBA script" from failing.

Please confirm if any/all/none of this is correct.

Additionally, initial queries:

1. It is unclear whether the file is constantly re-saved every 5 minutes, or just once.
2. What file extension is the file re-saved with?
3. What does the generated report look like?  Is this already written?  Does this use data within the "Controller"-provided file?
4. Where is "my Drive"?  Is that a local (C:, for example) drive, a network drive, uploaded to a web site, or somewhere else?
5. The "VBA script" is an unknown factor; how is this executed?  Can the source code be posted here for review?
6. What error messages are displayed, or what indicates the "VBA script" is not executing as intended?
Martin LissOlder than dirtCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.