I like to use ro = ActiveWorkbook.Worksheets(1).UsedRange.Rows.Count
to find the last used row on the worksheet. Then I can use the info to do other things. However, if you have used rows below the currently used area and later deleted the data, it will include that area as used too.
Barbara
I have pasted the relevant code snips used below. Quite a bit was found on outlookcode forum. I have to admit that I didn't know what I was doing, and it needed to be done fairly quickly. It did work reliably until the change in Word though. It turns out that the customer may accept our normal...
For anyone who might be looking for a solution, I found this in another forum and it worked for me.
Sub LoadOutlook()
Dim outlk as Object
Set outlk=createObject("outlook.application","localhost")
'parens are on same line as previous
End Sub
Barbara
I found nothing but one for Media Player labeled Not Public. I checked it anyway but it didn't help. Do you think it would help to reinstall Office making sure all components are checked? I need to ask the IT guy to do it if it is a possibility.
Barbara
I have a macro which ran fine under Word 2000. I was recently upgraded to Word 2003. The macro stops on set outlk=outlook.application. Outlk is dimmed as outlook.application. I referenced Outlook as I did originally. The IT guy applied the fix in Microsoft KB891401 but it didn't help. I have...
Could you make it seem invisible by changing the font to the background color, white for instance?
Set rng = ActiveSheet.Range("a3, b3")
rng.Font.Color = RGB(255, 255, 255)
Barbara
I've done it by copying selected contacts to a separate contact folder and exporting just that folder. Easiest if principal is assigned a category then the view is selected by category. Hold down shift key, click top contact then bottom contact so all are highlighted. Edit>> copy then open new...
Thanks Dom. The code doesn't do what I need but I'm going to save it just the same because Outlook code looks so difficult in comparison to Excel.
I need an embedded HTML table to get into WOrd as a table. I got some advice to paste the html string and save as .htm then open or insert it but...
Office 2000
I need to copy/get the message portion of a group of emails and paste/insert them into Word seqentially so that I can lose the headers and also control where a row breaks for printing. The message is embedded HTML which pastes as 4 tables per message into Word. The emails are...
Using Word 2000 MailMerge Wizard. Under Main Document>>Create choose Catalog. Then make a one row table, inserting your Excel fields in the Main Doucument. Then merge. It should create a row for each record.
Barbara
I tried this and it worked for me (Excel 2000). Maybe it will work for you.
Data>>Filter>>Advanced Filter>. Select your whole range. Then in the criteria box select only the data range. Click OK and its done.
Barbara
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.