I do have third party application which produce it�s reports in PDF format. Those reports are having images and different kind of alignments in the pages. So I need a code or guidance to make an application to transform the exact appearance of the PDF file in to Excel. My Issue is the PDF does not have table kind of thing to identify by regular pdf to excel conversions.
View 3 RepliesI am exporting data from vb.net to excel and it is dropping the leading zero when its displayed on excel. How can I avoid the dropping of leading zero? I read the solution of adding a single quote but it makes my excel sheet column ugly. Also users will complain if they see a single quote on zip code field.vb.net code
Response.AddHeader("content-disposition", attachment)
Response.ContentType = "application/vnd.ms-excel"
Response.Charset = ""
the stored procedure outputs XML and it is transformed by XSLT before it is displayed on EXCEL
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:template match="/">
<HTML>
[code]....
adding a single quote or manipulating excel sheet with column formatter (general/numbers ) etc. I don't want user to make any changes on excel to get the display properly when the excel is displayed from web page it should be all set with proper formatting. also we have no control over client excel software?
how to transform my textboxes to excel spead sheet within my programe
View 15 Repliesi have a small program with random generator when i try to transfer the textboxes to excel i have problem?
View 5 RepliesAfter several hours of browsing google, wanted to check with one of you experts. I have made a winform application to read data from PABX (telecom) device. My application is listening to a particular port and once data received it passes to the data_hander. Application is working fine. But I�m facing a issue in received data string. From PABX system, it sends start and stop bit within the text string. It sends chr(2) as start bit and chr(3) as stop bit. But when my application reads the incoming data stream as follows,
ReceivedData = System.Text.Encoding.ASCII.GetString(bytes, 0, bytes.Length).Trim(Microsoft.VisualBasic.ChrW(0))
It does not recognize the start and stop bit as it sends from PABX. It just replace chr(2) and chr(3) with space and shows rest of the string. The issue is, I just want to take the same string and forward to another application and it needs this start and stop bits as it is to read the string properly. Could somebody guide me how to read this characters from PABX system or at least include them to the received string within my application as send to the other application?
I am currently busy with the updating and modifying of a website.I need to convert a mountain of Excel documents into HTML form that the website looks better and is a bit more user-friendly.how I can convert the Excel to HTML?
View 2 RepliesImports System
Imports Microsoft.VisualBasic
Partial Public Class _Default
[Code]....
this is the code to convert word documents to excel. but i am getting error at underlines portion..the error is name not declared what should i do..I got thios code frm net and i just pasted it in visual studio..
I'm using vb.net to check that certain Excel or Word documents exist in a folder.
EG
strFileFound = Dir("C:TestFolderMyExcelFile.xls")
strFileFound = Dir("C:TestFolderMyWordDoc.doc")
If the documents are created using Excel 97 or Word 97 the files are found. If the the documents are created using Excel 2007 or Word 2007 the files are not found.
I have checked the permissions between the two different versions and they appear to be the same.
why Dir dosen't work with Excel 2007 and Word 2007 files?
I am building a business intelligence application for my organization. I have a form in which I would like to display existing excel spreadsheets. I have searched high and low for a control that would allow me to display a spreadsheet. Basically what I need is a viewer control that I can user to call the individual soreadsheets and display them in the form.I do not want to open excel outside of the application, but instead display the spreadsheet in the form as part of the application.
View 3 RepliesI search a lot and couldn't find a code that really worked. So, I search more and after that, I wrote the following class. I hope that this code be useful for someone.First, add the following references to yours VB project:
1- Microsoft.Office.Interop.Excel
2- Office
Imports System.Reflection
Imports Microsoft.Office.Core
[Code]...
I have this code:
Public Class Transform
Dim inputFile As IO.StringReader ' Object variable
Private Sub OpenFileDialog1_FileOk(ByVal sender As System.Object, ByVal e As System.ComponentModel.CancelEventArgs) Handles ofdOpenFile.FileOk
[code]....
And I am getting these errors:
'Private Sub Transform_Load(sender As Object, e As System.EventArgs)' has multiple definitions with identical signatures. Line 15
'strOutputPath' is not declared. It may be inaccessible due to its protection level. Line 51
Type 'XslCompiledTransform' is not defined. Line 83
I wonder how to load transform an MS Excel file to a text file?
View 3 RepliesI'm struggling to think of a reason why I should be getting an 'Access denied' error when trying to save an Excel document opened through a program written in VB 2010 Express. The program is essentially glorified Excel automation. It converts information from hundreds of Excel documents into a few small text files in order to improve operation speed. The software is designed for use by no more than a dozen or so people in the office who are all editing these Excel documents (through the software), and saving changes. They edit a given document by selecting it in a list in the main form, which then changes the document to writeable and opens it for them. A FileSystemWatcher detects changes in the folder containing the Excel documents so that the aforementioned text files can be updated when the user saves the Excel document.
[Code]...
I wondered if someone could help me with my code. I am changing some pages of a website from Excel documents to HTML form.I have most of the code sorted but I also need to save a few documents to Word. I keep getting a few errors and cannot seem to solve them.
I have included my code and highlighted the errors by underlining them. Maybe someone can help??
Imports Microsoft.Office.Interop
Imports Microsoft.Office.Interop.Excel
Public
Class Form1
Dim path
[Code]...
Does somebody have experience in populating excel and word documents from .net application?
What is proposed way: jet, com, xml? Is there any preferred way from Microsoft side?
What would be pros and cons for all 3 approaches?
How do I open/view Office documents (Word, Excel, PowerPoint) in a VB.NET Form? remember to mark the replies as answers if they and unmark them if they provide. Welcome to the All-In-One Code Framework! If you have any feedback,
View 1 RepliesI've been asked to get the page counts for documents stored as tif files. What I have now is looping through our third party software to open them and then get the page count. I can't stop the image from flashing and it is very slow. Does anyone know of a way to loop through them quickly and can the page counts (one image can have many documents)?
View 5 Repliesprint pdf documents from a vb 2010 app. I have tried 2 techniques that work, but both have some minor issues that I'd like to address. The 1st technique uses command line arguments as follows:
Dim starterStr As String = "/h /t " & Chr(34) & pdfFileName & Chr(34) & " " & Chr(34) & printerName & Chr(34)
Dim starter As New ProcessStartInfo("AcroRd32.exe", starterStr)
Dim print As New Process()
With print
[code]....
The 2nd technique is more aesthetically pleasing to me, but has the same annoying problem of leaving the Acrobat process running after execution. It also doesn't allow me to set the output printer destination (the above code sends the output to the default printer).
1. how to close the Acrobat process
2. how to set an output printer destination using StartInfo arguments
How would I go about uploading an entire directory and all sub-directories and files to a SharePoint 2010 Server?
I don't think this function is specifically built into SharePoint (just uploading multiple documents in one folder). But the way I understand it, I can write something in VB or C# to accomplish this.
Scenario: I have about 14000 word documents that need to be converted from "Microsoft Word 97 - 2003 Document" to "Microsoft Word Document". In other words upgraded to 2010 format (.docx).
Question: Is there an easy way to do this using API's or something? Note: I've only been able to find a microsoft program that converts the documents to .docx but they still open in compatability mode. It would be nice if they could just be converted to the new format. Same functionality you get when you open an old document and it gives you the option to convert it.[URL]..EDIT2: This is my current function for converting the documents
[Code]...
Also it opens word after about 2 or 3 conversions and starts flashing but keeps converting.EDIT3: Tweaked to code above a little bit and it runs cleaner. Takes 1min10sec to convert 8 files though. Considering I have 14000 I need to convert this method will take a reasonably long time.
EDIT4: Changed the code up again. Uses a threadpool now. Seems to run a bit faster. Still need to run on a better computer to convert all the documents. Or do them slowly by folder. Can anyone think of any other way to optimize this?
The three forms in my project have the ability to print in PrintDocument1.Print event. Each print-document consists of only one page in landscape shape and everything works fine. But it seems a bit clumsy to print three times with three buttons. I know, I can use the PerformClick event, but I wonder if there is a simple way to append all three documents into one by clilking only one button in my last form?
View 1 RepliesI decided to to convert my excel macro in a exe file using visual studio 2010. In excel macro method find is present like this:
[Code]...
I've developed an application in VB.Net 2010, Express edition. It uses Word Library functionality to access several .docx and .dotx files.Everything works in the development environment. However, after deployment, my application can't find any of the Word document files. I've added them to the project and to the Resources list under the Project Properties tab.The path I'm using to locate the docs and dots is coded in these ways:[code]Both of these statements work in the development environment perfectly. Not at all after deployment as an app.What can I do to make my application find the Word files after deployment?
View 4 RepliesI've got a treeview loaded with all the folders in my computer via a code I found here.
- When I click the "Documents and Settings" folder I can't access it, how can I accomplish that?
- How do I hide/show hidden folders like Windows Explorer does? [code]
I would like to know if it is possible to have dynamic data in word (2003) documents. Let me explain, I will start with what we do now and how I would like to fix or change it.We have approx 35 , we will call them divisions for the time being, and each division has a folder on the shared drive. We have approx 700 ,lets call them customers for the time, and each customer has a folder located in the associated division folder on the shared Drive. (\DriveDivision#1Customer#1...\DriveDivision#32Customer#348 etc etc etc .)There is a MSword2003 document that exists in every Customer Folder that contains data about that customer (including but not limited too.Contacts, Notes, Customer #s etc) We will call this the DeCust.doc file for the time. A lot of the information in these DeCust.doc files can exist in another customers DeCust.doc files such as a contact name and address. One of the problems we run into is that a contact (lets say Smiths Plumbing Service) may send an email to notify of an address change and the person receiving the email will change the contacts address in the DeCust.doc files of the customers that that employee (employee #1) works with but, there are other DeCust.doc files in other customer folders that the address never gets changed in. When a different employee (employee #2) opens a deCust.doc file of a different customer that he/she works with the contact (Smiths Plumbing Service) the address of this deCust.doc: file is wrong (not updated).
I would like to solve this problem. I have already developed a Demo VB/Database application to be used in lieu of the DeCust.doc files but, I have met Way too much resistance in getting people to switch from using individual docs in each customer folder to using a database program. With that being said, I started wondering if there was a way to Link/populate/fill the contact information in these DeCust.Doc files to a central Database or such that when someone changes an address for a contact it is simultaneously changed in all the other DeCust.doc files.
I have a quick question. One of the functions in the program I am writing is to take all of the data entered, compile it into an HTML document, then place that document into a folder.For the past few days, I have just been using a random folder on one of my hard drives to dump the file in, but the problem is that, in my code, I have supplied the folder location as a string ("E:Practice FilesDocuments"), and therein lies the problem. Trying to test my program on a separate system brought the bug to my attention; obviously, this program can only write this file to a location of E:Practice FilesDocuments, and if any other computer that runs this program doesn't have E:Practice FilesDocuments then there is going to be a problem in the program working the way I have intended
So what I would like to do is instead of having it write the file to "E:Practice FilesDocuments," have it write to the default My Documents folder so that the program is no longer specific to my machine only. The problem is, though, I have no clue what the right code is to use. I first tried using
System.Reflection.Assembly.GetExecutingAssembly().Location to write the file to the default installation directory. This would have worked, but since this is a VB.NET program, the default installation directory isn't in Program Files and doesn't seem to be meant for users to browse through for their documents, plus it seems that trying to write back to this directory causes some unhanded exceptions and whatnot. I figured it would just be easier to create a folder in My Documents rather than use the install directory (and probably smarter).
[Code]...
I have a Search web reference (from a Search Server 2010 express install) in a vb.net application that is utilizing the QueryService Class to search a production Sharepoint foundation 2010 site.At a previous point in time, we had created a proof of concept on an entirely test system that has since been turfed. From my recollection on this test system when documents were uploaded as a specific site content type (that inherits from document) and metadata was provided, we could search for specific metadata by making managed properties for each, and search results would be returned as documents (with the isdocument flag set to true). Viewing the document then became simple, as we could simply use the filename and path to display the stored file.Now we are developing a production system and we have encountered a new behavior, where these results now are returned as aspx results such as
[URL]
This of course makes it terribly difficult to locate and view the document, we can extract the Title which will then give us the name of the file with no extension, but that hardly helps, as the FileExtension data is aspx, not the documents file extension, so we don't have a full filename. We could display the page returned as a result, but would much prefer the document itself.
I've made a test document library, with just bare bones setup, (not using the site content type, or site columns) and uploaded some documents on the same site, and they are returned in the same fashion, so I don't believe the document library, or content type are the issue.
With a fairly limited understanding of both Sharepoint and Search Server, I don't know if this is a setup issue with the search service itself, with the site configuration, or with the querypacket I am sending. We also have a third party application (Knowledgelake) installed on the server that ties into sharepoint which could have changed configuration somewhere as well?
I don't think the query packet has changed since it was working in the proof of concept, other than the custom data column names. I will provide it here in case there is something glaringly obvious to an external reader.
<QueryPacket xmlns='urn:Microsoft.Search.Query.Document'>"
<Query>
<SupportedFormats>
<Format>urn:Microsoft.Search.Response</Format>
[code]....
The program allows users to insert Documents along with a bunch of their attributes into the program. The documents are stored in a relational database. One of the required functionalities is allowing the user to look for such documents. The User normally search directly for the obvious attributes of the document, like a unique ID, or it's Title. The problem is that from the search parameters is not allways known which ones will the user fill. For example the user inserts the name and version of the deocument, another time the user enters part of the Title and the person that delivered the document, or might just enter the document number and nothing else. Some of the data might even be incomplete, like title, name of the person who created the document and so on. The idea from the person who designed the system (I'm only reimplementing it) was to allow easier searches for the user, and allowing the user to search for more parameters tod with the idea that "the more parameters, the more specific results", since the results are always group of documents instead of single documents.
View 14 RepliesI am trying to use a spreadsheet with VBA macros that I wrote in Excel 2007 in Excel 2010.When the macros run in 2010, I get the error message "Can't find project or library" on functions like UCase and Date.I've set the macro settings to "Enable all macros" and selected "Trust access to the VBA project object model."What do I need to do to get these macros to run in 2010?
View 2 RepliesWhat I am looking to do sounds really simple, but no where on the Internet so far have I found a way to do this in DotNet nor found a 3rd party component that does this either (without spending thousands on completely unnecessary features).Here goes: I have a jpeg of a floor tile (actual photo) that I create a checkerboard pattern with.In dotnet, it is easy to rotate and stitch photos together and save the final image as a jpeg.Next, I want to take that final picture and make it appear as if the "tiles" are laying on a floor for a generic "room scene". Basically adding a 3D perspective to make it appear as if it is actually in the room scene.Heres a website that is doing something similar with carpeting, however I need to do this in a WinForms application:Flor Website Basically, I need to create a 3D perspective of a jpeg, then save it as a new jpeg (then I can put an overlay of the generic room scene).
View 2 Replies