Jump to content
Server Maintenance This Week. ×

Importing and refreshing data from unorganized Excel


This topic is 2083 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hello!

 

Our work shifts are (for some historical reasons) made and maintained on Excel. During years the number of employees has expanded a lot and so the number of working slots. It is VERY frustrating to find your own shifts from an Excel sheet. Unfortunately this data in Excel is very unorganized and almost chaotic. 

Now I have an idea that I could somehow import that data to Filemaker so, that I would not have to manually go thru every cell. The original Excel is a shared document in Google Drive. I can download it locally and modify it freely. 

So, could it be done combining Filemaker script, maybe Apple script and Excel Visual Basic? I'm not very familiar with Apple script or Visual Basic.

Screenshot 2018-08-14 13.45.38.jpg

Link to comment
Share on other sites

This topic is 2083 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.