Unable to open .xls saved files by other users.

V

Vinod

Hi All,

I've connected to one of our remote desktop with my user login credentials
and placed an excel file with macro. On execution of macro will create new
..xls format file in the same location where the excel macro exists. I'm able
to open that newly created .xls file in remote desktop where its created.

Rest of ther users are not able to open the newly created .xls file when
they connected with their login credentials.

Here is the code to create the .xls file:
activeworkbook.SaveAs activeworkbook.path & "\test.xls",xlNormal

Can any one help me out in resloving the above said issue by sharing your
experience or thoughts would be appreciated.

Advanced Thanks
~Vins
 

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