Search results

I have a spreadsheet posted on SharePoint and its formulas keep changing. I am doing lookups against a SQL query against a fixed data point. the first row is correct but further down the number goes off. I have fixed saved a republished a dozen times. any suggestions?

I am getting a debug at the End If right after ActiveWorkbook.Save. I don't have to do any thing but hit F5 and it finishes. Any suggestions? I need to get this to end users in the next few minutes. Using Excel 2013 on Win 8 this is the complete piece of code Private Sub...

The code below works but only the first one. If I change the order and step through it will give me the user name. I have been searching the web but I'm not using the right search criteria. Help would be greatly appreciated. Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target...

I am trying to use the following code to update seven Excel workbooks. At this point (second file to refresh) I get Runtime error 1004 SaveAs method of workbook class failed. xlWb.SaveAs ("P:\FileLocation\Speciality All Regions Forecast Template.xlsx") I continue the code with F5 and the next...

I have a bit of code to relink tables to a new location. My earlier tests were doing well but once I added a button with a run command I started getting Run-time error 7952 "You made an illegal function call". This occurs at Exit Function. I tried commenting that out and letting it run to End...

I am exporting an Access query to Excel and formating the workbook but having a problem with Excel opening twice. The formating is working fine. Any suggestions on where I am opening Excel twice would be greatly appreciated. Private Sub btnVACR_Click() Dim uName As String uName =...

Each month I get a list of hotels people have used and need to normalize them by chain to run additional calculations. I have attached a sample. I had high hopes that a nested search function would work but "=IF(SEARCH($G$2,A2)>0,$H$2,IF(SEARCH($G$3,A2)>0,$H$3,IF(SEARCH($G$4,A2)>0,$H$4,"not...

I created a form for my company's travel expense reporting and have password protected it. There is a small group of users who are having a problem using the form and our helpdesk informed them that the problem was due to having the Hyperion Smart View Add-In installed, see comment below...

I'm using an ODBC (read only) connection in an Access 2007 db (2003 format) to a SQL server 2000. I left a 2 table query open for about an hour while I went to a meeting. While gone apparently the application that runs on this server went down and the DBA had to kill my query because it was...

I am working with pivot tables in Excel 2007 and my field list does not appear on screen. If I click the icon to show/hide field list it toggles but the only thing that changes on screen is the words within the pivot frame such as "drop data here" disappear. I have two machines and this is only...

I have a file that I have password protected, selecting "allow all users to sort" but once protected an error is displayed when using Data Sort or A/Z sort button. Is there a way to allow users to a sort a protected worksheet? Created in Excel 2003 but will be sent to various companies so end...

I've just started using 2003 and had a query give me incomplete results. One table contains 6 numbers stored as text joined to the corresponding code in the data set table. Both fields are formatted as text. When using the table as criteria I do not get all of the expected records, I had to...

I'm sending out an Excel workbook to get information and want to force respondents to answer the legal questions before they see the rest of the information. I will send it out with all other tabs hidden but as soon as they answer Yes or No to 17 legal questions I want the tabs visible. Each...

I have a spreadsheet with quite a few cells that have validation. This was put in via the data validation dialogue box rather than refering to a range. Is there any way to print out all of the choices?

Is there a way to write a function to replace Asterisk "*" without wiping out all characters? I tried using Chr(42) and it still cleared out everything in my selection. Thanks, any help will be appreciated.

I need to know how to create a custom date format so the date is DD MMM YYYY with the MMM being all caps. I can do the basic DD MMM YYYY but the three letter month is in proper case. How do I force Excel to show my month abbreviation in all caps? Help would be appreciated, this is for a...

A number of people in my office have had their Automatic calculation in Excel turn itself off. We are aware of how to fix the problem but I would be interested in knowing what causes it. If anyone has insight I would appreciate being able to explain the phenomenon.

I am developing an Access (2000) database to provide reporting data gathered from SAP and make it easily accessable for 12 analysts. The data set is HUGE, 5 months nearly a gig and will need at least 2 years worth, so I don't see any option other than using SQL as a back end. I have experiance...

I am developing an Access (2000) database to provide reporting data gathered from SAP and make it easily accessable for 12 analysts. The data set is HUGE, 5 months nearly a gig and will need at least 2 years worth, so I don't see any option other than using SQL as a back end. I have experiance...

I have a text file that has double carriage returns and need to clean these out before importing the file into Access 2002. These returns happen in the middle of a field not at the end of a line. Is there a way through VBA to write a routine that will look at the .txt file and remove all...