2,270 Topics
I am creating a form on Excel where the user can use tabs to go through the fields that have been unlocked and type in numbers in that field, then hit tab to go to the next field. I have created the tab array in the VBE, but the problem …
A new ghost of Windows XP was installed on all our computers. It has Office 2003 installed. The old Windows XP also had Office 2003 installed with the Compatibility Pack. Now the Compatibility Pack fails to open Word 2010 DOCX files? The message reads "Word experienced an error trying to …
Need help, I need to know on how can VB.net validates the format of each cell on the excel file that it opens, for example, the first row should only be numeric, or cannot be null, is it possible that vb.net can check it before it inserts it in the …
I have a VB.net application that gets data off our server with ODBC and populates and saves a Word Document. When I try to deploy it to another computer it will get the data just fine and populate the first document, but it will crash before saving it. I've installed …
This is my code, but its taking time to save record in excel. In SQL Server table have 11201 rows and 80 columns. please suggest private void button1_Click(object sender, EventArgs e) { Microsoft.Office.Interop.Excel._Application app = new Microsoft.Office.Interop.Excel.Application(); Microsoft.Office.Interop.Excel._Workbook workbook = app.Workbooks.Add(Type.Missing); Microsoft.Office.Interop.Excel._Worksheet worksheet = null; app.Visible = true; worksheet = …
Hi, I am having problem with my coding below when I would like to export the data from GridView to Excel Spreadsheet. Appreciate if you could share your valuable comment. Thanks [B]Error Message =[/B] Class 'System.Web.UI.WebControls.GridView' cannot be indexed becasue it has no default property. [B]Error Line[/B] = xlWorkSheet.Cells(i + …
Hi, I am trying to write a macro that will have the list box look at a cell in another worksheet and based on that data, lookup the corresponding data in another worksheet which will be used as the data for the list box. Formula I am using for cells …
Hello everyone, First of all I would like to thank everyone for all their efforts in helping us newbies in solving our problems when it comes to coding. It has been a while since I have seeked some help from this forum or any other for that matter. I stopped …
I have a word 2007 document with 60 pages. I want to do this. (1) 2nd page up to 6th page(1st page is cover page), should be numbered as i, ii, iii, iv, v (2) after 7th page should be numbered as 1,2,3,4...... I searched in the internet. There are …
Still finding my way around here.. Its a bit different once you join. I always come here looking for pc solutions or legit software program recommendations. I am female and married. Have 3 children. My hobbies are Painting Old masters Impressionist Paintings and Computer Graphics. Creating stuff.. a bit of …
I've trying to move over my Office Xp Outlook Express .wab file to Office 2010 Outlook. I've been successful in bringing over the .pst file with a few minor glitches like the Inbox, Drafts, Sent Items and Deleted Items showing up under Personal Folders. I sure would like to delete …
Hi I have two desktops one has Office 2003 and the other my "graphics and video PC" has Adobe Creative Suite 3 Design Premium. Both use XP Pro. I can't use Adobe Acrobat as MS Word is installed on my other PC. There are a few other issues, that lead …
[CODE]using Excel = Microsoft.Office.Interop.Excel; namespace program { private void cmdOpen_Click(object sender, System.EventArgs e) { FileSystem.FileOpen(1, inputfile, OpenMode.Input, (OpenAccess)(-1), (OpenShare)(-1), -1); // 1 : excel file Excel.Application MyXl; MyXl = new Excel.ApplicationClass(); MyXl.Visible = true; Excel.Workbook xlWorkbook = MyXl.Workbooks.Open(inputfile, 0, false, 5, "", "", false, Excel.XlPlatform.xlWindows, "", true, false, 0, true, …
// ws is an object variable of worksheet // systype is a string variable Range r = (Range)ws.Cells[2, 2]; systype = r.Value2.ToString(); how can I combine these two lines into one single line ? Please help ....
Hello people! I have a question. I use windows xp operating system and ms office professional 2007. When I want to import a tif file in Excel 2007 as a hyperlink from Hyperlink button, I succed import the tif file, but when I double click on the link it occurs …
I have a user who is going to the Scheduling Assistant setting up a meeting to check other users' Free/Busy information. She can see some people (such as me), but she can't see other's. They show up as the filled in boxes that corresponds to 'No Information' per the legend …
I have a server that I just did a clean install on with Server 2008 Enterprise x-64. I have been having issues installing certain applications and unfortunately, I am at a loss as to why. I installed SQL Server 2008 Std, which went fine, but SQL Server management studio will …
Hello Everyone, I want to transfer data in export from my php reports. it works also. but the problem is when i open that .xls file in notepad i can view all my data. i don't want this.my data will be unsecure.can anybody tell me solution?? code is as below: …
HI i am trying to convert a doc file to a pdf file. please see my conversion code below [CODE] private string m_SourceFilePath; private string m_DestFilePath; public bool DoConversion() { bool returnValue; Word.WdExportFormat exportFormat = Microsoft.Office.Interop.Word.WdExportFormat.wdExportFormatPDF; object paramMissing = Type.Missing; Word.ApplicationClass wordApplication = new Word.ApplicationClass(); Word.Document wordDocument = null; try …
Greeting fellow Humans, I'm trying to "[I]comb merge[/I]" (if any thing as such) bunch of Excel files. There are 2 type of Excel workbook: A & B Both has a column called : [I]Location ID[/I] [U]These are the step I think the prog should do [/U]: Promp user to select …
I have Outlook 2010 installed on my desktop, and whenever I try and start it I get this rubbish. *open attachment*
Hi everybody. I have a simple problem. Need send the c++ output to excel(csv->xls or xls direct) in formated data. I can send the data to excel, but i can´t format that like this: |_ col 1__|___col 2___|___col n____| row 1......|....2row 1 row 2......|....2row 2 row 3......|... 2row n What …
Hi Guys, I have written a macro, when i try to save it is asking me to save it in different format (my excel file is in xlsx format). Is there any way i can save my excel file in xls or xlsx along with macro.. in xlsm format macro …
Hello community, I am importing data from access into excel using a data import from a microsoft query using OBDC. I have 3 stores importing their their sales into each row daily. I cumulatively add these in a row at the bottom of each column. The issue I am having …
=rand(100,1000) type this on your ms office if you have then a magic will happen...
Hi, I needed to create in-cell dropdownlist in excel using VB.NET, So i used the code, With xlWorksheet.Range("H2", "H101").Validation .Add(Type:=Microsoft.Office.Interop.Excel.XlDVType.xlValidateList, AlertStyle:=Microsoft.Office.Interop.Excel.XlDVAlertStyle.xlValidAlertStop, Operator:=Microsoft.Office.Interop.Excel.XlFormatConditionOperator.xlBetween, Formula1:="Maintenance Planning") End With It works fine with Excel 2003, but it does not works on Excel 2007. It shows below message, Excel was able to open the …
I am trying to write a windows application in vb.net to import data from excel to sql server. I got "object not set to an instance of an object" error. The data actually have been inserted into the sql. The following is my code. I have a button when the …
Hi, I'm getting the error at the doc.close in the last argument; type mismatch error using object 11 com addin; for which the doc.close takes 3 arguments. thx [code] Microsoft.Office.Interop.Word.ApplicationClass wordApp = new ApplicationClass(); object file = textBox1.Text; object nullobj = System.Reflection.Missing.Value; Microsoft.Office.Interop.Word.Document doc = wordApp.Documents.Open(ref file, ref nullobj, ref …
Hi guys, is there a way to get worksheet names from a close workbook? thanks for any help.
Hi all. I have a problem that I haven't found a solution for on the web, so maybe anyone here can assist. Om our server at work we use excel, but it always starts in "Excel wasn't started correctly last session. Do you want to start in safe mode", wich …
hi , i had created a new .doc file, in the coding part a single doc file is readed and writed to the new doc file ... how can i continue the operation for reading multiple doc file and write it to a new doc file ..... [CODE]Imports System.Windows.Forms Imports …
[CODE]980 Set rs = db.OpenRecordset("0 - Supplier List") 990 RptLoc = 0 1000 If rs.EOF = False Then ProcessCount = ProcessCount + 1 1010 Do While rs.EOF = False [COLOR="Red"]1020 XL.Sheets("Supplier").Copy Before:=XL.Sheets("Supplier") 1030 XL.Sheets(2 + RptLoc).Name = rs!Supplier[/COLOR] 1040 RptLoc = RptLoc + 1 1050 rs.MoveNext 1060 Loop 1070 XL.DisplayAlerts …
Hello App/Machine Coder.... How are you all?? I am trying to developing Macro Excel VBA Application. but when i am trying to run/compilie it shows me an error called "compile error can't find project or library" and when i'm click ok it redirect me to Refernce page and shosw me …
I recently formatted my hard drive and I've re-installed Office, all my OneNote notebooks are synced to the cloud. I opened OneNote, newly installed, and signed into my Skydrive account but nothing syncs, nothing downloads from the server, so I have no notebooks. Opening Skydrive in a browser and downloading …
Hi all, Ok so here's the deal, I work for a world wide recruiting company which has offices in multiple locations, for each office our sales team have a windows xp desktop connected to a flat screen(via VGA) displaying a power point presentation showing I.E. Most sales, annual income, blah …
I am using Windows 7 home primium.The microsoft office 10 is built-in.But I can not install Microsoft Office 10-free version.It shows that- The set up can not find Pro Plus\Pro Plus.WW/cab. Can any one say what is the problem? Pleae help me.
Hi, trying to create a .doc template which I can use in work for a brochure.The top of the page is blue with a logo and the two sides and the bottom are the same blue. What we do now is print out onto paper with this border already on …
Hello Members, Would anyone please take a look at my attached excel files which is a commodity exchange's end of the day data file. This is a free copy which anyone can download from their websites. Those are ([url]www.mcxindia.com[/url]) & ([url]www.ncdex.com[/url]). Now my query is in those two files there …
Office 97 being run through Windows 98. I don't know exactly what I did so I don't understand how to reverse it. I was creating a Word document and tried adding some clip art. When it posted on the page, a second page was created below and all of my …
[CODE]<?xml version="1.0" encoding="UTF-8" standalone="yes"?> <?mso-application progid="Word.Document"?> <w:wordDocument xmlns:aml="http://schemas.microsoft.com/aml/2001/core" xmlns:wpc="http://schemas.microsoft.com/office/word/2010/wordprocessingCanvas" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:v="urn:schemas-microsoft-com:vml" xmlns:w10="urn:schemas-microsoft-com:office:word" xmlns:w="http://schemas.microsoft.com/office/word/2003/wordml" xmlns:wx="http://schemas.microsoft.com/office/word/2003/auxHint" xmlns:wne="http://schemas.microsoft.com/office/word/2006/wordml" xmlns:wsp="http://schemas.microsoft.com/office/word/2003/wordml/sp2" xmlns:sl="http://schemas.microsoft.com/schemaLibrary/2003/core" w:macrosPresent="no" w:embeddedObjPresent="no" w:ocxPresent="no" xml:space="preserve"><w:ignoreSubtree w:val="http://schemas.microsoft.com/office/word/2003/wordml/sp2"/><o:DocumentProperties><o:Title>OPERATIONAL CONTROL AND FLIGHT DISPATCH (DSP)</o:Title><o:Author>Bekhit Shoukry</o:Author><o:LastAuthor>Sudheer Kokirala</o:LastAuthor><o:Revision>2</o:Revision><o:TotalTime>0</o:TotalTime><o:Created>2011-10-29T04:58:00Z</o:Created><o:LastSaved>2011-10-29T04:58:00Z</o:LastSaved><o:Pages>4</o:Pages><o:Words>1101</o:Words><o:Characters>6279</o:Characters><o:Company>IATA</o:Company><o:Lines>52</o:Lines><o:Paragraphs>14</o:Paragraphs><o:CharactersWithSpaces>7366</o:CharactersWithSpaces><o:Version>14</o:Version></o:DocumentProperties><w:fonts><w:defaultFonts w:ascii="Calibri" w:fareast="Calibri" w:h-ansi="Calibri" w:cs="Times New Roman"/><w:font w:name="Times New Roman"><w:panose-1 w:val="02020603050405020304"/><w:charset w:val="00"/><w:family w:val="Roman"/><w:pitch w:val="variable"/><w:sig w:usb-0="E0002AFF" w:usb-1="C0007841" w:usb-2="00000009" w:usb-3="00000000" w:csb-0="000001FF" w:csb-1="00000000"/></w:font><w:font …
The HP Compaq Elite series of business PCs has an extremely wide array of available towers all focused on delivering the computer power needed to run your business. After our recent review of the [URL="http://www.daniweb.com/hardware-and-software/pc-hardware/motherboards-cpus-and-ram/reviews/387133"]8200 Elite Ultra-Slim PC[/URL] we were excited to see what else the line had to offer. …
Inbox repair tool for Outlook 2007. I have never had problem with mine but husband is going crazy - has uninstalled and reinstalled Office 2007 3 times. Still cannot get into his Inbox. Please help us!!:-/
hello friends, i have a windows project in vb.net, in which i have to connect my project with an excel database i have microsoft office 2007 installed on my lappy.. please help me with the code. thanks in advance..
Hello, as anyone reading this might have guessed I need help. And please forgive me for making it long. [COLOR="Green"]You may skip right to [B]Found Half of a Solution[/B] if you don't want/need the background of my problem.[/COLOR] [B][U]Why and What[/U][/B] I am developping for a client an Excel worksheet …
Hello, I'm still trying to work out the same problem: how to process data from an Excel sheet (above all sort through it but in groups; will explain further down) to use in a Cluster Chart without storing it as data in an Excel sheet. The problem at hand: I …
Hello, it now seems that I might be able to use SQL/MS Query to do what I tried to find a [URL="http://www.daniweb.com/software-development/visual-basic-4-5-6/threads/388319"]workaround[/URL]. (Even if this works that does not invalidate the problem posed in that thread, though its urgency would be reduced.) So: is there a way to perform in …
Opened Word and the cursor is at the top & not were is should be. Tried to reset by going to Page Layout, Margins and setting to 2" on all sides. This will not work. Closed Word. Did a HD search for Normal.dotm. Double clicked on this and same thing …
Hi Guys, I have a Toshiba Satellite laptop running windows xp currently but it does not install Microsoft office packages for all versions. i tried changing the os to Windows 7 though still it could not install office... can anyone help out there?... Thanks..
Can anyone tell me ?.Why i am getting the following error ?.i don't want to delete my emails .Kindly let me know the idea .is there any way to resolve this issue .without deleting my emails from inbox.any help would be highly appreciated. You will receive a warning when your …
The End.