amidyne Posted July 25, 2008 Posted July 25, 2008 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!
wireshop Posted July 25, 2008 Posted July 25, 2008 I've run into this same problem. I just create a formatting macro in excel to add all the relevant data to the excel output from filemaker.
amidyne Posted July 25, 2008 Author Posted July 25, 2008 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
amidyne Posted July 25, 2008 Author Posted July 25, 2008 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?
wireshop Posted July 25, 2008 Posted July 25, 2008 (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 July 25, 2008 by Guest
bcooney Posted July 26, 2008 Posted July 26, 2008 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.
amidyne Posted July 28, 2008 Author Posted July 28, 2008 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
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now