Search results for query: *

Thanks. It worked! I guess the %20 gets treated as a space?

I appreciate the suggestion but there isn't a macro recorder in MSOutlook.

I am using the VB editor within Microsoft Outlook to make an attachment stripper. I am trying to insert hyperlink to the location of where the file was saved to within the body of the email. I am having problems with file names containing spaces. Does anyone know how to do this? I tried to use...

Thanks, I tried it and it worked. I had a problem however. The link ended if I had a space in the file name. I have figured out that the name needs to be in quotation marks. This is probably a no-brainer but how do you append a quote in visual basic code. If I use the code below the...

I have the following code that I can run in MS Outlook to remove a file from an email message and save it to a hard drive location. Then text is added to the email with the address of where the file was stored. What i would really like to do is to have a hyperlink to the file added to the...

Normally when I am using outlook and viewing my email, if I need to do something with it I drag the email over the task icon and up pops a task item with the same subject line as the subject line of the email and the body of the email in the body of the task item (try it, its cools). Thats...

I would say I am not a beginner but also not an expert. I try to dimension things properly and use dynamic arrays when appropriate. Just when I think I have things figured out I get a "Subscrit out of range" error and the reason is not very clear. For example, I get an error from...

Thanks Loomah, it worked like a charm. I tis puzzling why it works though.

Hello, I have written a VB subroutine that is supposed to clear all data from an excel worksheet except the first row which hold some titles. The code is as follows Sub clear_data(sheet_name As String) Worksheets(sheet_name).Range(Cells(2, 1), Cells(65536, 256)).ClearContents End Sub An...

I appreciate the suggestion but that didn't work either. I also tried atmospheric_data().altitude=Range("A1:A10") and it didn't work either. Still the same error.

Thanks xlbo. I modified my code as you suggested. Unfortunately I still get the compile error "invalid qualifyer". Does anyone know if what I am trying to do is possible? Refined code is pasted below. Type Atmospheric_Type altitude() As Variant density_ratio() As Variant...

Hello, I am trying to create a type definition and then set an array equil to a range of values in an excel sheet using this type. When I try to run the code I get a compile error "invalid qualifyer". Am I trying to do something that can't be done or is my syntax wrong? Any help...

It has been my experience that interfacing with excel one cell at a time in a VB loop can be slow even with tricks. However, when I set a ranges in excel equil to arrays in VB, perform the manipulations in VB and pass the entire array back to excel, the procedure becomes nearly instantaneous...

Why are row variables dimensioned as long?

I would like to add some code prompt the user (in a window similar to an inputbox) to select either "round", "circle", or "square". When the user presses "OK", the choice is assigned to the variable profile_type. Currently I have following code attached...

Hey, this is Navy Guy again. This is fantastic stuff. I have two more questions. The values for offset - what units are they. If I want the object to be 3 inches from the top and 4 inches from the left, how does that translate to the offset values. The other question stems from me trying...

This is awsome. I tried it on a complex shape with 300 points and it worked great. Much Thanks.

Hello again. I was wondering if anybody knew how to generate msoffice shape based on x,y positions stored in visual basic or in an excel sheet. For example, an "L" shaped geometry may have x,y points of x y 1 1 1 4 2 4 2 2 4 2 4...

I have an equation to be calculated in vb that requires me to calculate the acos of a value. There doesn't seem to appear to be an acos function in vb. I heard you can do some trick with atan. Does anyone know that trick or have any suggestions? Thanks

I have some userforms made in the VB editor that comes with excel. Is there a way to get a chart (like you would normally see in excel) to appear on a userform? Thanks