Programming

Run-time error 1004: Method 'UpdateLink'
When running this code in excel I am getting the following error: Run-time error '1004': Method 'UpdateLink' of object '_Workbook' failed What's wrong? Here is the code I'm using: Sub UpdateSelectedLinks() Dim aLinks Dim cLink As String Dim i As Integer Application.ScreenUpdating = False aLinks = ActiveW... 17 Jul 2008 11:40

Inputting UserForm data into specific cells
Hi Guys - hoping you can help again. By far the most useful and helpful group I have been on so thanks for your help so far! I have put together a UserForm to help with data input to a large worksheet. The worksheet contains information on various fitness assessments. Each assessment is grouped in columns (overly... 17 Jul 2008 12:42

Page number reference in a cell
Is there a way to reference the page number of a page in the middle of a document and input it into a cell. The problem is that as information is added or deleted the page will move so I am trying to write something to reference what that page number will be when it is printed. Thanks! ... 17 Jul 2008 12:42

On Open using Public Var from VBS?
I create multiple reports through out the day and the source for some of these reports comes to me through SharePoint. To that end, I have a VBS script I call from Outlook when an email notification comes in telling me that my source is available. This script streams the source from the SharePoint URL to a pred... 17 Jul 2008 11:40

Connecting to accdb with Excel 2003
Hi, I have a database that was developed using access 2007 and is split into front ends and one backend. One of the things that I am doing with the data in the backend is making a pivot table in Excel 200x. I have done this without any problems in Excel 2007 but I am having trouble doing it in Excel 2003. Ca... 18 Jul 2008 12:22

How do I stop formulas from calculating when I open a workshee
I don't want to go through the menu option since I don't want my users to have to do that. If I used Application.Calculation = xlCalculationManual and put it in the Workbook_Open event, this fires if I just open Excel and causes an error: Method 'Calculation' of object '_Application' failed. If I open the XL... 17 Jul 2008 14:46

Copying text from text box
Is there any way to copy out the text from a text box to a cell, even when the text length is greater than 255 characters? Currently, my copy is getting truncated to the first 255 characters. thanks in advance Daniel ... 17 Jul 2008 12:42

Get data from excel report into row of csv file
I have a report form in excel, it has several sheets with hundreds of questions. I need to be able to get the responses to the questions out of the report and into a csv file (one sheet on one row and other sheets on the next rows, etc). What is the easiest way to go about doing this? Thanks in advance. ... 17 Jul 2008 10:38

Update workbook without opening it?
I am trying to find a way to copy a range to a closed workbook. Right now, the workbook is opened and the update is subsequently made. My code to update the workbook is below: Private Sub CommandButton1_Click() Cells(12, 9) = TextBox1.Text Cells(12, 10) = TextBox2.Text Cells(12, 11) = TextBox3.Text Cells... 17 Jul 2008 09:36

Auto-refreshing VBA modules/functions/macroes
Hello everyone, I am having a problem which I cannot seem to figure out. Even though it seems -- and probably is -- a easy solution to. Here it is. I have a several columns of 300+ rows which use a function (or is it called a macro, or module?) that I created myself in VBA. They call this function with valu... 17 Jul 2008 10:38