Search results for query: *

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

Interesting... how do I add a "frame in the page footer" ? Thanks, dylan

a little messy" only begins to describe these tables. I had the whole thing dialed and ready to go by creating these tables in Crystal Reports. But the client doesn't like the output... Crystal Reports exports to text format Word can read/edit, but it doesn't create rows and columns- just...

The other thread was more about finding any workaround for the general problem of not being able to create a 'table footer' in the same way you can create a table header. Here, I have one possible workaround I need further help on- overlapping the footer with the body. You're correct: what I...

WHAT would be the "last" row o[f] a table that can have any number of rows?" Seems like you could establish that the same way you establish which rows you want to repeat as a header: highlight them, Table > Repeat as Footer. Word would know which row because you told it which one, and it could...

For reasons explained in another thread, I need to overlap the page footer with the page body. I tried setting the page margin to something very low (0.5cm) and set the footer to start 3.2cm from the edge. Seems to me, that would cause the two to overlap. Any ideas? Thanks, dylan