App to Record Data and Sync to Excel

RusheR

New Member
I'm brand new to app writing, but am interested to find out if I can use basic4android to write an app that I can record information and then sync it to an excel file (infor I record to populate to the proper cells).

I work in construction, and I have many condo units where I will track deficiencies by my trades and then track their progress in correction them.

I wrote some great Excel VBA macros in a Deficiency workbook to track these deficiencies, with drop downs and such that made the list fool proof for others to use.

The list could then be used to filter out deficiencies for a room, or a trade, or by floor, ect.

The biggest problem with this is that I had to record the information on site then bring it to my computer to update. With the modern tablet, I envision doing this on site with only touching the proper buttons on my screen to record the deficiency then the tablet syncing the list to my computer when I'm back in the office, where I can forward the lists to trades.

If I could use excel macros on any tablet, I could just use my old excel file, but alas, there is no tablet app that can run excel macros.

Can anyone help me to tell me if this is a real option, or am I wasting my time?

Thank you.
 

mc73

Well-Known Member
Licensed User
Longtime User
I would go for exporting my excel workbook to a sqlite database and reconstruct my vba macros in b4a code.
 
Upvote 0
Top