-
- Excel status loader/counter?
by Scott Boyd
- 2 Replies
- Last post
by Scott Boyd
- Hey,
Not quite sure how to word this but what i'm looking for is like some sort of preloader or egg timer style graphic or percentage counter to display when my function is running to indicate to users the current progress. The function i'm running takes up to 3 mins to calculate so wanted to be able to show users that the program hasn't froze etc.
[EDIT] Sorry just to update, i n
-
- Runtime Error 1004
by akn112
- 5 Replies
- Last post
by akn112
- I think i've asked on almost every VBA forum
Here's the error code im getting: Method 'Range' of object '_Global' Failed
It comes every second time i run the code. Originally i thought it had something to do with the variables. But i have set my code to set my variables to nothing at the top and bottom of my code. I also close the application and close the workbook.
This code should 1) op
-
- Track InternetExplorer Object firing new windows
by Ragnar Moller
- 3 Replies
- Last post
by Ragnar Moller
- After stubbornly searching I found how to use an InternetExplorer object to start up IE and to fill in a form which was displayed in the browser. I sort of figured I have to use newwindow or newwindow2or newwindow3 event but I've got a few holes to fill in. I'm programming in vba for Outlook under windows NT and I'm trying to figure out - how do I program the event oe make outlook to take it into
-
- Communicator web access Not working on sign in... TLS required ? (Internally and externally)?
by markm75c
- 0 Replies
- Last post
by markm75c
- I can connect to the sign in page just fine.. but once I enter all the information it gives me an error.. reason=2.. could not sign in to the server etc...
I know the standalone software can connect and works fine via TCP protocol..
Can I not use TCP protocol from behind the firewall and from the outside.. or can i use TCP inside.. the TLS certificate method on the outside..
Thanks
-
- Updating links in Powerpoint with VBA
by dh273
- 2 Replies
- Last post
by dh273
- I'm having problems with Powerpoint VBA. I have pasted blocks of cells from Excel into Powerpoint using Paste Special -> Paste Links-> Microsoft Excel Worksheet Object, and set the updating to manual. I'm trying to get some VBA code that will update all the links in my presentation. Essentually, the code that would do the same as me going to Edit-> Links, selecting all the links and click
-
- Open a new blank form from an existing populated form
by RhysDavies
- 1 Replies
- Last post
by RhysDavies
- i know this sounds like a really easy thing to do but for some reason i cant do it - in a new system i am building i have a form where users enter their daily activities and they will need to be able to enter several days at a time. once they have filled in a days activity on the form i want them to be able to click on the 'new' command button and this will save the existing activity record to the
-
- Using a date filter for opening a report in Access VBA
by BerkErgun
- 2 Replies
- Last post
by BerkErgun
- I would like to open a report in Access VBA , using a date filter and at Turkish operating system that I¡¯m using, the date format is DAY/MONTH/YEAR.
Unfortunately, I¡¯m experiencing a big problem regarding date format. At present, below I tried to explain the problem I¡¯m facing:
For example; if I write 30/06/07, program defines it correctly as 30 th of JUNE because there isn¡¯t a 30
-
- Referencing objects from different reports
by Quarry
- 2 Replies
- Last post
by RobinChadwick
- Hi, I have 2 Access Forms, Frm1 & Frm2. In Frm1 I have a cmd button which when clicked should open Frm2 and refresh a combo box in Frm2. How can this be done as the below is not working.
Private Sub cmd_cmp_Click() DoCmd.OpenForm "frm2" Me.frm2.Form.cbo_1.Refresh End Sub
-
- Application Error
by ComputerGramma
- 0 Replies
- Last post
by ComputerGramma
- I keep getting this iexplore.exe-Application error message:
"The instruction at "0x02f5454a" referenced memory at "0x02f5454a". The memory could not be "read".
What can I do to get rid of this
-
- Excel Userform - Runs fine but other users get a compile error
by suznal
- 7 Replies
- Last post
by suznal
- I have a userform that is called from a keyboard shortcut. It works perfectly fine when I run it, but other users cannot run it on their machines. We all are using Excel 2003 SP3, (only one user has SP2) and all users have changed their security to allow macros. But when they try to load the form they get a compile error.
The code I have for the userform is...
Code Block
-
- Returning a custom object from a custom collection
by MikeBos
- 3 Replies
- Last post
by Dick Donny
- Hello,
Am new to VBA object orientated stuff and have hit an early hurdle.
I've created a collection of boat objects with an array of boats and an integer counter. Storing the boats isn't a problem however when I try to retrieve the boats I'm getting Object variable with block '91' not set issues. For e.g.
In Main I'm calling
Dim Boats as New BoatCollection
...Code t
-
- Null Value Error in recordset
by Roborean
- 2 Replies
- Last post
by Roborean
- I have encountered a problem when returning a record set which contains a Null value. Please can any one help
I am trying to determine if a date field against a client is empty but if it is empty, when I try to get the value, I get an error message when it gets to dteDateCreated - "Invalid Use Of Null"
Dim SQLText As String Dim rs As Recordset Dim strClientCode Dim
-
- How to configure CER with no dialog?
by John Brown
- 14 Replies
- Last post
by Claus Brod
- I just tried to configure my XP SP2 workstation to send crash reports to a CER file share such that no dialog box would be presented. It didn't work as expected. ReportFault returned frrvErrNoDW and no crash report showed up in the file share. I have the 'Configure Error Reporting' policy enabled and a corporate file path entered. This works fine when I elect to 'send report' through the dialog bo
-
- .mdmp files not being created
by David Ching
- 14 Replies
- Last post
by JPSA
- Hello, Under what conditions is the .mdmp file created or not I have written an app that (deliberately) dereferences a NULL pointer, but the generated error report does not have the "Files that help describe the problem" section when listing the report from the Control Panel "Problem Reports and Solutions". Viewing other reports that had been put there, some of them have the f
-
- Runtime Error
by gibger
- 4 Replies
- Last post
by gibger
- I'm working on a project that gives a person there training heart rate. When I run it I get the error message
Runtime error '13': Type mismatch.
Here is the code:
Code Snippet
Private Sub btnTrainingHeartRate_Click() Dim age ' age Dim rhr ' resting heart rate Dim thr ' training heart rate
age = InputBox("Please enter you age", , 20)
rhr = InputBo
-
- iexplore.exe - Application Error (EVERY TIME I CLOSE IE7) :(
by sapphireoceans
- 14 Replies
- Last post
by Jillytodd
- Hi, I am absolutely clueless as to why this keeps happening, but it is driving me insane!! The exact error message reads: 'The exception unknown software exception (0x0eedfade) occurred in the application at location 0x7c81eb33.' Could anyone shed some light on maybe what the cause is and/or how I can fix it Thank you in advance to anyone who reads and/or offers any information. Laura x
-
- Dragin and dropin file names
by Dougy
- 2 Replies
- Last post
by YaelS
- Hello All
I am relatively new to VBA and have a question that I cant seem to find an answer to on then net. Not sure if it is possible, but here goes anyway. I would like to drag and drop a file path\name from explorer into a text box in an excel form where the text box would then display the full path and file name.
Thanks
D
-
- Common Dialog error...
by sdbenner
- 2 Replies
- Last post
by Shasur
- I am trying to use Excel VBA to open a folder and populate an array variable with all the word doc filenames in the folder. I am getting an "ActiveX component can't create object" error on the following code, specifically the Dialogs(wdDialogFileOpen) line, and I'm struggling to figure it out. Any suggestions Public Sub Main() Dim FileArray() As String, ffile As String, ffldr As String,
-
- Attaching Contents of a Folder
by Chin13
- 6 Replies
- Last post
by Andy Pope
- Hi all,
Using a macro running on excel, I am trying to attach the contents of a folder in Outlook. The files contained in the folder change, so it is not as simple as writing the code to attach a specific file. I need it to attach all the files regardless of the file name. Is this possible
Thanks in advance
-
- FindNext returns "Nothing" when doing iterative lookups, though data to find is in the cells
by damienm38
- 5 Replies
- Last post
by Andy Pope
- Hello,
I am implementing a lookup Method to find translation matches in XL tables.
For example, if I call the Method: Translate("world") in the following cells:
A | B
--------------------------------------------------------------------------
hello world | bonjour le monde
world | monde
-
- Possible to set CPU usage by Excel?
by Joe Dawson
- 4 Replies
- Last post
by Joe Dawson
- Hi, I have a spreadsheet that runs a bunch of code and then takes a little while to calculate. I have noticed that if I take the focus off of Excel, the CPU stops working on the Excel spreadsheet until I click back on Excel. In other words, if I go surf the web while my spreadsheet is calculating, Excel stops calculating the spreadsheet until I go back to and stay in Excel. I am using Excel 9.0.6.
-
- record links during IE navigation
by tx12345
- 0 Replies
- Last post
by tx12345
- hi here is the basic idea: [code] 'turn link logger on Set ie = CreateObject("InternetExplorer.Application") With ie .Visible = False .Navigate "http://msn.com" Do Until .ReadyState = 4: DoEvents: Loop Do While ie.busy: DoEvents: Loop end with 'turn link logger off end sub [/code] if you check the index.dat file a second later, these are all the links that show up related to navigating to just thi
-
- Using a formula as the default value in an inputbox (EXCEL)
by OTG
- 3 Replies
- Last post
by Andy Pope
- I currently have this:
Code Snippet NewValue = InputBox("Please enter a new value for the cell:", "User input required", Range(ACell).Value)
That works fine, except for cells in which there are formulae, where only the result of the formula is displayed. I want the user to be able to edit the formula using an input box. I've tried
Code Snippet
-
- Code Snippet Manager for VBA
by jameyer
- 2 Replies
- Last post
by Derek Smyth
- I am, for the moment, still writing my VBA code in Excel (and possibly soon word). I find that I use some code repeatedly. Is there any free code snippet manager for the VBA IDE
-
- error creating Excel application object
by srendoherty
- 1 Replies
- Last post
by Andy Pope
- Hello World,
I am using VBA from an application call MicroStation to open a document in Excel and am having problems creating the Excel Application object. The line:
Set xlApp = GetObject(, "Excel.Application")
results in the message Run-time Error '429': ActiveX component can't create object.
The documentation indicates a number of possible problems, but none of them seem li