[office-suite] Forum Topics

I'm getting an excel range to an array. From my search it was clear I need to use object array. object[,] saRet; oRng = oSheet.UsedRange; saRet = (System.Object[,])oRng.get_Value(Type.Missing); This works fine, but what I really need is for that array to be string. So how might I cast object[,] to …

Hi, so I have a dataset which I am using to create a CSV. When I run the code in debug mode and use the datatable visualiser all the data is shown, however when it opens in excel the last two cells of the last row are missing. I can't …

Hi all, I would like to return an array of String variables from a C++ DLL to a VBA application. My understanding is that: [LIST=1] [*]To do so, the C++ function must return a SAFEARRAY of BSTR. [*]Although Excel uses BSTR containing wide characters (wchar_t), VBA itself uses BSTR with …

We have a shared network drive with excel spread sheets on them, the connect between the two buildings is via a microwave, and every now and then the spread sheets will lock up. Can anyone suggest a budget sensitive solution that could improve the connection, and/or help with the freezes?

Hi Evryone. I'm new to this group , this being my first post. I have a query which if sorted out could benefit allot. I have searched bt couldnt come to a solution. I just need a direction and a say that "[B] whatever i'm proposing to do is FEASIBLE"[/B] …

**Issue:** Several people here are having an issue. While working on Word Documents located on their local drives, the document becomes [Read Only] not at the start, but mid-session. **Attempt:** In Word, I have gone to Options -> Trust Center -> Protected View and unchecked all boxes. I have gone …

hy when i run this command to open excel and i get error (on 2007 excel it was fine) //Excel.ApplicationClass xlApp; Excel.Application xlApp; Excel.Workbook xlWorkBook; Excel.Worksheet xlWorkSheet; object misValue = System.Reflection.Missing.Value; SaveFileDialog oDialog = new SaveFileDialog(); xlApp = new Excel.ApplicationClass(); ** xlWorkBook = xlApp.Workbooks.Add(misValue);** xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1); int i = …

Hi Group, I've written a macro to save a copy of the spreadsheet at the end of each day. I tried to test it as a shared file and learned the macro wouldn't work. Is this normal for a shared document? If so, is there a way around this? How …

hi i have a excel file named as myexcel.xsls file and there are 10 sheets in that excel file named as summary,detail,kpi,orders etc etc.In excel sheet summary there are 5 tables in it named as Table1,Table2,Table3,Table4,Table5.Tables are created like I want to get Table1 records into the Data Table so …

Have what I believe is a PST folder of downloaded email from an Optimum Online account. - Within Outlook how can one confirm that this is PST file/folder - What is the proper way to get these emails to a DVD, then check if the transferred data is correct

hi, i am trying to print report by ceating excel file and print. but getting below error when creating sheet2. osheet = obook.Worksheets("Sheet2") Invalid index. (Exception from HRESULT: 0x8002000B (DISP_E_BADINDEX) worksheet1 works fine. I have Excel 2013 installed on my system. what could be the problem. Thanks

Hi group, I've written some VBA code behind an Excel spreadsheet to check to see if another workbook is open. If it isn't open, I'm having the code open it for me. This works fine the first time the macro runs. However this same spreadsheet has a cell where a …

Pls help i am developing a software that opens an excel file and count the number of pages to be print in vb 10. can anyone pls give me codes. ive been searching for this a very long time.

Hi, I was wandering if anyone could assist. We are currently Trialing office365 and would like to know if there was some way to use sharepoint to store documents (service agreements with our suppliers and warranties etc) And then notify us when they expire on a pre-selected date. Is this …

Hello-- I have two Microsoft Excel questions that I am not sure if I should post them separately or if it is okay that I post them both here. Also, I was not sure where to post them, so if someone sees this and can answer my questions or route …

Have an Optimum Online account soon to be closed. Is there specific guidance on how to move all of the mail to my desktop and, specifically into Outlook? What about PST files?? Guidance sought

Hello-- I have two Microsoft Excel questions that I am not sure if I should post them separately or if it is okay that I post them both here. Also, I was not sure where to post them, so if someone sees this and can answer my questions or route …

Hi all, When I create an event, appointment etc. in outlook on my computer, if I log into my live account and pull out the oulook calendar it won't show the items created in outlook 2003. Any ideas how to make it sync? Note that the contacts are syncing, it's …

system WIN7 64 bit - MS office Excel 2013 whenever I attach an excel spreadsheet to an email either Outlook or yahoo.com and then try to open or work on an existing spreadsheet I get the NOT ENOUGH MEMORY...... message and I have to kill & restart excel this has …

Hello to all! I'm creating a database and I'm using Visual Basic in Excel. I have a problem with showing the data in the text boxes. For example, I have a Text box and a search button. What I want to happen is that when I type an ID in …

I'm trying to write code in VBA in Excel that opens a desginated directory, finds all xls and xlsx files and then converts them to csv. I found two sets of code that do one or the other perfectly, but I can't make it work. I'm sure I'm just missing …

Hi Team, I would like to save my stored data which is in Access, to Excel but the thing is I already have the excel format in which I would simply like to fill the empty fields. Below are few screenshots for reference: 1) When a user checks Datetimepicker1, he …

Hi Team, I was wondering if I am the only one who is not able to do it or what. Well, as the title suggests, I would like to OPen Excel in vb.net. I was able to find end number of articles online on this but none would help. It …

Hello-- I am not sure where I should post this. I have an Excel spreadsheet with some cells I would like to concatenate into one resulting cell. I can get the cells concatinated, but I would like to concatenate one cell to the degrees symbol, followed by a space, followed …

