• 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...

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

Workbook.open issue :(

P

prasaddn

Active Member
Hi All,

I have made a template of excel file (.xlsm). And another excel macro file called consolidator.

This template is shared with 10 different users, and they track the details in the template.

All these 10 files are stored in one location, and consolidator macro file on click of command button opens each of the file from that location and copies data from them to this consolidator file.

Everything is/was working fine, until today. out of 10 files, only one file is behaving weird!!

I am able to open this weird file manually, but when the vba code executes workbook.open line, the excel application hangs, no error message, nor the file is opened!

And, even in debug mode, not able to stop/pause macro! The excel application itself have to be killed to stop.

Any help on this is very much appreciated.. pls.

Regards,
Prasad DN
PS: I use MS Excel 2010 version
 
Hi:

It is difficult to pinpoint why is this happening. Is the file corrupted? Were there any change in the naming conventions of the file recently?
Just a suggestion, try connecting the file through ADODB and pull data using SQL.

Thanks
 
Check that the file isn't saved as Read Only
Check that all users have the same file access/network access permissions
I everyone using the same version/updates of Excel ?
 
Hi..

The file is not corrupted.. and I am able to open the file manually, without any issue, but challenge only when tried thru vba code.

the environment does not have shared drive, all the files are sent to one individual thru email. That individual saves all the files in one location.

And, then runs the tool. All the files are of same format, settings, etc.,

This is something that is driving me nuts. :'(

@Nebu,
how do I connect the each of file through ADODB and pull data using SQL.. any pointer.. pls.


Regards,
Prasad DN
 

Hi !

It's a local computer problem.
Close all applications. Delete all files in Temp directory of the session.

If problem still occurs, desactivate all add-ins loaded in Excel.
See also if any reference in error, desactivate it …
​
 
You must log in or register to reply here.
Back
Top