Replies

There is another program that no one mentioned that might be of interest to you. The program is called AutoVue and it not only handles AutoCAD files, but it also handles over a hundred other file types, from raster image files, including PDF, 2D CAD, 3D CAD, MSOffice documents, archive files, fax images, etc. etc. Check out their website at:

http://www.cimmetry.com/cimweb.nsf

Not sure what the cost is, but I think there may even be different packages. Just thought it might be of value to you.

Drew

Thanks Hans. That worked great!

Drew

Legare!!

That was awesome!! I so appreciate your prompt response. I immediately took your code, pasted it into a module and tested it with a full-years transactions. It worked great. The only thing I subsequently changed is the worksheet names since the default name in the imported worksheet is different. At least I see how it was done and now I can make some tweaks as I need them.

THANKS AGAIN!!

Drew

THANKS A ZILLION to all who contributed!!! My dilema has been solved and once again it was the great folks that participate in Woody’s Lounge that came through!! I love this place!!

Drew

Just a thought. I use Adobe Acrobat too but never used the toolbar for producing PDFs. Anyway, could it be that this toolbar, or rather the XLA file that it is driven from, exists in an alternate start up folder? I was wondering if in your Tools, Options, General setup page there is an alternate start-up folder listed which may contain the offending XLA file. Perhaps you could try searching your hard drive for all files ending in .XLA. You may find something connected to the problem.

Drew

Thanks for the prompt response. I absolutely love this forum. It is better than any book or online help system. Anyway, I will have to try some of the ideas that were covered in that other thread.

Thanks again!

Drew

Jan,

Thanks for the help. I can’t understand why the named range issue is not more clear in the documentation. You enclosed the range name in square brackets “[ ]” whereas I have never seen that kind of syntax in the textbooks or online help. That I find is maddening.

Anyway, I have made some strides in my coding, but I am sure I will be needing more help down the road.

THANKS!!

Drew

Actually, I have tried something that would work well with your idea. One can use the simple ROWS function to determine the number of rows in a named range. Knowing this, for each imported range, one could simply add up the number of rows in each and use that value for further range imports. Thanks for the tip.

That is correct. There will be cases when the previously imported data may have blank cells in the left most column.
Basically, I want to create a worksheet template and a form that will provide checkboxes for options. The user will select the various options for data that is required in a new worksheet. When the user selects OK, the code will then import the appropriate ranges of data from an external workbook and place them neatly in order within the new template. Again, some of the imported data may have empty cells here and there.

I have attached a zip file of worksheets as examples. If anyone can provide me some insight as to how to get this started, I would be very grateful.

The three files in the ZIP are a reference file, containing all the standard data ranges that may be available, the template file that will be created dynamically based on the user selecting options in a form, and the end result file which shows an example of how it should come together in a finished product.

Drew

Thanks for the tip, but unfortunately the file doesn’t seem to be available on that site anymore.

Drew

I am running Norton Antivirus 2001. I am sure it did not have any effect on Outlook Express starting up when it was first installed. Who knows what it may be doing now. I will look into it’s effect.

Drew

Thanks for the input Leif. I tried the first idea of turning off the compacting in the background and it made no difference. The second KB article discusses another issue that only pertains to 95 or 98, not Windows 2000. So, I am still left with a slow starting Outlook Express 6.0 for now.

Thanks for the tip!! I tried it and of course it does just what you said. I learned something else too. If I select, say, the first five columns of data and paste it into a new worksheet, the column widths update, but the row heights are not included. I then tried the converse. I selected 10 whole rows of data and pasted them into a new worksheet. Lo and behold, the row height updated as well, but not the column widths. Go figure. Too bad it could handle both by default, but at least I am most of the way to my goal.

THANKS AGAIN!!

Oh do I feel a bit sheepish!

I was actually asked by another employee what he had done to do this and I could not for the life of me figure it out. He claimed he merely turned in his chair and as he turned, he hit some key(s) on the keyboard and Wha-La! the second window was open. So, it makes sense it was a real easy fix since it was created so easily.

THANKS!!

Thanks everyone for your help! I see now where I was in error. It makes sense not to have a permanent calculated field in the data tables. I tried adding a text box to a form and set the control to the formula and bingo! it worked fine.

THANKS AGAIN!