Hi.
Is there a way of setting the "find" function to search from the bottom of the sheet to the top, hence searching the more recent entries first?
Cheers.
I know VBA jobs are hard to find out there, yet many people can benefit from having these kind of work outsourced. What suggestions do you have in terms of finding such opportunities?
I have a form containing 30+ controls, several of which are buttons.
One particular button launches a new form called "View Reports" which then has its listbox populated from a table of reports. A choice is made from the 7 possible reports and an "Open Report" button is clicked to preview the selected report. All this works fine on the development machine.
When the first button is clicked, "Calculating..." shows in the status bar for a time before the View Reports form is available. Then after a selection is made and Open Report is clicked, "Formatting page, press Ctrl+Break to stop ..." appears there (for minutes compared to seconds on the development box).
There are other points where things go slowly as well. I am not so much looking for a solution to this particular slowdown as I am for a debugging technique (Although all specific hints gratefully received).
The development box is only a P4 with 2.75 GB RAM and it performs reasonably. The target machines are Terminal Servers which perform fine in Word, Excel etc and other Access apps I've written. Multiple users tend to slow the Access apps down but even with just one user in this app the slowdowns frustrate the user.
Any hints appreciated.
Hi,
I'm currently working on a spreadsheet which has 7000 rows (source tab)
On the other tabs, I've got formulas picking up certain data...but my goodness, when I have to add a line or delete or save...it takes ages to process. Is there any way I can speed things up?
The file size is 1,611 KB
Thanks
Jen
The wife and I are taking our 2 3/4 year old to DisneyWorld in Florida next week. I have never been.
Wondered if any of you have gone and have any general tips or must sees, etc... any money-saving tips would also be nice.. it's going to hurt the pocket quite a bit, I know.
I am staying at a resort outside of the main park property but close enough to everything around.
Hello,
Mr. Excel did a quick video of his top tips. However, I can't remember where he posted that. Does anyone have the link?
I would like to know what tools I need to learn in order to be able to write a VBA routine that can browse Google finance" for example and get quotes or historical quotes of stocks.
Is there something special, other than writing VBA code, that I need to have. How is this related to google APIs which I hear much but know nothing about? Do I need to know these tools in order to make this task easier?
The colde below for example can open the google finance page, fill in the symbol of a stock (CPE in this case) in the search bar and thats all. I still can't know how to make it click the "get quotes" button. But even if I know, is this the way to go or there is easier way?
Sub VisitWebsite()
Dim ie As Object
Dim Webbrowser As Object
Set ie = CreateObject("InternetExplorer.Application")
ie.Navigate "http://finance.google.com/ "
While ie.busy
DoEvents 'wait until IE is done loading page.
Wend
ie.Visible = True
ie.Document.all("q").Value = "cpe"
While ie.busy
DoEvents 'wait until IE is done loading page.
Wend
End Sub
Thank you very much
What is the easy way to create forms in different sheets.......
In Main Sheet (Sheet1) each row contains some informations about a particular item.
I want to create Forms in separate Sheets and datas for this Form 1 (Sheet2) should be datas of Row#1 of Sheet1 & datas for this Form 2 (Sheet2) should be datas of Row#2 of the Sheet1.......
iinterested to determine whether there is a relationship between the number of room airconditioning units sold each week and the time of the year. What type of graph would be most useful in performing this analysis? why?
