1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Facing issue while opening or saving excel file with macro.

Discussion in 'VBA Macros' started by ThrottleWorks, Jan 8, 2019.

  1. ThrottleWorks

    ThrottleWorks Excel Ninja

    Messages:
    1,923
    Hi,

    I am facing issue while opening or saving excel file with macro.
    I am using below line to open excel file in my code.

    “Workbooks.Open (MapSht.Range("A13").Value)”

    Once macro tries to execute this line, I get pop-up with below message.
    Downloadig (message header)
    Downloading: file path and file name
    Cancel (button)


    If I do not click on ‘Cancel’ then macro does not proceed.
    If I click on cancel, files gets opened and macro resumes.
    Same issues occurs while trying to save the file.


    Can anyone please help me in this.
  2. Chihiro

    Chihiro Excel Ninja

    Messages:
    5,171
    Without knowing what's stored in the cell. Hard to help you. Give us as much detail as you can (along with screen shot if possible).

    By chance are you trying to save file in synced folder to cloud storage?
    ThrottleWorks likes this.
  3. ThrottleWorks

    ThrottleWorks Excel Ninja

    Messages:
    1,923
    Hi @Chihiro sir, the cell value has values something below.

    Z:\AA\AA\MyFile.xls

    File is saved in shared folder. I was able to run this macro without this issue till a week back.
    Facing issue from last 1-2 days.

    My apologies for incomplete details in original post.
    Thanks a lot for the help. Have a nice day ahead. :)
  4. Chihiro

    Chihiro Excel Ninja

    Messages:
    5,171
    Sounds like some change to network/IT policy.

    I'd suggest checking with your IT team.

    One other potential solution, may be to check your Trusted network location and make sure that you have Z:\ and/or local network included in the trusted location.
    ThrottleWorks likes this.
  5. ThrottleWorks

    ThrottleWorks Excel Ninja

    Messages:
    1,923
    Hi @Chihiro sir, thanks a lot for the help. Will check as advised.
    Have a nice day ahead. :)
  6. ThrottleWorks

    ThrottleWorks Excel Ninja

    Messages:
    1,923
    Hi,
    This issue is auto resolved. Thanks. :)

Share This Page