So, I have a macro that copies sheets to new files and saves the new files with incrementally increasing names. So, the first file would be "LocalizedData1", then second would be "...2", etc.
I'm able to successfully save the first file, but later in the program, when the "pageCounter" variable has increased, the FName variable remains unchanged.
Please Login or Register to view this content.
I guess I don't see a loop or where you are incrementing pagecounter....
Ernest
Please consider adding a * if I helped
Nothing drives me crazy - I'm always close enough to walk....
That code is in a different section (it's a really long macro). I ended up putting this in again after the pageCounter increase: FName = "LocalizedData" & pageCounter & ".xls"
Have you stepped (F8) through the code and opened the locals window....this will allow you to see the variable incrementing or not.....
Does changing the pageCounter to Static help?
*******************************************************
HELP WANTED! (Links to Forum threads)
Trying to create reusable code for Custom Events at Workbook (not Application) level
*******************************************************
I'm wondering if the variable is global vs local....
@mc84excel - is that what you mean by static?
Declaring variables as static retains the variable value after the procedure containing the variable ends. See http://msdn.microsoft.com/en-us/libr...v=vs.110).aspx
How and where is the variable pageCounter being declared?
@mc84excel - makes sense.....I learn them as Global vs local....either way I agree with your idea....
Re your comment about global vs local. I learnt a lot from Chip Pearsons explanation of scope of variables - highly recommend it as a refresher. See http://www.cpearson.com/excel/scope.aspx
(Resources I've read always identify 3 scope levels. Chip identifies 4)
@mc84excel
Isn't that for VB and not VBA?
Global and local is at what level you declare them. As in if they can be used by multple procedures, functions etc.
Thanks,
Solus
Please remember the following:
1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.Highlight the code in your post and press the # button in the toolbar.2. Show appreciation to those who have helped you by clickingbelow their posts.
3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
"Slow is smooth, smooth is fast."
great idea - thanks
No, it's for VBA. Most books etc. describe three levels of scopes (local, module, global). Chip adds a 4th level 'Project'. (Project is like Global except that it can only be referenced within the same project. Whereas Global can be referenced from another open project).Originally Posted by Solus Rankin
Those aren't static. Static (and the link to MS you posted) are used in VB. I don't believe it functions the same way in VBA. At least I haven't found anything to show me it has.
Oh. I thought you were questioning the levels of scope - so I was answering that.
Well I haven't used Static Variables myself in VBA but I have read about them in at least one * book on VBA ('Excel 2010 Power Programming with VBA' author John Walkenbach; See page 206)
We are slightly getting off the OPs question.
* at least one = I have a vague recollection of reading them elsewhere. Just can't remember at the moment.
Last edited by mc84excel; 11-13-2013 at 07:29 PM.
I don't see where pageCounter is declared. To trouble shoot we'd really need to whole code, or better yet an example workbook with code in place.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks