Excel compatibility with Google Drive & iPads

[BakerUK]

Hello all

I have built an interactive xlsm file for someone with lots of vba included - in short user forms (not the in built ones, built with vba) which submit new entries to listing sheets and dashboard of results auto refresh.

They have asked 3 things I'm unsure of and can't immediately find definitive answers online. Can anyone answer or direct me to the right place?

1) Can the file be shared through Google Drive? I've never used it but assuming this would work fine?

2) They have a Google Docs file they update for one part of the system. Can I build something in vba which imports this into my xlsm? I'd be comfortable saying yes if it was .txt or .csv but have no idea about file types etc with Google Docs.

3) Will it work on an iPad? My previous experience of this is the macros won't run, the hidden sheets won't hide, certain autoshapes won't appear properly and all sorts of issues. But that was a few years ago so is there an app or any other method to workaround this?

As always - any assistance would be greatly appreciated.

P.S I haven't been lazy, I Googled all 3 questions, but got conflicting responses.

Thanks

Baker

 

[etaf]

3) no , https://support.office.com/en-us/ar...latforms-1985a408-6fc3-4e87-ac9e-673e0e1f485e
1) google drive is just like any other shared drive - so should work fine
2) Dont know, but would not see why it would not work its just a spreadsheet document. - however, have you tried to play with google docs - they are free

 

[RoryA]

Only desktop versions of Office support VBA. You can't run it on an iPad or Android tablet.