RE: open / close files and display names

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance


Well, I always approve of trying to make a program better. Ok, then, it
seems to me that you need to change the syntax of the assignment statement
when you're closing your sheets. Change the cells .Value assignment to
..Text, and change those single quotes to double quotes (remember you're in
VBA, not REXX). That should fix the immediate problem. But of course that
doesn't mean another problem won't pop up behind it as soon as you have the
obvious one fixed.

Or if that doesn't fit your circumstances, maybe instead of my trying to
guess what's wrong with your program, try this: Tell us which part of your
program isn't working, and what it IS doing instead. Like this: "I want to
remove the file name from worksheet 'FileList', but when I use the
Range.Remove action, I get the following error message...", or "...but I
don't know what command is equivalent to deleting the contents of a cell", or
whatever.

--- "Jack" wrote:
i have a macro that will open the files but i was trying to cut down on the
visual noise and that is when the list idea came up. I understand some of
the basics and what i have works but i'm trying to make it better.
.

Relevant Pages

  • Re: Game
    ... In this event handler you update your game state ... Not all browsers creates a global variable pointing to the element ... assignment only need to run in IE, ... two unpicked cells until you succede (average number of tries is only ...
    (comp.lang.javascript)
  • Re: Help with Homework
    ... There were 14 students that did not do this assignment. ... You must print a sentence with the I.D. numbers of the students who did not take the test. ... Any empty cells that are found must be counted and the number of them declared in the output statement. ... Where Scores is the variable name that stores the matrix from the Excel file. ...
    (comp.soft-sys.matlab)
  • Re: Calculate
    ... in the AdventureWorks everything is working fine, ... writes in the empty cell. ... Because the main query uses the Non Empty operator all empty cells (leaf ... The assignment for a leaf-cell is it persisted ...
    (microsoft.public.sqlserver.olap)
  • Re: tricky hash
    ... fixing the typo where you build the key for the last assignment ... would help with your immediate problem. ...
    (perl.beginners)
  • Re: How to expand escape sequence (e.g. )?
    ... My actual scenario however is more complex and cannot be addressed by a ... simple assignment. ... >> translated into newline characters. ... > Second, \n isn't interpreted inside of single quotes, but only inside ...
    (comp.lang.perl.misc)