[office-suite] Forum Topics

Seems this wouldnt be too hard, but I'm scratiching my head bald... I have multiple workbooks. They are all housed in the same folder. WBa, WBb, WBc. I need to combine these, (or at least a Worksheet from each) and have them tally a certain column, which seems easy enough, …

I have a document that include the chapter numbers in the page numbering, but when I run the table of content I can't get it to include the chapter numbers with the page numbering in the table of content. Also the first 17 pages of the table of content is …

Sheet1 A1: Football A2: Rugby A3: Basketball Sheet2: A1: A2 A2: B4 How can I get a location of a field from String? Is it even possible? *eg. I want to tell the contents of cell A2 in Sheet1 by getting the string value "A2" from cell ''Sheet2'!A1'*

Can anyone show on how can i move an image on an excel sheet to a specific cell. Thank you in advance.

Hi, can anyone help me. I've trying to display existing word document in vb.net but i keep getting this error: D:\System-new\DLIMS\PSM2\FormUserGuideWord.vb(58): Type 'COMExceptionMessageBox.Show' is not defined. I have add reference (Microsoft word 11.0 because im using ms word 2003) to my project but i still cannot display the word document. …

i want to upgrade MS Office 2000 to 2010, i m using Windows 8. is it any method available which help me to upgrade all files into upgraded version??

Hello, I would like to create a macro. I have two worksheets, both containing an ID. Would like to update the price from the second worksheet corresponding to the ID. Any ideas? I am quite new to this so a bit of guidance will be appreciated.

Sorry in advance if this is the wrong place for this, it's the closest I could find. I need to create a macro for an Excel 2010 spreadsheet so that the active cell will cycle through three choices: "Y", "N" or "" - the last being simply an empty string …

Hi I'm new with Linux, and the class I'm in is using Fedora 13, so I installed Fedora 13 on vmware. It didn't come with OpenOffice so I had to download it and being a first time user of Linux it was not fun. The instructions said to open terminal …

Hi All, M trying to design a web portal which shows all my trackers and allows me to open it . the trackers are in ms Excel format. Please suggest me d best possible way to achieve the goal. Thanks Mukul

