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

there is no other code and both statements work, depending on which one is listed first.

Thank you, I tried this method but it does the same thing, populates the first then jumps right back to the top. Pbaldy, that was how I wrote it originally but it jumps back up. I'm just sort of at a loss. Tried this at work using 2013 and at home with 2016

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

Finally found something to work, see if statements in red Dim xlApp As Object Dim xlWb As Object Set xlApp = CreateObject("Excel.Application") xlApp.DisplayAlerts = False Set xlWb = xlApp.Workbooks.Add("P:\Business Analyst Shared Folder\Business Analysis Tools\Forecast & EG\Flash...

Any additional thoughts would be appreciated. I've added DoEvents and more saves and split it into separate buttons. The RefreshAll is still not consistently running. Set xlApp = CreateObject("Excel.Application") xlApp.DisplayAlerts = False Set xlWb = xlApp.Workbooks.Add("P:\Business Analyst...

I tried removing it but I ended up with dialogue boxes for save. I did try setting the App to Visible but the RefreshAll Command is still not working 100% of the time.

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

worked like a charm in 2010 as well

Perfect and simple, thank you very much

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

I am doing exactly that and having a problem with Excel opening twice but the formating is working fine. Any suggestions on where I am opening Excel twice would be greatly appreciated. To get the formatting record a macro of what you want in Excel and use that code within Access. Private Sub...

Thank you, giant help to us!

not clear on what 9.99999E+307 was supposed to be.

In 2010 all you have to do is copy and right click. one of the things you see when you right click is a series of clipboard icons. The one with 123 on it is paste values. Right under the icons are the words paste special, clicking there brings up even more clipboard icons including all the...

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

This is really a workbook with linked cells to do travel expenses in, I should not have called it a form. The only code in the multi sheet workbook is a simple macro that clears existing data if the user chooses or leaves it alone so they can continue filling out their expense report. I would...

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