Save an Excel File From Access Macro

  • Thread starter Thread starter WiN
  • Start date Start date
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
 
Back
Top