Search results for query: *

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...

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...

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...

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...

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...

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

Hello, I have created a userform with the vb editor that comes with excel. I added an option button. I also created a frame with varius things in it. I would like to add code to the option button so that the frame is only visible when the option button is selected. How do I do that? Thanks

Hi, I have recently heard about vb flexgrids. Before I delve into learning more I was wondering if anyone knew if flex grids would work if run from a vb macro in excel on a computer that only has the latest version of microsoft office installed (no extra dll's and stuff required.)?

Hi, I just discovered that I can create custom UserForms with the visual basic editor for excel. This is new to me. Does anyone know of some good web pages with examples of custom UserForms (dialoge boxes) created in the visual basic editor that comes with excel? Thanks

Hi, I just discovered that I can create custom UserForms with the visual basic editor for excel. This is new to me. It ought to be simple but I cant seem to figure it out. I want to be able to have an "Ok" button on the form so that it closes after items are selected in the form.

Hello folks, I have a visual basic macro running in excel. It performs all of the calculations in about 2 seconds but takes 20 seconds to send the data to excel to update an xy plot. I pass the info with a loop like this.. for i = 1 to 1000...

Hi, I have a vb program running in an excel macro. The macro outputs a number of series to an excel spreadsheet which is then viewed in an xy plot. The trouble I am having is that the number of series I want to plot changes depending on the user input to the macro. The length of each series...

Hello, I am writing a visual basic macro for excel. I would like the maro to run whenever the user changes the value in a particular cell of the excel spreadsheet. Any ideas.... Thanks