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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by rustyshackleford
-
Error with PDF Macro
Hi, I'm having a devil of a time with a macro I use to convert a couple hubdred excel files into pdf format for distribution. I have used the macro for months with no problem, but when we switched fiscal years, some changes were made to the source excel document making it significantly larger...- rustyshackleford
- Thread
- Replies: 0
- Forum: Microsoft: Office
-
Using VBA to set links in Excel 2002
Figured it out. PAth nem needs to go outside the brakcets (though why that results in the particular error, I still don't understand). Damn, what a waste of a morning. Rhett- rustyshackleford
- Post #2
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Using VBA to set links in Excel 2002
Hi, I'm trying to write some code that will: A) Provide a list of all files in a directory B) Link to a value on what is called the 'Input' sheet of each file. I'm using the following code Sub BPRLookup() Dim Directory As String, file As String Dim file_counter As Integer...- rustyshackleford
- Thread
- Replies: 1
- Forum: VBA Visual Basic for Applications (Microsoft)
