We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Course Of The Month
5 days, left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
How do I use a template saved as a resource in Visual Studio 2013?
Posted on 2016-09-15
Windows Forms Application - Visual Studio 2013 Using vb.net.
I have a template that I use to produce a form. I generate it by using this code:
Dim oWord As Word.Application
Dim oDoc As Word.Document
Dim oTable As Word.Table
oWord = New Word.Application
oWord.Visible = True
oDoc = oWord.Documents.Add("C:\Us
Everything works fine. I now find myself having to deal with our IT department moving my file locations on a more frequent basis. I have decided to add my templates as a resource within my application in hope to resolve this situation.
I add my Word template to Resources as an existing file. Now I want to use it. I use this code:
Dim oWord As Word.Application
Dim oDoc As Word.Document
Dim oTable As Word.Table
oWord = New Word.Application
oWord.Visible = True
oDoc = oWord.Documents.Add(My.Res
I get an error: Type mismatch. (Exception from HRESULT: 0X8002005 (DISP_E_TYPEMISMATCH))
I would appreciate any direction or instruction on how to solve this.
Thanks.
I have a template that I use to produce a form. I generate it by using this code:
Dim oWord As Word.Application
Dim oDoc As Word.Document
Dim oTable As Word.Table
oWord = New Word.Application
oWord.Visible = True
oDoc = oWord.Documents.Add("C:\Us
Everything works fine. I now find myself having to deal with our IT department moving my file locations on a more frequent basis. I have decided to add my templates as a resource within my application in hope to resolve this situation.
I add my Word template to Resources as an existing file. Now I want to use it. I use this code:
Dim oWord As Word.Application
Dim oDoc As Word.Document
Dim oTable As Word.Table
oWord = New Word.Application
oWord.Visible = True
oDoc = oWord.Documents.Add(My.Res
I get an error: Type mismatch. (Exception from HRESULT: 0X8002005 (DISP_E_TYPEMISMATCH))
I would appreciate any direction or instruction on how to solve this.
Thanks.
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
5
4
2- +1
13 Comments
Active today
HI,
I think you have to extract it on disk to open it subsequently
or maybe by referencing it
Regards
I think you have to extract it on disk to open it subsequently
or maybe by referencing it
Dim oDot As Word.Document
oDot = My.Resources.WSTF489
Regards
This will work
Dim oWord As Word.Application
Dim oDoc As Word.Document
Dim oTable As Word.Table
oWord = New Word.Application
oWord.Visible = True
Dim bytes = My.Resources.Resource1.WSTF489
Dim path As String
path = "some path you have access to.dotx"
System.IO.File.WriteAllBytes(path, bytes)
oDoc = oWord.Documents.Add(path)
Active today
Everything works fine. I now find myself having to deal with our IT department moving my file locations on a more frequent basis.
Why does this matter? Just use relative paths and a proper folder structure in your deployed project.
Using the resource path has a code smell: You need to deploy a new version for ever template change..
ste5an - I'd like to package this up and send it off to other groups within the agency that don't necessarily have access to the file location due to security reasons. I feel that if I could include the template in the resources, I could eliminate this problem. Does that make sense? And I guess I don't understand "proper folder structure in your deployed project." Can you expand on that as well? I think I'm doing that, but maybe I'm not.
Active today
First of all: "Security reasons" I know IT departments which will actively block such an approach of yours, cause it may be an attack vector.
Do you use any kind of installer? Or other: How do you deploy your application?
[..]access to the file location due to security reasons[..]How do they run your application?
Do you use any kind of installer? Or other: How do you deploy your application?
I deploy it on our network. If I were to package it and send it on, they would use their network. But then I'd have to send all the templates and they would have to create like folders etc. on their network.
I'm also curious as to how this works in general. If I have a word template in resources, how does one access it to work?
I'm also curious as to how this works in general. If I have a word template in resources, how does one access it to work?
Active today
Normally you use an installer to pack all dependencies into one setup.msi.
Depending on the installer tool, you have different options. The main two:
- a normal user based installation. Then on each users machine this must be run. Any data files are copied by the installer to %ProgramData%. This is a known location for invariant application data. E.g. your template. The user has no write access to this location.
- a network based installation. This is a two step operation. First the network files are copied to the network location. Then on each machine the installer is run to install necessary .Net or other code dependencies. During this run, the installer writes the share name, where the network files are located to the registry. Then you program uses this entry to locate its data files.
Depending on the installer tool, you have different options. The main two:
- a normal user based installation. Then on each users machine this must be run. Any data files are copied by the installer to %ProgramData%. This is a known location for invariant application data. E.g. your template. The user has no write access to this location.
- a network based installation. This is a two step operation. First the network files are copied to the network location. Then on each machine the installer is run to install necessary .Net or other code dependencies. During this run, the installer writes the share name, where the network files are located to the registry. Then you program uses this entry to locate its data files.
- a normal user based installation - I would code, "Upon installation, create a read only directory (C:\MyAppTemps) and then copy my templates that are in resources, to that folder." All my code inside the application would then be pointed to the C:\MyAppTemps folder? Then if I made a change to the template, I'd do a remove and replace in that directory.
Active today
No, don't create such directories. That's what %ProgramData% is for. Use %ProgramData%\YourApplicat
Press Win-R, enter %ProgramData% and press OK. For normal users this is a read only location for such data.
The rest is indeed okay. Cause it's simpler to just deploy a template, when necessary, then an entire application.
Press Win-R, enter %ProgramData% and press OK. For normal users this is a read only location for such data.
The rest is indeed okay. Cause it's simpler to just deploy a template, when necessary, then an entire application.
Featured Post
Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
This video shows the viewer how to set up and create Footnotes in their document.
Click on the References tab:
Select "Insert Footnote":
Type in desired text:
This video walks the viewer through the process of creating envelopes and labels, with multiple names and addresses.
Navigate to the “Start Mail Merge” button in the Mailings tab:
Follow the step-by-step process until asked to find the address doc…
Suggested Courses
Course of the Month5 days, left to enroll
Earn Certification
Managing Projects with Microsoft Project 2013 (Exam 74-343)
$49.00$44.10
Earn Certification
MCSA Configuring Windows 7 Exam 70-680
$49.00$44.10
688 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.