Search results for query: *

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

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

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

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

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

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

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

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

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

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

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