Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 41
Default Recursive Sub Routine?

I have a question for you gurus out there!

I have a macro to import a text file, run some code and basically assign
item numbers to each part of sheet based on different cells values. When
first run, the macro prompts for a job number, and then creates a directory
for this job number. Because each job has multiple text files, at the end of
each run of the subroutine, i'm calling the "WallsPlus()" sub routine again.
The thing is, I don't want the user to be prompted to have to type in a job
number for every single text file (Sometimes 50+)

I have two ideas, neither of which I know how to implement.

1. I wanted to setup If strJobNumber = "" then prompt for the job number...
if strJobNumber < "" then don't ask for a job number. The problem here, i
believe, is that when the sub routine is recalled, the previous strJobNumber
is erased and is always set to ""

2. Import all the text files in one go. I don't see how this is a huge
possibility, simply because every way i have tried to import a new text file,
it opens a new workbook. And to create a macro to copy and paste a new
workbook into a previous workbook an unknown number of times seems rather
difficult and necessary.

If anyone has any ideas on how I can implement either of these solutions,
let me know, and if you want to see my code (although very crude, but working
none-the-less) let me know!

Thanks,

Derek

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Recursive Functions...maybe busboy10 Excel Worksheet Functions 0 March 28th 11 09:46 PM
Recursive Sub Routine? Rick Rothstein Excel Programming 0 June 19th 09 02:55 PM
Is this a recursive problem? davegb Excel Programming 2 August 16th 06 07:53 PM
Recursive Code Myles[_68_] Excel Programming 1 August 13th 06 02:11 PM
Recursive Functio help BigBobbo Excel Worksheet Functions 1 May 10th 06 07:23 PM


All times are GMT +1. The time now is 06:57 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"