Import, format, convert, print VBA module

**shg** · 04-14-2009, 11:42 PM

Please edit your post to use code tags, not quote tags. The forum rules tell all.

**ravishankar** · 04-15-2009, 06:23 AM

Hi
Save the attached file in the folder containing sample text files to be imported. run the macro.
Ravi

**rinser** · 04-16-2009, 05:10 AM

Hi guys,

I am analyzing the proposed solutions and will report back with the results.

Thank you!

**rinser** · 04-16-2009, 09:39 AM

Hi ravishankar,

When I run the macro on my pc it throws an error and points in yellow to this line:

.Refresh BackgroundQuery:=False

Do you know what shall I change?

Cheers,
Sergiu

**rinser** · 04-27-2009, 07:51 AM

Hi guys,

I am afraid none of the solutions is working or I don't know how to apply them. The solution of ravishankar is very close but part of the code is hidden it seems and I can't figure out how the two subprocedures work and how to call them both. I am closing the thread and will start a new one for another module similar to this one but a bit more complex and maybe adapt that one to solve also the needs in this one.

Thanks to all for the input and time!
Cheers.