Search results for query: *

I'm writing to see if anyone can tell me the fastest way of extracting filenames from a network drive I have offsite. I have some search criteria provided by users with the help of a userform in Access. I've tried using FSO which in my experience in this situation is the slowest. I've also...

I have a macro running in MS Access 2013 which was created to scan documents from an HP Scanjet Enterprise Flow 7500 scanner, save the results as a PDF and automatically email the file to someone else in our organization. The macro itself runs as it should, however compared to the HP software...

Hello, I've scoured the internet to find an answer, but was unable to find an answer. Here is my problem: My organisation has a size limitation in Outlook 2013 inbox size. As such, we have had to come up with possible solutions to saving these emails in a comprehesive way which is easy to...

Hello, I have been trying to read up on scraping data from an opened IE page but I have not been able to find anything. All documents I've seen open a blank page and then navigate to a given address. What I need is quite simply (or it seems to me to be), is to get the "breadcrumbs" list into a...

Hello, I have an Excel spreadsheet with numerous cells that have formulas in them. Not all, but most of them appear as text. I've searched a lot and tried everything I could find: checking whether the cell format was text - it is not checking if the "show formulas" mode is activated - it is...

Hello, I have a macro which scrapes data from a mainframe emulation program called Attachmate Reflection into Excel to make various calculations for sales people. I have to scrape sales information for each salesman and send it to them in an email. My problem is that once the screen...

Hello, I am able to create an Outlook appointment from Excel using code I got from : http://www.mrexcel.com/forum/excel-questions/553718-excel-visual-basic-applications-update-create-delete-appointments.html Option Explicit Public Function CheckAppointment(ByVal argCheckDate As Date) As...

Hello all, Where I work, management has determined that macros cannot scrape information from Attachmate Reflection for a period of a few months. As you can imagine, most of the macros used scrape information from the terminal, and they are all indispensable. I am in the process of modifying...

Hello all, I have a few lengthly Word documents here at work, and was wondering if there was any way to have a floating "Back to top" button like we see in so many blogs today? It would make it much simpler to get back to the top. Any suggestions would be helpful. Thanks dvirgint

Hello all, I've always used the WaitForString function because it improves the speed execution of the macros I write. I have recently come across a page in my system that I haven't been able to use it with because there isn't a specific string I can wait for. My question is: is there a way to...

Hello All, I have an Excel worksheet which scrapes information from another program. Depending on the length of the scraped information I may have to print page 1, 2 and 3. If there isn't enough information, I only print page 1 and 3. I know how to print page 1 to 3, however I can't find out...

Hello, My company has switched from Attachmate Extra! to Attachmate Reflection recently and I have been creating new macros with the new Reflection syntax. All is going well, however I was wondering if there was a way to create a variable to shorten the extremely long Sendkey functions. For...

Hello, I have been able to scrape information from Attachmate Reflection into Excel with the help of a very patient SkipVaught and vzachin. Within Excel, I've manipulated the data which was scraped and I now need to return this information back to another system I have in Reflection. Has anyone...

Hello, I have a macro which scrapes information from an outside program and creates a table with the information. To increase readability, I would like to have every other row shaded. Since the amount of information which is scraped varies from time to time, I may have 1 or more pages, and I...

Hello all, I have information in Extra! that I need to extract. I created an Excel file to be able to manipulate the data which I will extract. My problem is getting my macro to see more than one instance of the string I'm searching for, as it is probable there will be more than one on each...

Hello, As the title says, I would like to know if I can add a custom equation to the status bar located in the bottom section of Excel 2010. I see that Excel offers the sum, average, etc. of the selected cells, however I would like to know if I can add my own. I have a formula that come back a...

Hello, As the title implies, I have some userforms that appear while a macro is running, however if there is more than one application running at the same time (ex. Internet Explorer, Word, etc), the userform appears behind the other windows. I've seen in a number of forums that it is possible...

Hello, We recently upgraded from Extra! Extreme to Reflection. We have been enjoying the new interface with the ribbon, however no one has figured out how to map a key to "undo" an action - in most other applications, this is done by pressing "ctrl-z". Is this even possible?

Hello, I created a macro which automatically starts when the excel file is opened. I need to be able to start this macro from within Extra! and so I created a macro with the following code to do this: set xl = CreateObject("Excel.Application") If dir("H:\My documents\Comptes\INNS.xls") >...

Hello, I've made a macro which scrapes information from Extra! Attachmate. The information is then printed onto a form which is located in one of three trays in a printer. One of the pieces of information is the person's language (Ex. 'English', 'French', 'Spanish'), and this information is...