[office-suite] Forum Topics

could any one please help me with the code for creating a MS word document from a record that already exists in the database using vb.Net coding.. thank you in advance

A simple timer for Excel VBA Excel VBA does not have a timer control. The alternative is to use the Timer() Function, and that leaves much to be desired. This code should be placed in a code module. My need was to tend to an abandoned program that was waiting …

I've written a script to alter images in a number of Excel workbooks. In order to properly access the image information, I need to iterate through all Sheet.Shapes on a particular worksheet. I'm having trouble with grouped worksheets. **How do I ungroup worksheets from VB.NET?** I've tried both activating and …

Can anyone help me. I have this excel data that i want to transfer to a ms word. Or can i convert an excel file to word? Thank you!

Hi, I am doing the determination password protection for workbook without opening the workbook. Is it possible to do determination password protection without open workbook...?

**Hi..I get above mensiond error while converting excel file to pdf please help....** ///Converting excel file into pdf format... string Despath = "D:\\Jaimin\\ExtractData\\"; Microsoft.Office.Interop.Excel.Workbooks myExcelWorkbooks = null; Microsoft.Office.Interop.Excel.Workbook myExcelWorkbook = null; ExcelApp = new Microsoft.Office.Interop.Excel.ApplicationClass(); ExcelApp.Visible = true; object varmiss = Type.Missing; object valmiss = System.Reflection.Missing.Value; myExcelWorkbooks = ExcelApp.Workbooks; myExcelWorkbook …

Further along in this code I'm trying to access processRow, which is of type DataRow, but I get a RowNotInTableException This row has been removed from a table and does not have any data. In an attempt to figure out when this data is getting deleted, I added a bunch …

Hello group; I have been searching for a way to run an external macro on an excel sheet automatically. I have found some code including this local suggestion http://www.daniweb.com/software-development/vbnet/threads/332821/run-excel-macros-with-vb.net# which looks good but I am baffled by the final instruction **"just remember that you have to have an excel sheet …

So I must build an app that has to do with mail address management and more. Let's say the user has an excel file with 2 millions of rows (email addresses). I made it the oledb way and the first mistake I made was putting ~500k rows in a datagridview, …

Hello, I am using VBA userform in MS Excel to insert data for database purpose. When I tested it for the first time, it was running okay. But after I saved it and used it again to insert the real data, it happens to repeat/duplicate the data to multiple times …

HEy guys, I got possible a stupied question but i was wondering... if you are useing microsoft runtime on all of your clients computer in a office of like 150 clients. If i put a package together with MS runtime and current databases will runtime be able to to automaticlly …

guys, i have a pst file on a windows server 2003, this morning it gave issues connecting. when i checked it i realised that the size was 64 kb, run a scanpst and it became 254kb but still there is no information in it. how can i restore or repair …

Hey guys, im looking to take my existing excel 2003 spreadsheets (.xlsx) and i need to convert them to (.accde) file format. ive been looking and looking and cant seem to find out how to do it. If i could possible get the steps or how to go around doing …

Hi, This is going to be the least important post you will read, but if anyone can help me, I will still appreciate it. Every fall I have a small weekly football contest with my friends for fun. I have an html file with 20 games on it, players choose …

Good day folks, I've been wondering how can I open an excel file in vb.net. Can somebody help me? I always get this error below: > The RPC server is unavailable. (Exception from HRESULT: 0x800706BA) Thanks in advance

My company is using a simple spreadsheet to write down things from control surveys. Then the data is beeing saved in a big and useless program. Since the data is beeing saved to a database, I want to view this same spreadsheet in a ASP.NET page, with the textboxes filled …

Is it possible to create a delimited file and structure the delimited file in some way so that opening that file in Excel creates an Excel file with multiple worksheets with data on each worksheet?

Situation: My VBA program compiles, but fails at runtime when I try to access a specific method. It doesn't seem to matter whether I set the method up as a function or a property get. Here is the code fragment which calls the method: ****** Function roots() As Variant ' …

Good day pals. please i need a VBA code that could make ms excel automaticly tell the maximum point of a curve in a chart. Secondly, another code that would make it automaticly tell the Y-value of the point of interception i.e when two series or range of values are …

I spent the last 8 or so hours trying to install Microsoft Office 2010 on Windows 8 Pro. Didn't happen. I called iYogi tech support who tryed to help me for the last 3 hours with no success. We finally concluded Office 2010 is not compatible with Windows 8. So, …

I'm trying to generate a random number for each field in column "A" of my spreadsheet, and I have been trying to experiment with the following formula: =LARGE(ROW($1:$1000)*NOT(COUNTIF($A$1:A4, ROW($1:$1000))), RANDBETWEEN(1,1000-ROW(A4))) This is giving me the numerical values that I want, but is affecting both Columns "B" and "C" as well. …

Hi Guys... looking for a quick answer on excel Formula.. Anyone know why my text "Please Chase" is not showing up? =IF(ISNUMBER(F2),$F2>TODAY(),"Please Chase")

Good day folks, lines = IO.File.ReadAllLines(txt_Source.Text) I have here a line of code which reads a text file and save it to an array, It works well. But I wanna ask if there is anything like this code that can be use to read a excel file? Something like this …

Hi ! I have a column of 'City', now I want to compare the value of each cell of 'City' against the column 'City_Check'; the cell where the value matches, pick the value of 'City_ID' column & replace the city name with that ID in the 'City column'. * The …

I have data in which column 'C' have cells which contain multiple values separated by (,).Now I want to get atomic values in all cells of column 'C'. i.e. that for a cell when there is more than one value; separated by (,) it should be copied in the next …

