Search:

Type: Posts; User: apb1963; Keyword(s):

Search: Search took 0.00 seconds; generated 35 minute(s) ago.

  1. Changing the file format did the trick. It now...

    Changing the file format did the trick. It now saves & closes the file as expected.

    Thank you!
  2. I tried elements of your code such as adding the...

    I tried elements of your code such as adding the file format. That made me realize that the template file that I'm using above is a .xlt file. Perhaps that has something to do with my problem? ...
  3. Thanks for the response. I suppose I should have...

    Thanks for the response. I suppose I should have mentioned the variables were in fact defined. I was trying to keep things very simple, as I have a substantial amount of code and two separate...
  4. Can't save/close worksheets in Excel through VBA code

    I have some VBA code I wrote several years ago in Excel 2000. I'm now running Excel 2003 and a few things aren't working.

    While poking around trying to figure it out, I ran into some code...
Results 1 to 4 of 4