I need example code or even a 3rd party object that will allow me to get to an excel object embedded in a word doc. I have already tried Aspose and they do not have the capabilities yet. Has anyone done it or do you know of a 3rd party object that will?
View 2 Replies
My application needs to extract an embedded file (OLE object) from an excel 2003 document to a file on disk. This file can be any type, not only an Office document. Searching in the web it seems to be possible by copying OLE object to Clipboard and later copying (binary) it to a file (¿perhaps using MemoryStream and FileStream?), but I see no working code about this.
View 1 Repliesgetting a DoCmd.RunMacro method for running macros inside EXCEL and Word?
View 1 Replieswhich are the control used to display word files and excel sheets inside vb.net forms ? (i have already added reference lib.)
Platform: Vb.net (framework : 3.5)
language : visual basic
I'm trying to insert an embedded resource into a string. I'm trying to insert it into a Word Document. However, I get an error at the last statement below.
Imports System.IO
Imports System.Reflection
[code]....
is there a possibility to modify the Datasource that is used for a mailmerge in Word VBA? e.g in the MailMergeBeforeRecordMerge- event?I need to delete some unnecessary lines before proceeding with the MailMerge.
View 1 RepliesWe have an interactive windows based application written in VB .Net 2010. It uses Word Object to display documents in MS Word. We have a form with a button. When the button is clicked we open the Word document and maximize the Word Windowstate. When we have the Visual Studio Tool running, the Word Document is maximized and has focus, even if we are running the exe from the bin folder outside of the tool. However, if Visual Studio is not running and we run the exe, focus remains on the original form window and the document stays in the task bar.
View 5 Repliesi would like to ask that is there anyway to embedded an excel file into a vb.net project? i know the way to read an excel file from vb.net, but i would wanna know is there anyway i can include the excel file inside the vb.net program. This means i dun need another excel file beside the exe file.
View 3 RepliesHow can I programatically find the path and file name for an embedded object in an Excel worksheet? I know I can right click on the object and select Packager Shell Object and then Properties to find the information
View 1 RepliesI am having some real issues with this one. I have a class which contains two other objects...but I cannot seem to instantiate those sub objects. Here is the code for my class:
Code:
ption Explicit On
Public Class Boot
[code].....
is there a way to get the raw data of a word file document object?
word = new Word.Application();doc = new Word.Document();
now, I open the word file, do some replace. save the file. I could open the file as raw binary file. but I'm thinking maybe there is a property that can get the raw the data? which property?
how can i modify my object at run time? I have a form containing two panels; textbox, picturebox, and a label are in the panel1 where as panel2 is likely to be the user screen.. User drag the textbox from panel1 to panel2 and it is added there.. Now, i want to provide the facility to the user to modify the size using mouse similarly as we use to modify using mouse while making our forms.. It is like re sizing the button or picturebox at run time.
View 1 RepliesWhat is the preferred method for embedding an audio player with a URL and hiding that URL from the user? I understand anything that gets to the client can eventually be seen by the client but I would like to know if anyone has any recommendations for this problem. What have you used for similar situations?
View 2 RepliesI want to modify the third column of an existing excel file. The problem with below code is a new file is prduced with the new values in Column C and erases all other values in the orginal file. I want to update the orginal file with the new values.
Public oExcel As Excel.Application
Public oBook As Excel.Workbook
Public oSheet As Excel.Worksheet
[Code]....
I have two questions concerning navigation in a 'mutlipage' control embedded in a form layout in Excel:
(1) I would like to be able to automatically move from page_1 to page_2 through a closeout button click command on page_1 (i.e. when actions are complete on page 1, page 2 will open without needing to click on the tab). Is this achievable ?
(2) secondly, While realising it is a simple step to set up navigation to another Excel workbook, is it conveniently possible (from a button command in the multipage) to open another directory, e.g. MMC console
I'm trying to extend my new WPF Touch Screen Keyboard (DLL) Library, to allow the user to get events from the Touch Screen Object. I'd like to be able to tell the Programmer what Object made the call (or executed the subroutine) that raised the event. Not dissimilar to the Sender as Object event parameters one gets when working with a System Object. Which begs the question, How do I get that information, if I don't ask for it?Is there a way to get this information from some call made in the subroutine about to raise the event?
View 2 RepliesI'm trying to extend my new WPF Touch Screen Keyboard (DLL) Library, to allow the user to get events from the Touch Screen Object. I'd like to be able to tell the Programmer what Object made the call (or executed the subroutine) that raised the event. Not dissimilar to the Sender as Object event parameters one gets when working with a System Object. Which begs the question, How do I get that information, if I don't ask for it? Is there a way to get this information from some call made in the subroutine about to raise the event? That would be nice, and a time saver for me.
View 1 RepliesI've been tryin' to develop macro, that can find table in the word and then copy it into the excel. Now it works, the only problem is, that is only the first row, that get copyed...
example (cell /w three lines in it):
Today is great day
Today is not a great day
Today, it is outrageous day
and with the code bellow, I get only Today is great day
Code:
For Each tTable In ActiveDocument.Tables
n = 1
With tTable
[Code].....
This error is ridiculously common, and I'm not too sure why it would be caused this time. What I'm trying to do is export two datagridviews to word, using code from the following website: [URl].. perfectly, and does for the other grids, but at the moment I have the object reference error for the MonthlyCashflow and LoanAnalysis grids. The rows and columns in the grids come from calculations and not my database.
[Code]...
I have a string and I want to see if inside that string I have the word Peter.
[Code]
This does not work, It still says Yes when I have Not in the textbox. How can I do this correctly?
I have a question about how to validate a text box with only word inside. Below is my code i use, it's only can detect if number 1 to 9 in single number, but not 11 or 999 or Joanne11 Joa223nne etc. I want it can detect the text box have and number or symbol then will show an error messageBox, else continue.
[Code]...
this is my first post here. I want to show word document inside vb.net mdi child form.I learned it is not available in vb.net 2008(i am using it)and alternative could be Dsoframer.ocx. But i dont know how to integrate it in vb.net and load the file inside form.Sample code might really help me.
View 4 RepliesI am trying to open a word template inside a form in my vb.net application but I cannot seem to find any guidance to doing this. I do not want to call microsoft word to open in order to see/read/write on my template. I want the word document to be within a form I am creating like a print preview sort off. I am using Word 2007 and VS 2008. I have been using so far automation and calling and interacting with the template but until so far I have to open Microsoft word to open it for me.
View 2 RepliesI am trying to open a word template inside a form in my vb.net application but I cannot seem to find any guidance to doing this. I do not want to call microsoft word to open in order to see/read/write on my template. I want the word document to be within a form I am creating like a print preview sort off. I am using Word 2007 and VS 2008. I have been using so far automation and calling and interacting with the template but until so far I have to open Microsoft word to open it for me.
View 7 RepliesIs this possible?
Public Class Foo
public var as string
public sub Load(byval filename as string)
[Code]....
Up until now i've had a function that that returns Foo as Object (I'm trying to make the serialize / deserialize process general so I can just copy and paste and avoid explicitly setting each variable)
I'm trying to XML-serialize a class the properties of which I use to format a document.Basically, it is a class for the document's header and another class for its rows. url...In this class diagram, the class I want to serialize is ExcelPrintCorte that inherits its methods from ExcelCabec and has a private member ExcelPrintDocumento (and a public method to get it).My purpose is to XML-serialize ExcelPrintCorte and save the inherited properties' values and also the properties' values of ExcelPrintDocumento. I followed many guides to XML-serialize an object but it saves nothing but: [code] So, what am I doing wrong? Or is what I'm trying to do not possible with XML serialization?
View 1 RepliesHow can I open a word 2007 document inside a webbrowser contol in my visual basic 2005 form?
It used to work fine with word 2003, but when I installed 2007 it started to open outside my form.
I'm developing an application with Visual Studio 2008 (with visual basic), first of all, I'll give a brief of what I'm planning this module will do.
It's an accounting application, that I use to administrate some of my company's movemets. The application links directly with MS SQL server 2005, and sends queries to the database like: client name, employee Id, transacion type etc. Right now I'm developing a contracts module, wich is intended to be used with Microsoft Word 2007. We want the module to do the following: (It's a contract document; the document should get the variables from the application like contract type [that would change the template of contract used in microsoft word depending on the type], Client name, Salesman name, today's date, name of the company's representative)
1) After the data has been captured from the application (the application has a capture module that sends the info to the database), instantly send the capturer to microsoft Word, to a layout that has variable fields that should fill themselves with the database information ( I don't have a clue on how to do that )
2) The capturer should be able to change text in the contract layout and fix the variables info in case they were misstyped, adn when he/she saves the document; if there were any variables edited, they should get updated in the database; and the application should be saved with a name that has variables on its name ( 1)today's date in DDMMYY format, 2)First 2 letters of the client's name, 3)last 3 digits from tye contract number), save the file in a directory where all contracts are in .docx format (could use any frmat, it actually doesn't matters), and send the file location to the databse; to a table field named "file" wich only has the file's route.
3)From my application, when consulting the data, give the app access to the file directly; simply by getting the query form the database.
I need to start MS Word 2003 from Inside VB Windows Application and Load a specific Word Document.
View 4 RepliesI am using VS .net 2003 and developing a program that calls Excel. The development computer only has Excel 2003, and the target machine only has Excel 2007. Would it be possible to install Excel 12 Object Library in the development computer without installing Excel 2007?
View 4 Replies
