Find Jobs
Hire Freelancers

calling an excel macro from powerbuilder

$30-100 USD

Cancelled
Posted over 14 years ago

$30-100 USD

Paid on delivery
OLEObject ole_object // Create or "Instantiate" the ole_object variable ole_object = CREATE OLEObject IF [login to view URL]("excel.application.8") = 0 THEN ? ? ? ? [login to view URL] = "False" ? ? ? ? [login to view URL](IS_SPREADSHEET) //Open the .xls file Else ? ? ? ? MessageBox('OLE Error','Unable to start an OLE server process!',Exclamation!) END IF // Make Object Invisible ole_object.Visible=FALSE //CSV File name ls_file = "c:\temp\[login to view URL]" FileDelete(ls_file)? ? ? // I am able to start the excel spreadsheet using similar code with ole controls. What I need is a macro or command to do the update links command. I can write a macro to update linked spreadsheets? and i would like to call it from my script above. My application writes out data to a spreadsheet that is? linked to another spreadsheet with report formats.? I want to update the? cells auto from the linked ss after the ss is written with data. I am missing the small lines of code to do this. Can anyone help. I'll pay a small amount for the? answer.? // Saves the document to another filename [login to view URL](ls_file, 6)? ? //csv //[login to view URL](ls_file, -4158) //text tab delimited [login to view URL] = "False" [login to view URL]() // Disconnect from Excel [login to view URL]() // Destroy the Ole Object DESTROY ole_object
Project ID: 2907554

About the project

Remote project
Active 15 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs

About the client

Flag of UNITED STATES
Olathe, United States
4.7
84
Payment method verified
Member since Mar 7, 2003

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.