VSB error autogenerate worksheet from list
Closed
shayla03
Posts
1
Registration date
Wednesday March 2, 2016
Status
Member
Last seen
March 2, 2016
-
Mar 2, 2016 at 05:40 PM
vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 - Mar 3, 2016 at 01:42 AM
vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 - Mar 3, 2016 at 01:42 AM
Related:
- VSB error autogenerate worksheet from list
- Network error occurred - Guide
- Transfer data from one excel worksheet to another automatically - Guide
- Mobile number list with name - Guide
- Counter strike 1.6 cheats list - Guide
- Cmos checksum error - Guide
2 responses
Your problem is in this statement:
You need a logic tree for checking if the file exists.
Check to see if the same file is there, if so, rename the file to the file name, and the date-time. this is a very ugly solution, and really will need some houskeeping, or your disk will bloat out! Also, you must remember what the last file name was. I would recommend writing that back to a cell on your sheet! Then who ever saves it, can see what it is, and where it is. You can also map to a network drive so everyone saves to the same place. They will also know where to get it.
I would suggest looking at office 365!
Sheets(Sheets.Count)
You need a logic tree for checking if the file exists.
Check to see if the same file is there, if so, rename the file to the file name, and the date-time. this is a very ugly solution, and really will need some houskeeping, or your disk will bloat out! Also, you must remember what the last file name was. I would recommend writing that back to a cell on your sheet! Then who ever saves it, can see what it is, and where it is. You can also map to a network drive so everyone saves to the same place. They will also know where to get it.
I would suggest looking at office 365!
vcoolio
Posts
1411
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 6, 2024
262
Mar 3, 2016 at 01:42 AM
Mar 3, 2016 at 01:42 AM
Hello Shayla03,
What ac3mark says is fundamentally true but have a look at the following link to a test work book I did for another Poster about a year ago:-
https://www.dropbox.com/s/9wz94jjsptvf061/Create%20and%20Name%20New%20Sheets%282%29.xlsm?dl=0
It creates new sheets without the error problem and is a little tidier than what you already have.
You may be able to adapt it to your work book (but please test it in a copy of your work book first).
The code is in Module 1.
I hope that this helps.
Cheerio,
vcoolio.
What ac3mark says is fundamentally true but have a look at the following link to a test work book I did for another Poster about a year ago:-
https://www.dropbox.com/s/9wz94jjsptvf061/Create%20and%20Name%20New%20Sheets%282%29.xlsm?dl=0
It creates new sheets without the error problem and is a little tidier than what you already have.
You may be able to adapt it to your work book (but please test it in a copy of your work book first).
The code is in Module 1.
I hope that this helps.
Cheerio,
vcoolio.