Ignore Remote Requests
Dec 24, 2008
I've just discovered that if you include the line: Application.IgnoreRemoteRequests = False. in a Workbook_BeforeClose event, and then close the workbook using ActiveWorkbook.Close
the
Application.IgnoreRemoteRequests = False
line is itself ignored! Code attached - the only workaround I can come up with is also included (to re-enable IgnoreRemoteRequests BEFORE the workbook is closed programmatically) - can anyone confirm this, or break it, or come up with a better explanation or workaround?
View 7 Replies
ADVERTISEMENT
Jan 11, 2014
I have a Work Log that i would like to be able to analyse, in particular the number of requests submitted per month, The data in the work log looks this this: -
ClientPosition Para-plannerAdvice RequiredDate Required ByMy CommentsReceived by Paraplanning
BurgessCompletedPetePP transfer to GPP 21-Jan-13
Its the received by paraplanning heading date, i want Excel to be able to tell me how many reqeusts were recieved in Jan, Feb, Mar etc. I've tried =countif but that does not do what i need it to, just get an error.
View 4 Replies
View Related
Feb 7, 2007
The problem I have is I need to generate individual requests from a summary (which I can do as long as the max values do not fluctuate)
e.g.
Number required each week
Tool wk1 wk2 wk3 wk4
flogger 1 4 2 5
wrench 2 3 1 5
socket 6 10 2 8
so for the flogger I would need to write 8 tool requests in total: 1 for wk's 1-4, 2 for wk's 2-4, 2 for wk2 only, and 3 for week 4 only.
There must be a quick way of doing this using VBA.
View 2 Replies
View Related
Apr 28, 2009
I have a list of about 2,500 entries containing information of all my works leave requests for 2009. This list contains more than one entry per employee, as it shows all their individual requests for different weeks. The list is compiled pulling through data from other worksheets. It looks like this...
Sheet Name: MASTER
Column A = Line Managers Surname
Column B = Employees Surname
Column C = Employees First Name
Column D = Employees ID Number
Column E = Week ending
Column F to L = Days of the week
Column M to O = Request Type
Column P = Number of days requested for the week
I then have another sheet (Called REQUESTS) with all the employee names (1 entry for each employee), ID numbers and total requests for the year. This looks like this...
Column A = Line Managers Surname
Column B = Employees Surname
Column C = Employees First Name
Column D = Employees ID Number
Column P = Number of days requested for the year
Column Q = Number of days requested for the summer
I know how to locate and add up all the requests for each individual for the whole year (Column P) from the MASTER sheet to the REQUESTS sheet by using the flowing formula for each employee.
=SUMIF(MASTER!$D:$D,D2,MASTER!$P:$P)
But I don't know how to ask Excel to find and add up all the total requests for only the summer period (Column Q). What I want Excel to do is this................
View 2 Replies
View Related
Mar 16, 2009
I am hoping someone with excel experience can be of help to me with an unusual request for excel.
Assume cell A1 = 2, B1 = 3 and i wish the sum of this (5) to appear in cell C1. Very straight forward so far, however i wish the result to appear in C1 when i left click on a cell other than C1, say for example D7.
I can't use any macros for this.
View 11 Replies
View Related
Jun 26, 2007
I have in column D starting D9, I have numbers starting at 1, and may finish at 100. But there could be duplicates, 1,2,3,3,4,5,6,6,7,7,8,9,10,10,11,12,13,.........
I would like to only copy the range D9 to H (End of column D), ignoring all the duplicate numbers, to another sheet.
So on the second sheet, it would be 1,2,3,4,5,6...... with the data copied from E,F,G and H.
View 9 Replies
View Related
Jun 21, 2008
I remoted most of my number crunching stuff to a dll.
It work fine except for a few strange things that I observed like from time to time a strange message "Error in loading DLL" even though everything works fine. This message appears only when entering the main formula in the formula, and is no problem at all in usual work.
When I investigated, I noticed in the "windows task manager" that one instance of excel remains open even after I have closed excel. This phantom excel process is maybe related to the other problem I explained above.
Instead of calling a VBA function, it creates a VB6 object from this dll and uses the methods of this object. In this way I have remoted the number crunching functionality.
The main parameter passe in this process is a reference to the original workbook. I need it because the number crunching functions need to read data from the workbook.
I made it sure to terminate the life of the object properly on both sides by ad hoc obj=Nothing statements.
Still I think that the "garbage collection" or the "terminating" is the cause of the problem.
View 9 Replies
View Related
Jul 21, 2014
I am looking for VBA code to remove extra commas from d column.
Missing
, , , 1617614,
, , , 1676652,
, , , , 1676664, 1676665, 1676666, , 1676668, , 1676670
, , 1591813,,,,
, , , 1591113,
View 9 Replies
View Related
Dec 2, 2009
i have an excel file with some vba code that includes some functions of a third party add-in also. It works fine when i open this file on the host machine. (Assuming host machine is where the Excel File is placed) But when i try to open the same file from some other computer(remotely/by sharing folder), the add-in malfunctions because of one reason that it considers the remote machine to be its host. Is it possible to set a permanent host machine for that any add-in. Or is it possible for that add-in / Excel file to do its calculations and updation of links on the host machine where it is placed.
View 4 Replies
View Related
Jun 5, 2007
I send out multiple versions of the same sheet every month. I want to be able to have a script run every time the spreadsheet is opened to send an electronic log directly to a text file on my machine (or something similar)
Is this possible or some sort of a pipe dream?
It would be used for me to monitor usage of the sheet, and i'd require only the same of the spreadsheet (which is always unique), the date/time and possibly the computer name / username? (not really needed)
View 9 Replies
View Related
Nov 27, 2009
I have an excel workbook that lists the number of mailboxes on several exchange servers. Because this info is put in manually by several people throughout the day there is a chance for mistakes. I can use remote desktop to get into these servers and check all these but when you have over a hundred (Enterprise Level) of these different mailbox stores to check, it takes a while and just isn't fun. I have a friend who made a vbscript file that can check them all but I don't have that code but now I know that it is possible...well with vbscript anyhow.
is it possible for excel to access a remote computer? and how would this be done? If needed to we can be already remoted into it I just need help with the Syntax of how to then access it via some VBA.
View 4 Replies
View Related
Feb 11, 2009
I have CDO set up on in an excel workbook contained on our network. We have been using the following code for well over a year. It works flawlessly on 12 of our 13 computers. I can send mail through Excel using the following code on my computer. But not on a particular computer. The user at that particular computer can't send mail through the CDO code from her computer but can from other computers.
This problem is definitely isolated to a computer. I had tech support un-install office, use a cleaning tool, then re-install office. The problem persists. Is there a particular setting on this computer that needs to be set that I am unaware of?
Here is the code...
View 3 Replies
View Related
Jan 9, 2012
My code should get the value of a hidden element from a form that is on a remote website. Then it should display that element's value on my excel worksheet.
One or the other of the 2 lines between the commented out lines should work. Instead the code runs until within a minute after the page has finished loading, and then stops completely without getting the hidden element's value.
Code:
Sub work_damit()
Dim ieApp As Object
Dim URL As String
URL = "http://www.craft-e-corner.com/p-2688-new-testament-cricut-cartridge.aspx"
Set ieApp = CreateObject("InternetExplorer.Application")
ieApp.Navigate URL
[code].....
View 9 Replies
View Related
Sep 17, 2012
I need to find a way to collect current CPU usage of a specific application on a remote server or the top applications that are using the most of the processor's time on a remote server?
View 7 Replies
View Related
Feb 14, 2005
I've been trying to send emails through an SMTP server in various ways. I've been able to send email using CDO going directly through an SMTP server on my same local network (not requiring a username and password). But now I am trying to send email from my home with the SMTP server I am using that is hosted by some commercial company. I used the code below, which is sponsored by Paul Sadowski:
Sub sendMailRemote()
'Sending a text email using authentication against a remote SMTP server
Const cdoSendUsingPickup = 1 'Send message using the local SMTP service pickup directory.
Const cdoSendUsingPort = 2 'Send the message using the network (SMTP over the network).
Const cdoAnonymous = 0 'Do not authenticate
Const cdoBasic = 1 'basic (clear-text) authentication
Const cdoNTLM = 2 'NTLM.......................
View 9 Replies
View Related
Feb 27, 2008
Is it possible to update values within a second workbook without opening that workbook?
Also, is it possible to use INDIRECT to reference another workbook?
View 9 Replies
View Related
Jul 4, 2007
I worked with an Ozgrid macro until it was what I wanted using files on my local PC. I then edited the macro to get data from a closed workbook on a remote server. I now have a Run-time error '1004'
Method ' Range' of object'_Worksheet' failed and the debugger takes me to this line of code.
With Sheet1.Range(AreaAddress)
The only thing I have changed up to this point in the macro, is the address of the file on the remote server.
I am at a loss with this now. Am I trying to do the impossible? ....
View 9 Replies
View Related
Nov 2, 2013
I have created a macro that creates a powerpoint from excel in office 2010. I have followed all the required steps, like adding object library and all. but still many times the PowerPoint crashes at slide7, 8 or 9 and have to restart. I generally get the above given error.
Code:
Sub CreatePowerPoint()
Application.ScreenUpdating = False
'Macro Created by Pallavi NC (pallavi.nc@hp.com)
'Add a reference to the Microsoft PowerPoint Library by:
'1. Go to Tools in the VBA menu
'2. Click on Reference
'3. Scroll down to Microsoft PowerPoint X.0 Object Library, check the box, and press Okay
'First we declare the variables we will be using
[code].....
View 1 Replies
View Related
Dec 7, 2009
I am trying to figure the sum of cells B12:B28. However some of the cells in the range have a #N/A error due to a VLOOKUP function that is pulling data from a different sheet. Currently the data it is pulling is a blank cell, but will at some point have a value in it. How can I make the SUM function ignore the #N/A?
View 5 Replies
View Related
Apr 22, 2009
I have a column of numbers that are calculated by a formula that doesn't always come up with an answer and returns the value #NUM!. See the attached XLS. The answer to the sum function is always #NUM! if a #NUM! is included in column of values put into the SUM function. I currently work around this issue by redoing the column with the SUM statement to avoid the #NUM!'s. Is there a logical test that can be applied to solve this issue? an I add another column that reset the #NUM! to ZERO and then SUM that column?
View 4 Replies
View Related
Feb 3, 2014
I want formula to leave cell empty if there is 0 somewhere but to real value if there is something else.
So far I figured how to do the first part.
=IF(A1;"0";"")
View 1 Replies
View Related
Apr 6, 2009
I have Dynamic named ranges (SUMPV)
SUMPV is range I31:I300
I use the following formula to sum up.
=SUM(SUMPV)
The problem is that sume cells night produce #value thus giving an error in the Sum formula.
I tried the =SUMIF(SUMPV,"#N/A") but not working..
View 9 Replies
View Related
Mar 22, 2009
I am using a lookup function to return nalues to a column. Some of the values returned are ### and I cannot SUM this column. I either need to adjust the lookup formula to not return ### or adjust the SUM function to ignore ###.
View 5 Replies
View Related
Apr 27, 2009
I need the folwing formula to ignore any 0 in column Q, and rank only values of 1 or greater.
=RANK(Q6,$Q$6:$Q$20,1)
View 3 Replies
View Related
Nov 13, 2013
I have specific cells A5, C5, D5, F5, H5 that I require and average value for but need to ignore those cells that have a zero value in the averaging.
View 5 Replies
View Related
May 5, 2014
I have a huge data set that simplified looks like the one below.
I would like to write a vlookup formula that ignores vlookup-value="need manual input", "", and "N/A", and instead continue to find the next lookup value that is not equal to "". if no match at all or only match to "" or "need manual input" I want the output to be "need manual input"
So, in worksheet 1 cell B1 i want to generate value 73530C10 (lookup-table cannot be sorted)
Worksheet 1
A
1
Bob
2
John
[Code] ..........
View 5 Replies
View Related
Feb 12, 2008
Is there anyway I can change a sumproduct so that ig ignores any errors?
The formula I am using is:
=SUMPRODUCT(--(data!$L$2:$L$7441='Level 2'!$D3),--(data!$P$2:$P$7441='Level 2'!H$1))
View 9 Replies
View Related
Aug 4, 2006
How can I get this formula to ignore a zero value and continue looking to the left until it finds a whole number?
= LOOKUP(9.99999999999999E+307,N77:X77)
View 3 Replies
View Related
Jan 23, 2008
I have a small problem. Basically what I need to do is this: I'm setting the initial value of my combobox to say "Select a Payer". The combobox has a list of insurance payers. When one is selected by the user they click a button and on another sheet is displayed thier selection in a Pivot Table. Unfortunately, when the user selects nothing (the combobox stays at "Select a Payer") problems occurr.
What I want is to use if combobox1.value = "Select a Payer" then combobox1.value = {the first actual Payer in the list}. Index number 1 ?
View 4 Replies
View Related
Jul 23, 2014
I have a sheet (example attached) I need a formula to recognise only the numeric values either by automatically deleting the words or by entering the numbers in another corresponding sheet, either would do.
View 5 Replies
View Related
