I have a macro that pulls information from another spreadsheet that is generated as needed. The file that's generated is called output[x], where the x is a number between 1 and 9.
The line I'm currently using is, Windows("output[1].csv").Activate. But then I realized the the number may change (is doesn't always change, just sometimes). Is there a wildcard character I can use to replace that 1 with?
One way:
Please Login or Register to view this content.
Entia non sunt multiplicanda sine necessitate
I tried to copy that in but it didn't work. Here's the whole macro.Originally Posted by shg
One way:
Please Login or Register to view this content.
That's the macro as is, and it works if the generated workbook is output[1]. But again, sometimes it comes up as ouput[2], output[3], etc.Please Login or Register to view this content.
Last edited by TechTed; 12-27-2011 at 04:44 PM.
Please take a few minutes to read the forum rules, and then edit your post to add CODE tags.
Thanks.
Sorry. Won't happen again.
Thanks.
What's the name of the worksheet in "Balance Transfers" that gets pasted to?
Reallocation Requests
What's the name of the worksheet in output.csv?
EDIT: Never mind, back in a minute ...
Last edited by shg; 12-27-2011 at 05:17 PM.
Please Login or Register to view this content.
I really appreciate the assistance. I just tested it out and I keep getting a message that, No workbook like "output[#]" is open! I tested it with ouput[1] open, and also with output[2].
Ah -- the brackets get changed to parens by Excel:
Please Login or Register to view this content.
Hello SHG,
You need to escape the left bracket in the Like statement...
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
I take your point about the Like statement Leith (thank you), but in the workbooks collection, the filename of output[1].csv is actually output(1).csv
That still isn't working. I did just notice that in workbook output[#].csv the worksheet is called .csv]output(#). Might that make a difference in your suggestion?
I doubled up on the brackets as suggested by Leith and now it works. Thanks so much you two.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks