Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. dvirgint

    Using CMD to search through network drive

    Looks very promising! Thanks for sharing.
  2. dvirgint

    Using CMD to search through network drive

    .../C DIR """ & "N:\" & _ Me.txtRegion.Value & "\" & Me.txtYear.Value & "\" & _ Me.txtDossier.Value & "*.*"" /S /B /A:-D").StdOut.ReadAll The results are then split into an array and processed. Does anyone have any suggestions for how to improve this code?
  3. dvirgint

    WIA with Access VBA slow

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

    Alternate way of sending email from Outlook to OneNote

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

    Scrape data from currently opened webpage into Excel

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

    Excel formulas show as text

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

    Excel formulas show as text

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

    Excel formulas show as text

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

    Spaces removed from string

    Thanks for all your help!! Works like a charm!
  10. dvirgint

    Spaces removed from string

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

    Spaces removed from string

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

    VBA - update Outlook calendar item

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

    VBA - update Outlook calendar item

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

    Manual copy and paste

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

    Floating &quot;Back to top&quot; button

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

    Floating &quot;Back to top&quot; button

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

    WaitForString

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

    WaitForString

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

    Excel : VBA to print pages 1 and 3

    Both of you, thanks for your help!
  20. dvirgint

    Excel : VBA to print pages 1 and 3

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

Part and Inventory Search

Back
Top