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