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!

  • Congratulations Mike Lewis 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. NashProjects

    Excel VBA - go through each cell value (row)

    assuming that the column B contains all the filenames personally i would go with the following as its clearer and you can F8 through what you are doing easily Dim dRow as double Dim fso As Object Dim nPath As String nPath = Worksheets("Sheet1").Range("C2").Value Set fso =...
  2. NashProjects

    Best way to store my VBA Code snippets

    hi I started with a blank excel workbook and created a separate module for each section of code type for example I created a module called B_SQLConn and i store all the code ive ever used to connect to sql, access or oracle databases.. etc etc Stuff like A_Codepool is where all my general...
  3. NashProjects

    Automating Flash Website from VBA

    Hi, I have tried many times to access the flash embedded objects from VBA without success. I am a dab hand at web scraping, data mining through VBA however have never managed to automate the flash objects at all except through sendkeys which I really do not want to rely upon. Has any one had...
  4. NashProjects

    How to split a PDF into pages using VBA

    What you mean Fumei? Kind regards Lee Nash http://www.Nashprojects.com
  5. NashProjects

    How to split a PDF into pages using VBA

    Ummm im not techical with Acrobat so im assuming i wont have!! I think I need to find another way around that, as its for the office and if I do buy acrobat then i'll only have one license for it... I want this program to be used on everyones pc rather then just my own. Thanks for the heads...
  6. NashProjects

    Outlook Macro to get data from a field in an MS Access DB

    Yes sorry I was being lazy there and should really have split those out.. Hope the rest of the code helps though. Kind regards Lee Nash http://www.Nashprojects.com
  7. NashProjects

    How to split a PDF into pages using VBA

    Well there are several standalone applications out there that all you to split pdfs into seperate files. I know there is code out there that can combine pdf's into one so there must be some code out there that can split pdfs into seperate files based on their page number? Im assuming this is...
  8. NashProjects

    Outlook Macro to get data from a field in an MS Access DB

    this would work: Option Explicit Public adoconn As ADODB.Connection Public adors As ADODB.Recordset Public adoconn2 As ADODB.Connection Public adors2 As ADODB.Recordset Public sql, ssql, ssql2 As String Public sTable As String Public filenm, MyField Public Sub getrs() sql = "Select *...
  9. NashProjects

    How to split a PDF into pages using VBA

    hi all, Im stumped with a problem. I have a PDF file and I need to split this into individual pages... I would normally do this manually but I have thousands per month and so I want to automate this process. I am an expert in excel vba but this has baffled me as i cant seem to find any...
  10. NashProjects

    Running a spreadsheet macro every 30 mins

    ive answered this in the post http://www.tek-tips.com/viewthread.cfm?qid=1538090&page=1 Kind regards Lee Nash http://www.Nashprojects.com
  11. NashProjects

    Is there an Excel/VBA Timer for running a macro ~once an hour?

    If you use application.ontime this will suit you perfectly. for example sub TestOntime 'put your code her application.ontime now()+timevalue("00:01:00"), "Procedure_Name", now()+timevalue("00:00:30") End sub Run the sub once initally and then the sub will run every hour form then on...

Part and Inventory Search

Back
Top