Save an Excel File From Access Macro

W

WiN

Using a VBA Macro from Access, i populate an excel file
but get the following error when trying to save the excel
file (still from VBA): "Method SaveAs of Object Workbook
Failed". I've already found out that if the path length
where i try to save the excel is < 150 characters, it
works fine.

Is there any kind of restriction on the path length while
saving an excel file from my access VBA macro??

(I am trying to save the file as an excel template. Also
the file already exists, i am trying to overwrite it.

Thxs
 

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

Top