Hi, SIR I HAVE A SHEET IN WHICH I HAVE 6 COLUMNS FOR RICE INVENTORY. 1)Report No 2)IN/OUT/PROCESS/Fg(This column show whether Rice In, out,Proceeds & Finshed goods) 3)Product Name 4) In (If In & FG i have make entry of quantity in this column) 5) Out (If out or process …

Greetings community Excel Errors: Unreadable content error in excel 2010. I have gone to many web sites in the past month or two and not able to solve this error. I dont have a pivot table. I hope somebody will direct me to right solution. Thanks

Machine running Windows 7 Pro 64 bit. MS Office 2010. Problem is once there is a spreadsheet open and minimized and you click on a second spreadsheet shortcut, it won't open. You will get the blue circle so it is trying. You can do it through file/resent files and open …

i have a document written in MS Word 2003 and the structure of the document is as this is a line number 1_p1 this is a line number 2_p1 this is a line number 3_p1 this is a line number 4_p1 this is a line number 1_p2 this is a …

Yesterday (October 25) I spent a few hours working on a Word document. When printed out, it is six pages long. This morning (October 26) when I opened up the document to resume work on it, all my latest work was gone. The document property indicates it was last modified …

I'm currently pulling out information from column B in an Excel worksheet + the worksheet name. How would I go about pulling information from column J (which has the same start row/end row as the information pulled out from column B) in the same worksheet and assigning it to the …

hi i have a code here that export my listview items to excel but i want to customize each cell size and i want to format the date and landscape environment Try Dim objExcel As New Excel.Application Dim bkWorkBook As Workbook Dim shWorkSheet As Worksheet Dim i As Integer Dim …

Hi, I want to write a VBA macro in Word that open an Excel file, save that Excel file to another file (to another name), and then clear all content of the original Excel file. How to do that? Thanks!

good day.. i have a slight problem in my enrolment sytem. im new in vb programming, and this problem perfectly work in stressing out and pressuring me as begginer. i have a listbox that contains all filtered data from my database. and i want it (all entry in the filtered …

I am using following code. It creates a macro button on word menu in Add-Ins tab Public Sub ShowToolbar() ' Assumes toolbar not already loaded ' Application.CommandBars.Add TOOLBARNAME AddButton "Button caption", "This is a tooltip", 526, "NameOfASubInYourVBACode" ' call AddButton more times for more buttons ' With Application.CommandBars(TOOLBARNAME) .Visible = …

hi my name is vishal. i have been trying long to figure out to export data from vb6 using join queries in sql to ms word. here is my sample code i have tried: Option Explicit Dim dIsVisible As Boolean Dim inst As String Private Declare Function ShellExecute Lib "shell32.dll" …

I am trying to apply conditiona formating to shade every other row with a different colour. I am applying the following formula =MOD(ROW();2)=1 and nothing happens, if I use a coma instead of a semi colon I get an error. Can somebody help me. Thank you.

I'm not sure if this is the correct board to ask this on but it looks like the best match. I'm having a problem with an MDaemon mail server and trying to upgrade Outlook. Currently they are using Outlook 2003 and are wanting to upgrade to Outlook 2013. I've upgraded …

my office is solved somehow. i don't know how i have done that. one more arises now. that when i click on say "micosoft powerpoint", then it opens calmly and without any problem. but along with that, (after few seconds), confiferation progress starts and then after few minutes , that …

Recently I try to export contact from Samsung Note II and import to Microsoft Outlook. First I export into .vcf format and use Outlook to import. But because it has telephone contact as well as e-mail make export and import somewhat inconvenience. So I post here to ask whether anyone …

hi my name is vishal i am using vb6 as front-end and ms access as back-end.I dont want to use data report instead i want to export all these multiple tables values to excel into a single sheet.I am using a command button and whenever i click that command button …

Dear All, I'm working on application in C# which needs to filter "blanks" in one column and copy some value from other column instead. Filtering works perfectly, but copying is not so cool.. It copies some lines, but rest left blank. I cant find out where is problem. If possible …

Hi I used below coding for create a excel sheet.I got from on web site. In below coding there is no problem.Its create the excel file.If i run second time,its ask to overwrite the current excel file.If I said "Yes" then it ok ,but If I select cancel button,its generate …

Hello, I am trying to write a macro for Excel 2003 that will allow me to search for two words in Sheet1, copy all the data below those words, and then paste that data in Sheet2. That part I can get to work. My problem is that I have multiple …

Hi CAn anyone help. I have had several incidents of a virus called pianoman that attacks MS documents and adds an extetion 'pianiomancorupt' on all microsoft office documents. No antivirus or virus tool i have tried is helping at the moment. Please help!!!

Hello Can someone please suggest a code snippit that can create a new memu item in Microsoft Excel 2007,'s top/main menu? Thanks

Hello, My next school project is in microsoft excel. However school are using 2007 and it seems to be rather expencive. Now I could use skydrive/google spreadsheets to do it however it needs to be handed in, in xlsx format. Therefore it would be wise to just get office at …

I am trying to figure out if and how it would be possible to implement something like a conditional statement for the excel spreadsheet my program writes to. The spreadsheet is created on the fly each time the program opens up. I would like to place a statement along the …

Hi-- It has been a while since I posted anything here. I am compiling a list of Lighthousesthat are located in Norway. Some of them have the extra letters that the Norwegian alphabet uses. It appears that when I do a regular Excel sort that these letters do not sort …

I can open word, replace words, create word documents, but I can find any way of opening a word document and reporting back that a certain word or prase has been found or not. I see there is a function word.find.found but it never seems to report back anything but …

Dear all, Im getting a problem in Excel. Vlookup formula is working correct. Now the problem is when more than one time asc-1 comes in posting column, it do not show the 2nd name with asc-1. Formula for the vlookup is : =VLOOKUP(N15,A11:G87,2,FALSE) What will be the solution and how? …

I receive an error message when i install an Office Software or open an Office program or document.

Good Day all, My question is When I get the schema of an EXCEL worksheet with Column headers I get what's expected the names of the columns but when I get the schema of a worksheet without headers I get the first row of data as the Column Names. The …

dear friends, icreated small project to open excel using vb. everything works fine with one exception. i used VB express 2010 in xp OS when developing the project. when it runs on the windows 7 platform the opening excel file goes behind the my application. the VB form topmost function …

I'm trying to use two Outlook 2010 accounts and profiles on two computers and two servers by storing all outlook files on an external hard drive. The problem is that one one server is an Exchange server, the other is an IMAP server. Since Exchange creates an ost file that …

Hi guys. I am having a problem where by microsoft Excel will not allow one of my users to overwrite a file that is within her share in the server. We get the error "Document not saved" when trying to overwrite but are able to save a new document. I …

when i click my any microsoft office's product then it start geetting installing. it is installed from 4-5 years and was wroking fine. it happened 10 days before. now i cant open my word, excel or any other file. when i try to unsitall it , it says "this product …

Hi guys, can anyone help me in excel. Is there any option for hyperlink worksheet to particular text....? Thanks

I've got these two tables on two different worksheets. A1: ID B1: Name C1: Locality D1: ID_2 E1: Status A1: ID B1: Name C1: Locality D1: Status Basically I need to match the two tables via "Name". If the names are similar I want to fill in "ID_2" with "ID" …

Hi, Can someone help me. I need to create a VBA project in excel using combo box. For example, I have in column A, combo box of ITEMSA and in column B, combo box of ITEMSB. If I choose items from ITEMSA, just the corresponding items that will match will …

Hey everyone, I am trying to create an excel spreadsheet that is populated with data from a table in sql server. I would like to make it so it will update several times a day with out the user having to do so. I have no clue how to go …