Recent content by glyrocks

Right on, I'll check into that. I jumped on a .bat just because it was the first thing I thought of... Your script gets us plenty close, thanks again! dylan

Huh, well that's cool! I have a vague idea of how it's doing that, but there are a few things in there I'm clueless on. I really appreciate the code. One thing I didn't specify clearly is how the ROOT should actually display. We don't need it to return the path all the way back to the...

Hello all, I'm in need of some batch script help. I need to create a formatted text file that looks like this: ROOT l_comm_info.e00 3,939 l_mt1_lomc.e00 7,985 ROOT/SUBFOLDER1/ l_stn_start.e00 2,677 l_wtr_nm.e00 8,845 study_info.e00 4,608 ROOT/SUBFOLDER2/ s_base_index.e00...

Brilliant! I think I can take it from there. Thanks a ton, I would never have thought of that! dylan

I've built a spreadsheet we're using as a template to track certain things in a Access database. Using the Import External Data, I set up a simple query using a test database. Everything returns fine, all my calculations do what I want. But now I want to duplicate the template, keeping my...

Background: I've got a single spreadsheet I'm using to track changes to certain fields in 7 separate Access databases. So, I have 7 DB queries using the Get External Data... tool dumping into a single sheet. The tables and fields have the same names and data types in each database. I've got...

It is all one continuous table, but I don't want to format it all at once. There are a couple of nuances with the data and formatting that the user needs to watch for. So, by giving them a form to specify how many times to repeat something, they can stop and adjust things as needed. dylan

It isn't looping through each row, rather repeating a set of formatting instructions. The table runs anywhere from 20 to 150 pages so I needed a way for users to tell the macro how many pages to format. Counting the number of rows could be useful though. dylan

Thanks for the quick responses but I found a solution. I was trying to declare a variable in the form, and then use that variable in the macro. Instead, I just pulled the variable from within the macro: rows = UserForm1.TextBox1.Value thanks again! dylan

I've got a handful of macros in Word 2003 that format table rows. I can get them to loop x number of times no problem, but only if I hard code it in the macro. What I had envisioned was a userform popping up that would ask how many times to run the macro, user enters a number in a text box...

thanks, appreciate the help dylan

Thanks, PHV- that fixed it. I appreciate the quick response. Can you-or anyone else--explain what the difference is? Why the 's' was wrong in my case, but didn't throw a syntax/compile error? Remou- you are correct, that code only works for one particular situation. I was hoping to get one...

I'm trying to create a simple form that builds a select statement based on two comboboxes. I was following a tutorial online, but have gotten stuck. I think I have the combobox and variables set up correctly, but I'm new to this whole coding thing and am not sure what needs to happen next...

I haven't been exporting to PDFs, but I have been working with exports to Word (rtf). It seems that the fonts end up about a half pt smaller in Word. We have to use Helvetica, so I don't know if this affects other font faces as well. Don't know if that helps you any, but at least you're not...

Cool, I will play with that and see what comes of it! Thanks a lot! dylan