Error saving to Sharepoint: Getting list of available content types...

**jomili** · 05-29-2012, 08:50 AM

Every morning my macro creates and saves 15 workbooks to our Sharepoint site. Often (3 mornings per week) I get the message "Getting List of Available Content Types...", which stays forever. If I hit "Cancel", I get the error message

Please Login or Register  to view this content.

on this line of code

Please Login or Register  to view this content.

In this case, Region 2_9 is the fifth workbook created/saved. If I try to continue the code, we keep going in the same loop. I have to kill Excel and start over. I'd appreciate some help in resolving this.

Thanks,
John

**martindwilson** · 05-29-2012, 09:21 AM

what happens if you save as manually at the same time

**snb** · 05-29-2012, 09:36 AM

Use

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

**jomili** · 05-29-2012, 11:26 AM

Martin,
I haven't tried to save manually, but if I close Excel and rerun it saves just fine.

SNB, I thought it might have something to do with the filetype, so I'll try your "56" routine on tomorrow's run. However, I'm puzzled as to why this would be an issue SOMETIMES and not every time if it's a problem with the filetype. Every one of 15 workbooks is saved every day using the exact same convention; only the name itself changes.

**martindwilson** · 05-29-2012, 11:40 AM

ok sorry i meant locally not manually! run the same macro 100 times but change the path to your c drive. does it fail?. if not its probably some weird sharepoint thing.

**jomili** · 05-30-2012, 12:27 PM

SNB,
Your code made the difference, after a small change. Instead of going with the "ThisWorkbook" option, I went this route instead:

Please Login or Register  to view this content.

However, the ", 56" wasn't welcomed by my VBA, so I changed it as so:

Please Login or Register  to view this content.

Thanks for all the help on this one. I still don't understand why I was getting a sometimes error, but it worked well this morning.

**xaldec** · 12-04-2014, 09:55 AM

Please help! I am having this exact same issue. I am using the FileFormat attribute with the saveas command. I have also added a 3 second wait before the saveas command to see if this helped but it did not. The site seems to allow 3 saves to go through and then the issue occurs. I am drowning! Please help.

**koltregaskes** · 12-05-2014, 09:03 AM

I have the same issue, it allows for 2 saves to go through but then the error appears. I've tried the above code but it doesn't make any difference.

**jomili** · 12-05-2014, 10:27 AM

FYI that shortly after I started this post we changed our whole methodology and quit using the Sharepoint site, so my issue went away.

**protonLeah** · 12-05-2014, 09:45 PM

xaldec, koltregaskes,
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.