2,270 Topics
Hey everyone, I am writing an Excel2007 macro at work because we have two large Excel databases to compare to each other. Basically we have our old database, and our new database. We want to compare the two and find the similar entries based on a particular column. The issue …
Hi the company i work for has recently updated all the windows xp machines to Microsoft office 2007 and i am having a bit of trouble. what i am currently trying to do is have an image frozen or locked to it can't be clicked or dragged around, any ideas?
Hi, I run Win XP home Edition. I use outlook v 6 for some emails. I get sent many word doc documents as attachments. When I click on an attachment in outlook, wordpad opens them, and I prefer that they be opened in Ms Word. tried to correct the problem …
When I clikc on any excel file in My Documents, open Excel (Office 2003) without choosed file (grey background). After thet I must open file with File/Open and choose file. I has looked in Options but I can't find what is not good. Thanks...
Does anyone know of any plug-ins/add-ons or a way to do sub-tasks in Outlook 2007? I work on a lot of projects at work and need some way to keep them grouped together. For example: Project 1 -Task1 -Task2 -Task3 Project2 -Task1 -Task2 -Task3 Any help would be much appreciated. …
In the code below I get a runtime error 13 or error 2036 or error 2007. The program uses Solver in excel to find best fit solutions for a matrix of i and j values by minimising error values (Val8a). the run time error message occurs at 1 of 2 …
I am using the VB editor in Microsoft Excel and have come upon a slight problem. Basically, I wrote a macro that allows me to copy an array of data from one worksheet, and then paste it into another worksheet. (So by using the macro, I can automatically update the …
When working in the calender view in Outlook 2003, I frequently put the cursor at the top of a day (in the ALL DAY area) and just start typing to create an all day event. These events have the default 15 minute reminder enabled and I don't want that... but …
When working with a spreadsheet in excel recently, I looked at the idea of inserting a macro. As far as I know I did not insert one but every time I view this spreadsheet now I have a question about disable macros flashed on screen before the spreadsheet opens. I …
I run Windows 2000 Pro SP4 on one of my machines. When working with a spreadsheet in excel recently, I looked at the idea of inserting a macro. As far as I know I did not insert one but every time I view this spreadsheet now I have a question …
Hello, I am not sure if this is in the right place, but hope that somoene can provide some advice. I am a District Technology Manager for a large retail company. I am in the process of trying to devolop an easier way to perform inventory on our computer equipment. …
When I us Outlook 2003 and start typing a NEW email, the TO bar allows me to fill in, the SUBJECT bar allows me to fill in, but when I get into the body to start my message, I type the cursor moves, but no visible type. The cursor seems …
Hi.I don't know where to post this ... please help. I'm trying to put each character in a string into an array. Private Sub cmdNameslow_Click() Dim username As String Dim index As Integer Dim myArray() ReDim myArray(Len(username)) 'prompt username username = InputBox("Enter your name", "NAME") 'display username one charachter at …
Hey all, I am generating some Word files using a html like format: the first line is this one: [CODE]<html xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns="http://www.w3.org/TR/REC-html40"> [/CODE] I noticed that the reference to an external file defined as the header was a problem for Word 2003 which pop a warning message when …
A user that I support somehow made it so that when using the up,down,left,right arrow keys it moves(scrolls) the entire excel worksheet rather then moving the selection area from cell to cell. Any idea on how to switch it back? "Important" note: When I remote into her machine, the screen …
I have to submit a resume as part of a college application, and I have to do so as a PDF file online. I work primarily with a Mac, but I my resume uses Cambria and Calibri, both part of Office 2007. If I export this document as a PDF …
My first post here; I've read the FAQs and some example posts, and hope I'm doing this correctly! As of two days ago, every time I open an MS Office application (Office 2002 Pro, a.k.a. "Office XP Pro") on my XP SP2 machine an install process is started and these …
Hi All! So the "project": In an Excel sheet I want to create a macro that jumps to a reference based on the value of a given cell. sg like this: Goto.Reference = "R" & [reference to the cell] & "C1" only the number of row changes, column number is …
Hi, I have two startup problems with my computer which happened recently after i did some cleaning out of my computer. I doubt they are related though, since they didn't happen at exactly the same time. Firstly, whenever I start Windows, I get a "Windows cannot find file \VCI_Task.exe" error. …
Is there any conversion software to make appleworks 6 readable in a pc or to just convert it to word. I would like free if possible. I have some docs on a mac with an os of 9.2 and want to get all the stuff to pc format. Anyone care …
I have office 2003 and want to know if I install office 2007 if it will keep all my settings. Especially email contacts in outlook. I still need to be able to save things in the older format for exchanging files with other people.
I have been trying to figure out how to open documents such as Word and Excel files with functional toolbars but I am stumped. Can anyone provide some insight on this?
Hi , It would be of great help if someone here could help me know about whether there is any technical content typing help for soem need like the image attached. It is to be done in a ms word document and i got to know daniweb only to post …
Hi, I have been trying to Copy a worksheet into another workbook and rename it using macro. But while running it Gives me an error: Run-time error '40036': Application-defined or object-defined error. Any help will be appreciated.
how to change the contents in text file to ppt file with bullets ... My code for wat i tried to shift the contents to ppt from java is: import java.io.*; import java.util.*; class Filereader { public static void main(String args[])throws Exception{ FileReader fr = new FileReader("E:\backup_javaprog\file.java"); BufferedReader br=new BufferedReader(fr); …
Hi Members, I am directly referring to you because you have firsthand idea of what I went through developing this little piece of vb apps. which produces an excel spreadsheet. However, the program is working perfectly okay, but when I make the spreadsheet visible or when I print the spreadsheet, …
I am using visual basic to open multiple spreadsheets and copy rows of data into one spreadsheet. I have done this by using workbooks.open and then specifying the filename, however, I would like to open all spreadsheets in the folder without having to add the names of each as these …
Hi, I have created an application in ASP.Net for exporting the datas from crystal reports viewer to excel sheet and what i did works perfect. but i want to know whether i can pass the parameter such as starting and ending page before exporting. if any one knows about this …
Hi, I am using Excel 07 and need to change the width of my columns for just a selection of cells. I want the rest of the column on my worksheet to stay the same - can anyone please help a chick out! Thanks so much Tari
Hi everyone, I'm new to daniweb (hope I'm posting in the right spot) Running XP, can't seem to delete emails (get a message that outlook.pst can't be accessed). Assuming that this is my deletion folder. Can anyone offer some advice? Thanks, Evan
Can I find an answer here about a Word Macro issue? I am trying to apply a macro to a Protected Form document. The user will click on a button to "Add a new Activity" table, which is saved in annother file to be inserted using the macro. But when …
i am new to visual basic and i have a task to design a programme using visual basic for excel to import the raw data and sort it accordingly. i also have to decode that raw data into meaningful data. I hope I can get some guide to finished my …
I'm looking at buying a new computer and it appears that Vista is about my only OS option (whether I like it or not, and I don't). I already know I'm going to have some problems installing my programming software. My question is - does anyone know if I can …
I know the way to retrieve data from an excel file by code Imports Microsoft.Office Imports System.Data.OleDb Imports System.Configuration Imports System.Collections Imports System.Web Imports System.Web.Security Imports System.Web.UI Imports System.Web.UI.WebControls Imports System.Web.UI.WebControls.WebParts Imports System.Web.UI.HtmlControls Partial Class _Default Inherits System.Web.UI.Page Dim conn As New OleDbConnection Dim comm As New OleDbCommand Dim DReader …
have a question that I have two rows from D77 TO D132 which is column D and I have column B with rows B77 till B132. I want to check that if a user fill anything in D77 or any row from D77 to D132 he needs to fill row …
hi, i have come accross a probelm and i was wondering Outlook 2003 could do this or would i need 3rd party mail program. Here is what i am trying to do. Ok this receptionist has her own calander wher she puts her appointment and stuff in. She then creates …
Hello all, I am populating a spreadsheet with data from access file. I am splitting each record into two lines so that it writes on two lines(some of the records writes on one row and the other half writes on the next row. I am doing this because some of …
I am importing data from access file to a spreadsheet. One of the input field is a "comment" field with a full paragraph of comments. Some of the target cells in the spreadsheet displays "##########". But when I click on the cell, the Menu bar on top of the spreadsheet …
I have a simple Excel Workbook with many worksheets within. I have a simple macro that will extract the selected sheet and allow me to save it individually. For some reason all date fields within the worksheet are changed when the worksheet is copied out. For example if the date …
I am experiencing a problem witha users outlook 2003 account and I need some help! Here is what happened: [COLOR=#000000][/COLOR] [COLOR=#000000] [/COLOR] [LIST] [*][COLOR=#000000]This a.m. I opened outlook. I was prompted to change my out of office setting and I said ok. While trying to get all of my 700 …
I have database in MS SQL Server 2000 and I want to connect to this database from empty database in MS Access because I want to build user interface to that database and also call procedure and functions in VBA. Can someone tell me how to do this or tell …
Good morning everybody. I need a quick direction here. A column ("Comments") in my spreadsheet that is is supposed to have text values is displaying: "#VALUE!" Note: my input data is coming from an access query. The underlined Below is the data in the "Comments" field in the query (recordset): …
Hello all, I am trying to populate a spreadsheet with data from access query. Even though the recordset(input file) has approximately 49 records, only 1 record is written on the spreadsheet. What am I doing wrong? Below is my code: [code] Set rsin = M.DB.OpenRecordset("qBiWeeklyPeriodCombined", dbOpenDynaset) If rsin.RecordCount < 0 …
Hi all, I need some input from you smart folks. I am populating an excel spreadsheet. Each time, I want to clear the spreadsheet content before repopulating it. I am using the codes below and it is clearing the first 3 rows in the spreadsheet and every other data stays …
How do I insert an Excel file into VB 6. I need to be able to view the file in a seperate form. I know the coding to change the forms is [code]Form1.Hide Form2.Show[/code] And I read a previous thread before on these forums that gave me the coding to …
Hi all, In my previous company there was a team of 5 people who all had access to the same mailbox. Each of these 5 people in the inbox of this mailbox where able to assign their intials by typing them in on the preview pane of the inbox. So …
I have found with Explorer (Version 6.0) open and I open Word (2000) often times Explorer will freeze with the Message Internet Explorer has encountered a problem and needs to close . . . If Word is first opened then opening Explorer can cause Word to stop responding with a …
Whenever I Try To Print From Outlook Express I Am Unable To Print And Get An Error Message - "an Error Has Occurred In A Script On This Page" This Applies To All Messages. All Fixes Tried Have Not Solved The Problem. Any New Suggestions - Much Appreciated
hi... how to read data from excel using vb6
[I]hey[/I] [I]i want to know what about spread sheet?[/I] [I]how can i use it ?[/I] [I]why it important?[/I] [I]i want any body please tell me [/I] [I]thank you.[/I]
The End.