Late binding Access 2013 - MS 365 Excel

[JohnPapa]

Does any one know whether there is a problem with using late binding to open Microsoft 365 Excel?

 

[arnelgp]

no, perhaps problem with the code.

 

[gemma-the-husky]

I found A2003 wouldn't work with Outlook365 whatever I did.
Maybe it's the same thing with Excel365, and lower versions of Access.

Can you error trap when you instantiate the object, and see what error code you get.

 

[JohnPapa]

I found A2003 wouldn't work with Outlook365 whatever I did.
Maybe it's the same thing with Excel365, and lower versions of Access.

Can you error trap when you instantiate the object, and see what error code you get.

On closer look it appears to work. The only difference is that in the case of the Microsoft 365, when I invoke the Excel builder it prompts me to save the file and after I save it, I can view it.

 

[JohnPapa]

In other words, the application operating with the Access 2013 Runtime appears to be working with Microsoft 365 Excel.

If anyone needs the code I can post.

 

[gemma-the-husky]

@JohnPapa
ah. I thought you were indicating you had a problem, rather than just asking whether you could do this...

 

[JohnPapa]

I was asking about it because I thought I had a problem.

At the end of the day i just needed to scroll left.