2,270 Topics
Hi there I have a problem. My code works perfect, but now I want to, instead of displaying multiple sheets, display all data in one sheet. Below is my code I used: [ICODE] Private Sub Picture2_Click() Screen.MousePointer = vbHourglass Dim tempAss As String Dim xlApp As Excel.Application Dim wb As …
if anyone install office 2007 without backup of outlook 2003 mail and that person upgrade MS Office 2003 to 2007 and after installatin when i open outlook 2007 one error msg show "application not found" so plz tell me what should I do. If i restore my system, problem will …
What is the connection string to write for importing mixed data from excel sheet to data grid My problem is, I have rows like 1 2 3 4 5 6 7 8 9 a b c d in excel sheet.But when I imported these rows only 1-9 imported succesfully but …
In my form I have a graphic in a picturebox- simple stuff. My application prints a bunch of stuff to an Excel file- everything works perfectly with no problems. I need the image in the picturebox to print to the Excel sheet. I've tried a ton of code but nothing …
Hi Friendz.. Can you tellme why office 2007, preinstalled in vista is not accepting the product key ,which is being supplied with compaq 6510b.
I am unable to open a 1991 Word file with a .Doc suffix with Word 2003
Originally I was using Office Interop to import data, but that was a headache and a half for both me and my computer. Right now I'm attempting to load it with ACE, but my data grid isn't being populated. Once that's up and running I need to know how to …
Is there a way to have multiple conditions using some sort of "or" so that I don't have to nest so many if statements? I currently have cells like this: [code=Excel Formula] =IF(E2 = "District1","North",IF(E2 = "District2","North",IF(E2 = "District3","North",IF(E2 = "District4","North","Not North")))) [/code] I have tried using OR in two …
i need to write a code that will download an excel file from a website every time it is ran. what im trying to do is automatically import real time electricity rates into excel. im a beginner in programing and am seeking help for my senior design project. Thank you
I had to rienstall my op system but I did not realize I had lost my case for office 97. now I do not have the code I need to install it all my file I saved on disc's are in office format's (word, excel, ext.) so I can not …
a client has microsoft office 2003 all fully updated, and adobe reader which is also updated, but when she opens the pdfs from her email in outlook, at first it only shown a line where something had be underlined, and now she only gets the first two lines of text. …
hi im trying to create a small excel addin in VS2008 byt i cant figure out how to write lika a string or an int to a specific cell? for example: i want to write something in cell B1? how do i do that in the C# code? it must …
Hi, I am currently developing a tool in VB 6.0. I am facing a problem when i generate reports in Excel format. The issue description: - When I click the 'Produce report button', the vb code will run a query and fetch the record into record set - and then …
I just updated Ubuntu to Lucid Lynx and also got an OpenOffice update: it's now 3.2. When I started it, the progressbar flashes to 100% in a second or two but to get from there to the actual program takes about two minutes. When I "top", I see that Java …
Hi guys, i need a help with separating characters by using dash in excel 2007. Example, Before: 12345678901234567890 After: 1234-5678-9012-3456-7890 Can anyone help me tell me how to do it in excel? I need to split over 5,000 columns with different characters. Thanks! Leevisse
Hi, I have this code. It is not working properly. Anybody may know the solution? Thank you [CODE]<?php include 'admin_homepage.php' ?> <div id="sidebar1"> <b></b><br /></br></br><img src="MMU_logo.jpg" width="180" height="150"/><br /> <a href="admin_view_student.php" style="font-size:13px" >View Student</a><br /> <a href="admin_new_student_reg.php" style="font-size:13px">Add Student</a><br /> <a href="student_excel.php" style="font-size:13px">Get Excel File</a><br /> <a href="student_mailing_list.php" style="font-size:13px">Get Mailing …
Since I installed the Office 2004 for Mac 11.6.1 Update, a few days ago, I cannot open three files. It seems that all other excel files will open without issue. I can view the contents of these three using the OSX (10.5.8) viewer with no issues. There does not appear …
Hi I am using axMSChart objects to display charts in my VB .Net Windows Forms App. I am also trying to export them to a PowerPoint presentation which I automatically generate using Office Interop. However, when I use EditCopy to copy the Chart to the clipbord and paste it into …
I hate the Office 2007 menu ribbon -- it is really awful and difficult to navigate such simple things as Open, Save, and Edit. Anyone know if there is a way to make the menus look like older versions of Office?
My configuration is Windows 7 and MS Office 2007. It is OK but in Word 2007 the galleries (for page number, header, footer etc etc do not open but blocks even the simplest page number or header Following instructions in the Microsoft kb925175 document I found both Document Building Blocks.dotx …
Hi there. Can anyone help? My colleague receives this error message when opening certain emails in Outlook 07 running on Windows 7. "Visual Studio Just-In-Time Debugger" "An unhandled win32 exception occured in OUTLOOK.EXE [3580]." I have attached a screenshot of the full error message. Thanks
On another thread that has been marked as solved, the suggestion was given, "Create a folder on your desktop called "Office.en-us". Find the same folder on the CD and copy "OfficeMUISet" to the folder on your desktop. Re-insert the CD so that the setup starts again. When it tells you …
H.i I have a Windows 7 laptop with Office 2007 which I am trying to repair, and getting the above error. I do not have the media, just the Key, so I can not copy files from a cd to the desktop. Can anyone please advise how I can repair …
Dear All, I am opening the excel file to create the object of that excel file using 'Microsoft.Office.Interop.Excel'. It is working fine with file system and local iis server on windows xp operating system. But when running the same code on windows 2003 operating sytem on local iis pagerequest time …
I run Windows Xp and I have Microsoft office 2007. But I mainly use the Outlook Express. I have Outlook express running in my tray. When i go to open it I get: "Outlook is not responding. If you are using an Exchange server e-mail account, you can cancel pending …
Hello all.. I am a new user of Windows Vista (came installed on my new laptop). Which Microsoft Office Suite is the best version to run with Vista. I want to install one that does not hog all my resources and take up too much space. Also, when you install …
Hi I dont think I ever untapped the powers of Excel for advanced analytics. Thus, as Im going through these tutorial books, I do wonder what are your tips to help you analyze data quickly and efficiently. Help!
I just purchased a Dell studio one from a pawn shop and chose not to wipe it clean with new OS because of the touchscreen software. My problem is I can't download the trial version of MS Office on it (Home and Student ver) because it says there must have …
I am grading tests and have set up Excel to do it. Here's my question.... I have 2 columns: #A has the [U]number of the question/answer [/U]#B has either .. "1" if the answer is correct or "0" if the answer is wrong. In another cell I have how many …
Created a document containing both graphics (jpg) and texts -- English and Bengali (Bangla) in a PC running XP Home version. When I copied the document on a CD and loaded it in a laptop running XP Professional, the document does not open properly. Images and English part of the …
Hello everyone. i really need help on this one.. sorry for bad english! I have made 2 listbox.. listbox1 and listbox2. data on listbox 2 comes every after i double click listbox1 data. my codes for that works properly. i am working in a excel worksheet. i have these columns …
I am exporting data to an excel file. This works, however, one of my columns doesn't format properly with currency. Through code, how can i make an entire column currency just like when i do it through Excel itself, by going to the format options. I have tried using the …
Hi, I need a macro to refresh all workbook connections and then save and close the file. The connection information is present in .odc files. My problem is that the macro moves to the next step before the refresh is complete. I noticed that by default the 'Enable background refresh' …
Hi everyone, I need a script that will redirect an excel API from one database to another using VB.net. I am still a novice. I need your help. Thank you.
Ok, here's what I've got. I have a form that exports to an Excel worksheet (sheet1) and it works great, no issues there or anything. It's not a template, just a regular .xlsx spreadsheet, but I use it as my template. Now, the goal is for the end user to …
Hello everyone! Trying to setup a connection to a website to be able to update currently displayed data and push it on a regular basis to my spreadsheet. The link I have is a direct link to download the newly updated spreadsheet. I continue to get an error message when …
Can anyone recommend an ODBC driver for Excel in VB 2010 Express? This is a 'legacy' problem having just being forced to move from VB6 to 2010. Any help well appreciated
I can not open any links in mu outlook, it was working fine a few days ago. I get a error message that says "" The operation has been canceled due to restrictions in effect on this computer. Please contact your system administrator." I search on here and the link …
I recently moved MS Office 2003 from an old computer to a new one. Now when opening an Excel spreadsheet located on a server the font is wrong. The font is TW condensed 8, but it displays and prints in a larger font. TW condensed does not show up in …
how do i have the scan,when i right click the cursor in my laptop? and why my microsoft office does not work,,,what should i do?
Help! I am freaking out right now. I have a ridiculous amount of work to do today, and in the middle of it all, I cannot get to any of my mail. When I open Microsoft Outlook, the Outlook Today screen appears and a little bubble appears near the system …
how to calculate columnwise total in excel sheet in java using HSSFworkbook
I cannot figure out the declarations to write to an excel file that is already open. I open the excel file and make it visible with this: Private Sub Button1_Click Dim objExcel As New Excel.Application Dim objWB As Excel.Workbook objWB = objExcel.Workbooks.Open("F:\My Software\files\test.xls") objExcel.Visible=true End Sub What are the declarations …
Hi, Was wondering if someone could answer why I don't have any contacts yet when I go to send an email all my contacts are there? What file do I need to import to get them back into my contact list? I upgraded to Office 2010 (Student Ver) and had …
Hi, I need to compare following xml file USING C#: [CODE] <Issue> <IpIssueId>790</IpIssueId> <IpIssueGuid>11</IpIssueGuid> <IssueName>Summary</IssueName> <RuleQuery>Rule1</RuleQuery> <Classification>R</Classification> <IssueError>Summary</IssueError> <Severity>100</Severity> <IssueFormat>Total domains: [[DomainCount]] </Issue> [/CODE] with excel file like: IssueName Type Summary Risk(R) bb Health(H) I need to verify whether "type" column of excel matches with "classification" tag of xml file.
I created a project with some bmp images and logos in it thru MS power point 2010. I did all the image adjustments and resizing within the power point and put some word art also. The images were in blocks. Now when i have converted it into pdf(thru a great …
My form fields will populate an Excel workbook. No problems there. My question is how do I call it to enter the data into an Excel template I have already created? The location of the template sits in my C drive- C:\DailyLogs\DailyLog.xlsx Here's my code so far: [CODE]# ' Here …
As title mentioned, I wish to execute VBA excel macro code with VB.net?. Hope anyone have idea of it. Thanks. :)
I want to buy MS Office 2007 or 2010 Professional and I can find it on Ebay at an average price of $175 US. I am wondering if there is some reason I am not aware of to not buy any of these programs. What do I need to know …
I want to PRINT the formatting marks (space, paragraph, soft return). I can view on the marks in my document on screen, but they do not print. I have been to TOOLS, OPTIONS, and VIEW tab, selected ALL under formatting marks this enable viewing. But when I go to PRINT …
The End.