Group, I'm trying to improve a macro in an EXCEL spreadsheet. The spreadsheet has multiple tabs (sheets), some of which have grouped rows in them. My "cleanup" routine needs to check to see if these grouped rows exist. Is there some code that does this (hopefully boolean)? If it helps, …

Group, I've created a large spreadsheet with a fair amount of code behide it. Historically it has run well and with no issues. However it has started giving me a "Run-time error '9': Subscript out of range" error. I have no idea what is causing it. It is stoping at …

I need to install Z tool in MS WORD and use the option in MSWORD

Hi all, I have no Idea how to implement spell checking in newly generated email. Outlook.MailItem newMail = (Outlook.MailItem)oApp.CreateItemFromTemplate(Template_eng); I want to use word inspector to check newMail.HTMLBody; - but I really dont know how to do that - and I couldnt find any example :( I used sth like …

hello everyone, I am having a problem regarding excel,I want to get the (network name) base on the network prefix of the (phone number) column using the value of the third column which is the (network) Sample output: Phone Number | Network Name | Network Prefix | Network Name 9162123212 …

Hello Group, I'm writing a macro to match dates from one spreadsheet to another. Specificially, SpreadsheetA has the date listed as text. I want to match that date to a range of dates in a column to find the row the matching date is on. I have some things that …

Unable to get my Word templates to stay in Print Layout. It is viewable but it won't allow me to click on it in the View tab.

hi everyone im really new to report viewer in vb.net and i wanto import the data from an excel file to the reportviewer in vb.net can anyone help me out? here is waht i tried so far: Private Sub ViewReport_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load ReportViewer1.ProcessingMode = Microsoft.Reporting.WinForms.ProcessingMode.Local …

hi, Can anyone help me about my other problem about excel? I'm trying to create a simple inventory system using microsoft excel 2010, and i have a sheets naming stocks & sales. i want to make it automatically subtract the value from the sheet(stocks) when i input the quantity of …

hi, Please help how to solve my problem about how to limit 11 digit number inside excel cell. i want to enter values like mobile number starting 0########## and deletes the excess numbers. thanks in advance

Hi, I already have an excel file (MyXL.xls) and a Visual Basic (Form1.frm) with a command button. Now, I want to write a code for the Visual Basic so that when I click on the command button, the excel file will be opened. Any help is significant to me! Thank …

what did I've done wrong with this code? =IF(OR(ISBLANK(C9),ISBLANK(B9)),"",IF(ISBLANK(C9),D9-TODAY(), "Reactivated")) I want to make an event that if b9 and c9 is empty, the value would be empty. if only c9 is empty, then the output would be the remaining days left between the two dates, and if the two …

I have tryed to save it then off the computer after few day, I turne on our PC but that don't work How to open our document any method to recover my doc file? Can anybody help me?

Hey guys, this is my first post here. I'm in a bind, because my computer crashed about a week ago and I'm trying to get all of my old data on my new machine. Thankfully most of my info was on a seperate server, and a friend was able to …

Hi I encounter the above error message while executing import excel data into sql data table. It worked fine in Mssql 2005 x86 and MS Office 2007 x86. But currently we upgraded the system to MSSql 2012 x64 and MS Office 2010 x86. I downloaded the accessdatabaseEngine.exe for MSoffice 2010 …

The company have the original license for MS Office 2010 Home and Business license product key but somehow it couldn't activate as show in the attahcement. It just show product not activated. I have try uninstall and reinstall again but fail. I have also try repair and change the product …

How to copy a word table multiple times to a specific place using VB.Net 2010? I have viewed the other responses and these seem just not to work. I am working on a VB.Net 2010 program using the Interop class. We are having problems trying to duplicate a table more …

I have created a workbook template that will be used to collect some data from users. I want to restrict user input to numbers between 0 and 20 in each worksheet range A1:C5 (say). I know I can use a Macro like below to do it With oSheet Dim r …

In my Windows application, I want to create an automation software using C#.NET which works in two steps: 1. Select particular data and copy it from a page of a website. I have done it using web browser control for SelectAll. The data is not HTML data but databound data. …

maybe i'm the last guy to use microsoft word 97, but... at some point, the word 97 spell & grammar check, along with the thesaurus [all under tools] is gone. spelling and grammar are grayed out under tools >> options. i uninstalled word 97. then reinstalled it. but the problem …

Hi All, I am using cognos report sudio 8.4. I have got a problem in adding each cell to its next cell data (means running total not addition two cells). I tried with available report studio functions like running_total, Moving_total. I got errors. I am automating excel reports into cognos …

I am having a problem with sharing appointments in my calendar using Outlook 2010 with an Exchange server. This is a small office of only two computers. The Exchange server is being used from GoDaddy to keep the computer and cell phone synced up. The person that recieves the phone …

Hi, I want to use the microsoft office theme (rubban for example,the word button's form) in my C# wpf application,is it possible? I work with visual studio 2010 thanks for help

I need to dynamically group rows together in an EXCEL worksheet. The obvious choice to do this will be VBA. I hope you can help. My spreadsheet has 18 columns and (up to) 5,000 rows of data. I've written the following code which works "OK" however it fails to group …

helo friends. i need to deal with more than 10 excel sheets.. so i want to make an desktop application in Visual Studio(c#), which performs as followings..: 1) first user can choose on which file he wants to work on. 2) then retrieving column wise data, and performing many mathematical …