Thanks for your input Stephen.
Ajay *From:* [email protected] [mailto:[email protected]] *On Behalf Of *Stephen Markson *Sent:* Monday, December 17, 2018 2:57 PM *To:* '[email protected]' <[email protected]> *Subject:* RE: [RBASE-L] - GATEWAY Export using Specification file ...then, *LAUNCH *the spreadsheet (with the AUTO_OPEN macro). Regards, Stephen Markson The Pharmacy Examining Board of Canada 416.979.2431 x251 *From:* [email protected] [mailto:[email protected] <[email protected]>] *On Behalf Of *Stephen Markson *Sent:* December 17, 2018 2:53 PM *To:* '[email protected]' *Subject:* RE: [RBASE-L] - GATEWAY Export using Specification file I have the used the following technique to achieve similar results: Create a spreadsheet with an *AUTO_OPEN *macro that opens the spreadsheet created from the specification file and then sets the borders you want… Regards, Stephen Markson The Pharmacy Examining Board of Canada 416.979.2431 x251 *From:* [email protected] [mailto:[email protected] <[email protected]>] *On Behalf Of *Ajay Sanghvi *Sent:* December 14, 2018 3:10 PM *To:* [email protected] *Subject:* RE: [RBASE-L] - GATEWAY Export using Specification file I just figured out that when creating the specification file there is a field for number of characters. This number set the width of the output column in the Excel sheet. This resolves one of my issues. But I am still missing a way to create borders for the cells. Thanks for taking the time to respond. Ajay *From:* 'Karen Tellef' via RBASE-L [mailto:[email protected]] *Sent:* Friday, December 14, 2018 1:50 PM *To:* [email protected] *Subject:* Re: [RBASE-L] - GATEWAY Export using Specification file I'm not sure if there's a better way to do it now, but in the past I have created a blank template spreadsheet that had all the proper widths and formats applied to columns & rows, and had users copy/paste into the template. You have to have a couple copies of the template stashed somewhere, or else the user would usually save their work over the template name. Karen -----Original Message----- From: Ajay Sanghvi <[email protected]> To: rbase-l <[email protected]> Sent: Fri, Dec 14, 2018 12:20 pm Subject: [RBASE-L] - GATEWAY Export using Specification file Hello all I am trying to Export a table into Excel workbook using GATEWAY in a command file. I have created a SPECIFICATION file that creates the proper heading colors etc. What I am not able to do is set the width of certain columns and have all my data be displayed with borders so the users do not have to manipulate the excel file. Thanks in advance. AJAY SANGHVI Vice President 700 Blair Road Carteret, New Jersey 07008 U.S.A. T (973) 748 8980 F (973) 680 9618 E [email protected] -- *Berjé Inc. *- an SQF Level 3 Quality Certified Supplier No. 7751 and Certified by WQS. -- _** Markets are moving rapidly, please note all prices and volume offers are kindly to be considered subject final confirmation, including any pending tariff changes, unless otherwise stated. ** _ -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout. *Berjé Inc. *- an SQF Level 3 Quality Certified Supplier No. 7751 and Certified by WQS. *** Markets are moving rapidly, please note all prices and volume offers are kindly to be considered subject final confirmation, including any pending tariff changes, unless otherwise stated. ** * -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout. -- *Berjé Inc. *- an SQF Level 3 Quality Certified Supplier No. 7751 and Certified by WQS. -- _** Markets are moving rapidly, please note all prices and volume offers are kindly to be considered subject final confirmation, including any pending tariff changes, unless otherwise stated. ** _ -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
