|
Hi experts,
I m basically fighting wid a prb for writing data in a physically opened excel file. Is it possible to write in cells of the excel which is physically open ?
If so, pls guide me how can i implement it ?
Thanks.
|
|
|
|
|
No, it's not. You have two problems. First, the file is already open, so any changes you make will be destroyed when Excel save the file.
Second, the Excel file format is binary and VERY complex, up to Excel 2003. You cannot just open a file for binary access, write to it, and call it a cell in Excel.
In Excel 2007, the file format changed to an open-spec XML format, which is basically a text file. But, you still can't write to a file opened as ShareDeny by another application.
|
|
|
|
|
Hi All
Am Deploying my Application, Everything is ok,Excluding the Following.
When i Designed the User interface, i want to use my Picture in the Banner of the Installation Wizard. i went to User interface, and i Added a Picture and Build it. when i test my User interface, i see my Pic in the Banner, that is Correct , but there are Some text behind it. How can i remove those Text. i looked at the Properties of User interface , there are only 3 options, one for the Picture Banner, second for the text that appears at the bottom, and other that appear above the Botton text. i want to Remove the one at the Banner.
Thank
Vuyiswa Maseko,
Sorrow is Better than Laughter, it may Sudden your Face, but It sharpens your Understanding
VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za
|
|
|
|
|
Hi
Is there any controls in VB.Net similar to File upload control in ASP.Net
Regards
Sivan.G
|
|
|
|
|
There's an OpenFileDialog, but there's nothing to upload a file. The File upload control in ASP.NEt is just a wrapper around an HTML input control. The difference is, your browser already is sending data to a client, so it's easy to send a file. There are classes to do this in Vb.NET, but you need to set up your own network connection to send the data over.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Hi
I have two DataGridViews that have the same number of cells. I need each DataGridView to scroll when user scrolls the other one.
|
|
|
|
|
DGV2.FirstDisplayedScrollingRowIndex = DGV1.FirstDisplayedScrollingRowIndex
DGV2.FirstDisplayedScrollingColumnIndex = GV1.FirstDisplayedScrollingColumnIndex
|
|
|
|
|
hi,
I need to open,process,close multiple file streams (dynamic, i don't know how many will it be)
I have a array() as fileStream
And I have filled that array with fileStream, that I can do. but how to access each and every one of the files and do some work on it. And then close all fileStreams in that array.
I have figured it out only how to create them. Using this code
For i = 0 To numOfFiles - 1
stream = New FileStream(fileListing(i), FileMode.Open, FileAccess.ReadWrite) ' FileListing is a string array containing paths of the files
file(i) = stream
Next
Thank you!!
|
|
|
|
|
This isn't the way I'd do it, but all you have to do is access the methods and properties like this:
file(index).Read
If it were me, I'd probably wrap this file functionality in a class designed to work how you want it. The class would open the file, do any operations you want on it, and then manage closing the file when done.
|
|
|
|
|
Hi,
I am using some formatting tools in my project. So instead of creating a new one can iget the fromatting tool kit from MS-word or MS-powerpoint into my project. This formatting tool is nothing but the bold,italic,underlined...alignment etc.I need this very urgently. I'l be really greatful. Can you please help me in this regard
VIPUL
|
|
|
|
|
Please give me some idea about your requirement in brief.
Dot Net Provides lots of the methods and propeties for the same
Best Regards,
Chetan Patel
|
|
|
|
|
Hi Chetan,
Thanks for the response. I am doing this porject in VB6.0 I am preparing a s/w for entering quesions in the question bank. So when the question is being typed or entered it may need some formattng like bold,italics,(nothing but normal word formatting). so wanted to know the code which can get me the Microsoft (word,excel,ppt) formatting tool into my project. Instead of i creating seperate buttons 4 every formatting tool.
Vipul
VIPUL
|
|
|
|
|
You want a control to give you buttons that say bold, italic, etc ? How are you rendering this text ? Or are you hoping to use Word as a text box over and over in your project ?
A rich text box supports these things, but not buttons, you have to add those.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Hi ,
Thanks for the response. I am doing this porject in VB6.0 I am preparing a s/w for entering quesions in the question bank. So when the question is being typed or entered it may need some formattng like bold,italics,(nothing but normal word formatting). so wanted to know the code which can get me the Microsoft (word,excel,ppt) formatting tool into my project. Instead of i creating seperate buttons 4 every formatting tool.
Not another command button..the entire formatting tool kit from other MS application should come into my project
VIPUL
|
|
|
|
|
What you want is insane. Why are you using VB6 anyhow ?
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
You can't get just the toolbar. Those tools will only work on a Word document. You have to host Word inside your application to use that toolbar, and you'll have to show the rest of Word too so the user has a Word document to work on.
If you're going to go that far, why would the user even use your application??
vipul2 wrote: Instead of i creating seperate buttons 4 every formatting tool.
What's the problem?? Why not?? Why are you complicating your app more than it needs to be??
|
|
|
|
|
Hi Dave,
Yes i got it. So it is clear that i can't just the tool bar but instead i can get the entire word in my project which is't required.
Anyways thanks for the suggestion
VIPUL
|
|
|
|
|
Hi All,
I am writing a non MFC Application using Opengl (Win32 Project) but i am using
some MFC Headers below
#include <afxwin.h> // MFC core and standard components
#include <afxext.h> // MFC extensions
#include <afxdisp.h> // MFC Automation classes
#include <afxdtctl.h> // MFC support for Internet Explorer 4 Common Controls
#ifndef _AFX_NO_AFXCMN_SUPPORT
#include <afxcmn.h> // MFC support for Windows Common Controls
#endif // _AFX_NO_AFXCMN_SUPPORT
#include <afxdhtml.h>
#include <afxdlgs.h>
////////////////////////////////////////////////////////////////////////
I want to use Web Browser Control On my project (Activex) but i am not
using any form i want create web browser using createWindow function
////////////////////////////////////////////////////////////////////////
It will be really help full if anyone please send me sample code
Thanks,
Soumyadipta De
|
|
|
|
|
What would possess you to ask this in the VB forum ?
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
hi!
i have a simple question.
i have a simple server client program that i am recently doing my question is how do you queue the data from the client in the server side?
tnx!
FUNGAS!
|
|
|
|
|
You haven't said anything about your application or data. Do you want messages from the client queued up on the server?? Or on the client side in a sometimes-connected environment?? What are you queueing?? Have you implemented some kind of queue on the server-side already??
At this point, about the only thing I could recommend is looking into MS Message Queueing and the System.Messaing[^] namespace.
|
|
|
|
|
oh im sorry my client sends an iso8583 message to the server. yes i want the messages queued up on the server side because the client only connects once it has a message ready. on the server side the message catcher is an infinite loop once a client connects it catches all the data being sent my problem is if two or more client simultaenously connects how do i queue up the data here is a sample code from my server program:
Sub Main()
Dim server As TcpListener
server = Nothing
Try
Dim port As Int32 = 13000
Dim localAddr As IPAddress = IPAddress.Parse("127.0.0.1")
server = New TcpListener(localAddr, port)
server.Start()
While True
Dim data = New [Byte](1024) {}
Dim clientdata As [String] = [String].Empty
Console.WriteLine()
Console.WriteLine("Waiting for a connection... ")
Dim client As TcpClient = server.AcceptTcpClient()
Console.WriteLine("Connected!")
Console.WriteLine()
Dim stream As NetworkStream = client.GetStream()
Dim bytes As Int32 = stream.Read(data, 0, data.Length)
clientdata = System.Text.Encoding.ASCII.GetString(data, 0, _bytes)
client.Close()
End While
Catch ex As SocketException
Console.WriteLine("SocketException: {0}", ex)
Finally
server.Stop()
End Try
End Sub
tnx!
FUNGAS!
|
|
|
|
|
If you use MSMQ, you don't need the TCP/IP code. In the way you've implemented this, you'd have to write an entire queueing system. That's WAY too much information to put in a forum post.
|
|
|
|
|
do msmq have its own communication protocol?
FUNGAS!
|
|
|
|
|
Why don't you click on the link in my first reply and read up on it.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