does anyone know how to make syntax of max if in vb excel 2007? (not formula)

I am trying to set the value of cells in an Office 2010 worksheet using this code in Visual Studio 2012: for (int i = 1; i < 5; i++) { xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(i); int columnCounter = 1; foreach (string s in columnNames) { range = ((Excel.Range)xlWorkSheet.Cells[1, columnCounter]); range.Value = …

I want to put the total on the last row of the sheet regardless the number of the records. If 10 rows are populated, i want to put total on 11th row. If 12 rows are populated, i want to put total on 13th row. If I based the adjustment …

hi... I had encountered a problem with ms office. I had uninstalled the older ms office then when I want to install the new one, I had encountered an error during setup. It says that "error 1935. An error occurred during the installation of assembly component{D825F1F0-87AB-11DB-A54F-0090278A1BB8}. HRESULT:0x80070020." I hope someone …

i want to save the image together with excel file. Like this, this is my code converting vb report to word: ActiveDocument.Shapes.AddPicture FileName:="" & App.Path & "\logo1.jpg", Left:=140, Top:=0, SaveWithDocument:=True Is there an option on excel like "SaveWithDocument:=True"

I have tried many options outlook provided, but it still doesn't work. the error box heep prompting up asking me to verify the pop server, my account, and password, after I confirm it, it come up again. when I cancel it, then the dialing prcoess ended with error sugestion.---that the …

Today, I had a new project dropped on my desk and was informed that by the end of the week, I need to have exported the entire payroll into a new format. it exports to csv, which is then imported into access, and needs to be exported into a csv …

hello everyone here, I have deleted the office system, but outlook is still there and could run itself, I am not sure that I deleted office compeletely or not, I deleted it from add/delete of control panel, now I can't find outlook in add/delete control panel, but it still could …

A message comes up saying Setup cannot continue because a required file is either corrupted or not available. Run Setup again from the original disc or download location. But I went to Microsoft and downloaded it again but nothing happened! What should I do to uninstall it???

hello guys, This is my problem for example. My program is on my computer the image location of my picture is on my computer then i want to debug my program into other computer but the picture is not appear because the location path is changed this is my code …

I am working on a project in which i do some calculations for products and produce some end results then browse an excel file containing reference value for the products, but now i require that if a particular product is not found, that product should be automatically added to the …

Does anyone how to hide excel macro worksheet each time excel 2007 starts up? using vba syntax thx

I am opening a tab-delimited file in Excel 2010; the delimited file displays correctly in Excel but when I do a save as, to save it as a native Excel 2010 format, the resulting saved file is empty. The resulting saved file generates no errors when debugging and saves with …

Hello everyone my name is andy... is anyone know how to make a simple data entry worksheet in excel 2007? i noticed that excel 2007 have a form control inside the developer tab i can add input text box and command button in sheet1 but i dont know what syntax …

Hi guys,i just wanted to know how to export a record when ever a user clicks from a listview and export it to excel by adding a worksheet whenever the record is more than 3,basically excel offers 3wrk sheets. can u help?Thank You!!!

Hi I try to convert ppt to video:; i know that CreateVideo is part of presentation. but, when i try this i have this error: Inline Code Example Here Looks like createvideo is not part of presentation. Microsoft.Office.Interop.PowerPoint.Application pptApplication = new Microsoft.Office.Interop.PowerPoint.Application(); Microsoft.Office.Interop.PowerPoint.Slides slides; Microsoft.Office.Interop.PowerPoint._Slide slide; Microsoft.Office.Interop.PowerPoint.TextRange objText; // Create …

hi ya'll I have been trying to convert my text file to excel and inducing filters in the .xls,but failing .. internet doesnt help much or atleast I havent fount anything worthwhlie Could u plz help ?? ~cheers

I am using this function to convert the contents of my richtextbox to html: Public Function myRTF_To_HTML(ByVal sRTF As String) As String Dim MyWord As Microsoft.Office.Interop.Word.Application Dim oDoNotSaveChanges As Object = Microsoft.Office.Interop.Word.WdSaveOptions.wdDoNotSaveChanges Dim sReturnString As String = "" Dim sConvertedString As String = "" Try MyWord = CreateObject("Word.application") MyWord.Visible = …

I am trying to add an excel file(.xlsx) as a database to my vb.net 2010 project. But it does not recognize excel as a database type, it can only connect with access or sql. Any idea how excel can be connected to the project? Or should I just use file …

Would be possible to have a new category added to Software Development for MS Office macros (VBA)? Right now these types of questions often get asked in the VB.Net forum. The best match available is VB4/5/6, as VBA is a VB6 dialect, but this also not a good option as …

Whenever I want to delete row my excel file in c#. I have get error. I tried much much codes on the net but I can not solve my problem. Please solve my problem... Regards,

Good day, I am having trouble with the excel file that i was uploaded.. after i uploaded the excel file i want to validate each header and each datatype of it. just to make sure that my dbase has integrity.let say i have 10 columns. Is there a way on …

hi friends! From my Microsoft Access form I would like to hyperlink to a pdf document. At present each record contains a document name and a full file path to where the document is stored. I would like to open adobe Reader and view the specified document. please give me …

Hello friends, I'm tring to make excel file using vb but i don't know how to do it. There anyone know how to do this. Thank you. Eko

I have a program I wrote a few years ago that interfaces largely with MS Excel. At the time my company used Office 2007. We have since upgraded to 2010 with no problems. However, I had to make some adjustments, and now I can not compile. The error is Error …