Save Method

  • Thread starter Thread starter Rob
  • Start date Start date
R

Rob

Hello All,
I run an excel 2000 application .This macro is used to
generate few reports on a daily basis.I use a template for these
reports and I run this excel script from an Access application and
have automated it so as to run everyday at a scheduled time.Everything
is fine and the reports are saved on the screen with the current
date.But i want them to be directly saved into their respective
folders of the directory instead of on the screen.(At present,after i
reach the work place,I click each of these reports and a message asks
me whether the report has to be saved ).Can this be over ridden?
Thanks for your replies.


Rob
 
You can use the SaveAs method

For example,
ActiveWorkbook.SaveAs "c:\my_report1.xls
 
Hi Rob,
I don't have an answer to you question, but I think you may beable
to answer one for me, please email me at you earliest convenience....
Thanks..
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Scheduling task to run for Excel Addin 1
File sharing 6
Content.MSO error 1
Excel 2003 - VBA to get a list of Module names in the project 4
Disable WorkBook AutoOpen 1
writing excel data into word document 1
execution speed issue when closing files 5
automate save as of excel-report to pdf-document. 1

Back
Top