Excel Macro Runs on Some Computers, Not All- Stalls for computers where it fails to run

Hello!

I'm running a macro that utilizes an API call from quickbase to pull in data into my workbook.

It has successfully run on two computers using Excel 2016, and on one computer running 2016, it stalls when importing data- it also did this on my primary computer, which runs 2013.

While creating the macro, I put in:

Please Login or Register  to view this content.

Just removed it to see if any error messages were popping up. I'm getting the popup that says, "We can't update some of the links in your workbook right now."

I can't break the link, because it is on a protected sheet in a document that doesn't exist. And if I continue without updating, the macro stalls. It gets stuck on the last step of the macro prior to import- with no further error messages.

Again, this has successfully run on other computers.


Any ideas for how to address this? I initially thought the problem was that I'm running 2013, but it stalled on 2016, too.

Where it gets stuck:

Please Login or Register  to view this content.

that sounds more like an access restriction...
if the code runs on other computers, then there's no problem with the code - it works.
likely, the specific computers that cannot complete the code run means they have some sort of access restriction towards where the source data exists

i see that your code is opening a file on some path. Try to open that source file manually using the computers where the VBcode stalls. - like locate the file and open it. take note if there are any error messages.
if there are no error messages take note what exactly happens, does the file open for too long - and such...

Originally Posted by jamie.harris

It's actually referring to the workbook where the macro currently lives. That line reopens the file where the macro is running.

When I open the source file manually, it opens normally- no delays or errors.

but the same macro workbook needs to be opened on different computers right. did you try open manually the target file in the macro? (not the macro workbook) - using the other computers where the code stalls

Originally Posted by ag273n

but the same macro workbook needs to be opened on different computers right. did you try open manually the target file in the macro? (not the macro workbook) - using the other computers where the code stalls

The target file IS the workbook. And it opens on computers where the code stalls.

(Thank you for your help, I know this is a weird situation.)

Originally Posted by jamie.harris

The target file IS the workbook. And it opens on computers where the code stalls.

(Thank you for your help, I know this is a weird situation.)

the workbook runs the code to open another file is openning itself?...

if that line of code is not needed for it to function properly, i agree getting rid of it.. or maybe just change it into a comment, that way, its still there, just not active