Search results for query: *

Looks very promising! Thanks for sharing.

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

Thank you all for your answers. I have been able to fix the problem.

Thanks for the quick response Andrzejek, the format of the cell is "Number". Does it have to be "General"?

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

Thanks for all your help!! Works like a charm!

I found the answer to my own question. If I use the <pre> tag instead of the <p> or <span> tags, it leaves the spacing as 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...

Thanks Skip for the information. Sorry to have posted to the wrong forum.

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

I had no idea that could be done. Don't I feel like a dummy! Thanks for the info.

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

As usual Skip, you're a genius. Thanks for the help.

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

Both of you, thanks for your help!

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