Jump to content
PedroAlex

[Solved] Open a .xls file into filemaker

Recommended Posts

Good afternoon everyone.

I need to open a .xlsx file by pressing a button

I have tried with a script, where I establish a variable
$ filename = e: \ Works \ Josram \ Presup \ AAVSA \ slopes 345 7 Apr 14.xlsx

And using the command "Send DDE Execute"
The service name = "c: \ Program Files \ Microsoft Office \ Office16 \ Excel.exe"

But when you run it, it just does nothing

Can someone tell me that I'm doing wrong?

I don't need to import o export a file. 

I only need, when i click a button Excel runs and open the .xlsx file

Thanks in advance

regards

Pedro

Edited by PedroAlex
Solved

Share this post


Link to post
Share on other sites

Ready

 I establish a variables:

$ program="c: \ Program Files \ Microsoft Office \ Office16 \ Excel.exe"

$ filename = Contracts::PreesupExcel

And using the command "Send event"

$program/$filename

Regards

Pedro

 

 

Edited by PedroAlex

Share this post


Link to post
Share on other sites

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

  • Similar Content

    • By brownt
      I have a friend for whom I've done a bit of consulting helping him build some project tracking tools in FileMaker.  Helped him through the basic stuff around relating tables together, doing a bit of scripting, creating some basic reports based on data he's entered... Well, now he's hooked!  And would like to do everything for his business in FileMaker.  His current partner does everything in Excel, and has over the years developed a project management spreadsheet he uses to track project funds, activities and generate a financial summary for their clients...  Well, now I've been asked to see if it can be redeveloped in FileMaker, because my friend doesn't want multitudes of Excel sheets for every project, that he has to paw through when he wants to pull data for his other tracking tools that are in FileMaker.   He'd like to be keeping all the data in one place.
      His partner's Excel sheet basically tracks the date of an activity, a note about the activity (what business or consultant or company performed the activity), what kind of activity it is (each spreadsheet for each project may have anywhere from 8 to 16 different kinds of activity) and how much money was associated with that activity (credit or expense).  Tracking that is not a tough deal in FileMaker, that piece I've already sketched out.  Reporting on it is where I'm having problems, because he'd like FileMaker to produce a report that looks as close to what the Excel sheet looks like, including columns for each kind of activity they're tracking, with activity totals, balances, budget remaining, etc...  Where I'm really really running aground is the fact that there may be any number of different kinds of activity going from project to project.  Some may have 7 different kinds of activity, some may have 15 or 20. 
      I've included a sanitized, example version of one of his Excel files.  I can't wrap my head around how best to do up a report that doesn't have a set number of fields (what would correspond to the columns in his Excel).  I could do it as a great big flat file database and put in fields for every possible kind of project activity, I guess, but.... argh!  
      I would welcome any thoughts on how a report like the one I've included as an Excel file here could be created in FileMaker...  Or if the combined expertise here figures this is something that is best left to Excel (I must admit, my thoughts have drifted that direction as I wrestle with this).
       
      Thanks in advance!
      report.xlsx
    • By Franziska B
      Dear 360 Works Team

      In our FileMaker Solution we want to create an Excel report including text, numbers (dates) and images via Scribe.

      The FileMaker export of text and numbers works fine. But we have a problem with the export of images in the xlsx.

      After the Creation of the Excel reports all text- and number elements are in the .xlsx but the image not.


       
      When we open the generated .xlsx, Excel shows the attached error massage:


      For the export of the pictures, we test following script commands:  
       
      ScribeDocValue[Name:“F5“;Value: table:: cell]
       
      ScribeDocWriteValue("Table1!F5", table::cell)
      SetVariable[$PicXYZ; Value: ScribeDocWriteValue("Table1!F5", table::cell)]
       
      Do we make a mistake, or could this be a known bug?
       
      Our Systemconfig:
      FileMaker Pro Advanced 16.0.4.403
      Excel 2010 and Office 365;          
      360 Works Scribe 3.08 and Scribe 3.09
      Server:
      FM Server 16.0.3.304
      Microsoft Windows Server 2008 R2 Standard
      Version 6.1.7601 Service Pack 1 Build 7601
      Could you help me please?
      Thanks


    • By Christian Chojnacki
      Hello,
      we use your plugin Scribe for editing Excel files in our Filemaker solution.
      Since a few days we get an error message when calling the method "ScribeDocLoad" (see appendix) for newer Excel files.
      Older Excel files from the beginning of 2018 are not affected.
      So we wanted to ask if there might be a problem with the error in Scribe.
      We are currently using:
      Filemaker Pro Advance version 16.0.3.302
      Microsoft Excel 2016 Ver. 16.0.9029.2253 64-bit
      Scribe version 3.08
      In the appendix you will find an Excel file that throws an error message when opening with Scribe.
      With kind regards
      Christian Chojnacki
      Click to choose files
      Mappe1.xlsx

    • By Little Mighty
      Hi Guys
      I can't figure out a solution for this. The final result is an export, No data have to be stored in filemaker afterwards.
      I need to combine and export data from 3 tables to the SAME field in Excel. Lets say we have table A: A1, A2 and A3, table B: B1, B2 and B3 and table C: C1, C2 and C3. These are tied together by a unique number in the solution. I need these fields to output i the export as all 1's in one column beneath each other, all 2's in one column beneath each other and all 3's in one column beneath each other. 
      I am thinking, that I need a new table to combine these fields in 3 new fields D1, D2 and D3 and then do the export of this table. After export, the table could be deleted until next export. I am thinking this should be set up as a script. 
      Does the above make sense, and could it be done via a script?
      Thanks for the help - really appreciate it!
    • By hutchlad
      Hey Guys,
      Just a quick one, I have a large report that groups products together via Style, and has totals at the bottom in the green section (I realise they arent totalling but thats not my issue)
      My issue is, that when I export as a spreadsheet, my products stay grouped by Style, but I cannot for the life of me get the totals to stay underneath the columns of each group! Any help or advice would be appreciated, I just want it so that its in the format below with the group of products, then the totals beneath.
       

  • Who Viewed the Topic

    2 members have viewed this topic:
    Desmo  Nippon Maru 
×

Important Information

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