[AccessD] Visual Studio - C# - Open Excel Template v Excel Resource File

Bill Benson bensonforums at gmail.com
Sat Sep 9 04:58:19 CDT 2017


But why can't the application still embed this workbook within itself and
"spawn" it to disk, and open the file? I know if VBA did that, the macros
within the file would automatically be trusted because VBA (whereever it
was running to cause the automation) was already trusted. I don't know much
about .Net or C# launching a file on disk, would its macros automatically
be "trusted"?

On Fri, Sep 8, 2017 at 2:57 PM, Dan Waters <df.waters at outlook.com> wrote:

> Hi Paul,
>
> My first choice would be to write the code in an Excel file.
>
> You can do this by turning on the 'Macro' recorder - which records all
> your steps in VBA (same as Access but for Excel).  Record as many steps as
> you can.  The go into the code window and change what you need to.
>
> You'll probably need to write the code from scratch which gets the list of
> account numbers and grabs the data - but that will be the same as in Access.
>
> Set this up so others can do it on their own instead of you doing this
> each time.
>
> Now stand by for more requests to automate other Excel spreadsheets!
>
> Dan
>
> -----Original Message-----
> From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
> Paul Hartland via AccessD
> Sent: September 8, 2017 13:44
> To: Access List; Development in Visual Studio
> Cc: Paul Hartland
> Subject: [AccessD] Visual Studio - C# - Open Excel Template v Excel
> Resource File
>
> To all,
>
> I know enough VB.net to get me by and I am about to attempt to teach
> myself C#, we have a small yet critical application at work that I
> developed in VB.net, basically takes a list of account numbers, grabs some
> data, opens an Excel template, puts the data into the template, saves it
> and emails it off....
>
> Was just wondering if it is quicker, pros & cons about opening an Excel
> template from a folder or if it is faster to embed the template in the
> application and use that, I haven't really used embedded resource files
> much, so any info greatly appreciated.
>
> Thanks in advance for any help on this.
>
> --
> Paul Hartland
> paul.hartland at googlemail.com
>
> <http://www.avg.com/email-signature?utm_medium=email&
> utm_source=link&utm_campaign=sig-email&utm_content=webmail>
> Virus-free.
> www.avg.com
> <http://www.avg.com/email-signature?utm_medium=email&
> utm_source=link&utm_campaign=sig-email&utm_content=webmail>
> <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


More information about the AccessD mailing list