Search:

The range only contains the one cell.
The problem is the variable will contain the formula as opposed to the value being displayed.

I'm trying the grab the value of a cell into a variable. Currently I'm just using the code:
var1 = Sheets("worksheet1").Range("myRange").Value

however causes problems if the cell contains a...

Hi there,
I am using ADO within an xml/asp based web application to grab values out of an Excel workbook. The connection string is fine, but I am having problems with the data types:
If my query...

All the data contained within the Excel form is in cells, not controls.

I am running an XML/ASP based web application and I'd like to give users the ability to import a completed Excel form and have a web form within the application grab values out of the xls file. The...

Is there a way to edit the junk mail filter on my exchange server? (or at least view the key words, phrases it searches for)
We use a piece of software (on our intranet) that sends out automatic...

Just did - works now. Thanks!

I'm sure this has come up before but I cant find the post:
I have a presentation made in ppt 2000. When viewing the presentation in ppt 2003, all slides with text on them are empty. All slides that...

New Window allows you to see more than one sheet of a workbook including the ability to see different view of a same sheet. This is strictly viewing what you see on one sheet is the same as viewing...

The combo boxes are named "Drop Down 49", "Drop Down 52"... so I'm not sure how they were created.

Good point. The text boxes must have been made using the drawing toolbar.

Also, once I've grabbed the files, how do I change the activesheet back to the summary sheet?

The controls are all made from the control toolbox. They're named "text box 18" or "drop down 52"

I am creating a form that will pull certain values from a template spreadsheet and place them in summary sheet. However, I am having problems getting the values into variables so that I can enter...

Isn't there a property of a combobox such that it won't let you enter information manually?

Another problem:
For some reason, after I run listbox_afterupdate(), it saves the listindex as the selection, but moves the highlight and display up to listindex 0... any ideas on how to circumvent...

Thanks! I dont know why, but it worked!

Hello,
I am having some problems changing the backcolor of a listbox. I have a form with a bunch of controls (textboxes, combo boxes, listboxes, etc) that an end user will fill out. I made it so...

Does the ActiveWorkbook.SendMail function require an Exchange Server? Or Outlook?

I'm getting an interesting error whenever I attempt to save a task. I attached a screen shot.
Anyone have any ideas on this one?

Which value woud l return to place this path in a textbox?

Awesome!! Thanks for all the help guys!

I get a subscript out of range error.

I get an error saying the Target workbook is already open.

If I am copying values from wbkTest to the workbook which contains this macro, am I going to need to constantly change the active workbook, or can I just refer to the workbooks by storing them in...