Jump to content

exporting record into specific worksheet in specific excel file


CornellU
 Share

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

Recommended Posts

  • Newbies

Whats the best way to move a record into a specific worksheet in a specific excel file?

Currently, I'm exporting to a new .xls, copying the row, and then pasting it to the desired excel file and worksheet.

Is there a better way? I'm beginning a project and this would be a huge help.

Link to comment
Share on other sites

The only way I see this possible is through VBscript. Through VBscript you can manipulate all of Excel so you can easily tell it to switch to a particular worksheet and create a new row at the bottom of the list with your data. Or insert it anywhere.

Since there is FM data involved you need to create the VBscript syntax in a FM field, export the field contents to a physical VBscript file, use Send Event to execute it, have FM wait for it to be done then use another Send Event to delete the VBscript again. Or you can have a VBscript live outside of FM and call it passing the data as parameters (saves you having to clean up, but it's a little harder on the deployment). Or you can use the VBscript plugin at www.grokittools.com.

Link to comment
Share on other sites

This topic is 5648 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
 Share

×
×
  • Create New...

Important Information

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