Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

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

Recommended Posts

Posted

I was just wondering if it is possible to export to an excel file that has all of the headers pre formatted. (ie. it doesn't show the field name as Projects::Name, but just as Name)

I've seen comments on XML but frankly I have no idea how to use it

Any help would be greatly appreciated Thanks!

Posted

Thanks WireShop,

It was definitely the right idea, I forgot about running macros, BUT for some odd reason my version of excel does not like FileMaker Pro 9 so it's not letting me import into a document. (Although I can export from FileMaker into a new blank excel sheet)

So unless I'm missing something it looks like it's back to the drawing boards

Posted

Never mind I found what I was missing. (excel still doesn't import though)

New Issue/Wish: I was hoping to format the spreadsheet in a way that it behaves similar to my database any other ideas?

Posted (edited)

I believe excel supports ODBC connectivity so I guess it would be possible to import FM data into excel this way

You can do a lot of cool stuff in excel with VBA like draw a form with buttons fields etc. and drop it right on a spreadsheet. VBA is an easy language to learn too.

Edited by Guest
Posted

How about exporting to a text file, and specifying this text file as a data source in excel? Go ahead and format all you want. Then, set excel to auto-refresh the data when it opens.

Posted

As I've been looking around ODBC does not look like it may be the best option available. Excel claims that I need Microsoft Query in order to deal with databases, which I don't have

This topic is 5962 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.