Search results for query: *

Hi, I am designing a document template which has 5 paragraphs, and there is a name which appears in every paragraph, but I don't want to type in the same name 5 times repeatly. So, is there a way (like the the formula functions from Excel) to link all these 5 sections together? For example...

Hi, I try to send an attachment (different files everyday) to the same recipents everyday after a certain time of the day (day after 5pm). I am sure it's doable by writng some VBA codes (I've never written anything for Outlook, but have some experiences from Excel), and I've tried to record...

Hi, I have two time series for two data sets. For example, I have historical prices of gold and IBM. Sometimes you have extra trading dates for gold, or IBM, and I want to delete extra prices, so the two will be aligned with the same amount of data points (final format will be dates in column...

Hi, I have data in three columns, and want to delete the entire row if the cell on column three is empty, and shift everything up. My aproach is to select all the data in column three, and count the number of rows, then create a "for" loop to delete the rows. Please help! Thank you!!

Hi, I was told that I can change the source data by dragging the series points from the chart's plotting area. I've tried, but it didn't work. What do I have to do? Thanks!

Hi, my workbook has about 30 sheets, and each sheet has lots of formula and links. I'd like to save the workbook for the other people to see the info only. Is there a way that I can just save as in values? I don't want to protect or hide any of the cells. Thanks!

Hi, is it possible to tell VBA to download data from a Site which requires user name and password? Thanks!

Hi, I was performing the find and replace function. I hiligted a column and performed find "K" to replace with "L" and hit the "Replace All" button. At this moment, I'm not sure if that was what I did...because there is this poped up "File Not Found" window on my screen, and I can't cancel the...

Hi, I couldn't figure this simple Excel to Word problem, please help! In Excel, when you go to print titles in Page Setup, you're allowed to select the rows to be repeated, so the rows that are selected can be printed out on each page. But, I want to copy my Excel list onto Word, and need to...

Hi, I've downloaded some data from the Web, and it has a column for time, but it's in TEXT format, so the time reads like this : 102530 (the hour is 10, minute is 25, second is 30). When I tried to change the cell format to "Time" , everything goes to " 00:00:00 ". I've...

Hi, I want to past/link my simple data as follow: Data Source: A1,B1,C1 And I just want to copy and paste my data from data source cells to the cells as follow: A2,D2,G2 (want to have two blank cells between each number). So, is there any way that I can just do this from Excel with VBA? If...

Hi, it seems my Outlook Inbox is set to allow only to have the last five (5) days of mails, anything before that are automatically deleted. Please let me know where can I change this setting. Thank you very much!!!

Hi, how do you create the short cut icon for the Desktop on the bottom of your screen? Thanks!!!

Hi! Does anyone know where can I find some FREE Excel VBA souce code? THANKS!!!

Hello! If I have the following situation: File1.xls : Sheets("1") has "Array1" Sheets("2") has "Array2" File2.xls : Sheet("1") has "Array1" Sheet("2") has "Array2" All the Arrays have the same size (5x5). I...

Hi! How do you comment out a block (ex. 20 lines) of codes at once, so the the codes will be ignored when you debug. Thanks!

Hi! I just installed Win2K (used Win98 before) recently, and I deleted the old Outlook Express mail by mistake after my Win2K installation. I've used the free software from http://www.pcinspector.de/file_recovery/UK/welcome.htm , it works very well except that I couldn't get my deleted Outlook...

Hi! I've set up my yahoo account from Outlook Express...I have no problem getting mails to my inbox...but I can't send out any mails though...I have set my Outgoing Mail(SMTP): "smtp.mail.yahoo.com" as explained from yahoo.com. And I have Outgoing mail (SMTP): 25 for Server Port...

Hi! I'd like to backup all my Outlook Express mails from Computer A and open them from Computer B. Please provide the details. THANK YOU VERY MUCH!!!

Hi! I want to the install Win2K to my laptop (it has Win98 now), but my laptop doesn't have a CD ROM. So, if I want to install Win2K via my home lan network (using other PC's CD ROM), is it possible? What are the procedures? THANK YOU SO MUCH!!!