KashLeeC
07-18-2011, 11:59 PM
Hi there, I have a somewhat strangely specific goal in mind, and I'm not sure how to go about accomplishing it. I'll give you as much information as possible, so bear with me, and ask if any questions arise.
I have a master Workbook called Combination. In it, it has a precise number of worksheets, 18 to be exact. Basically, I need all worksheets to be made into their own table in Access, with the name of the table the same as the worksheet. A macro or whatever needs to be used would be great.
Ill attach a sample of the Combination page. The first page will always have 20 columns, the second 16 columns, and the last 16 pages will have 5 columns. If any questions arise, I will be glad to help.
I'm learning VBA and all of this through these different projects, so I don't have much coding to go on, only my explanations.
Thank you so much for the help, it means a lot.
I have a master Workbook called Combination. In it, it has a precise number of worksheets, 18 to be exact. Basically, I need all worksheets to be made into their own table in Access, with the name of the table the same as the worksheet. A macro or whatever needs to be used would be great.
Ill attach a sample of the Combination page. The first page will always have 20 columns, the second 16 columns, and the last 16 pages will have 5 columns. If any questions arise, I will be glad to help.
I'm learning VBA and all of this through these different projects, so I don't have much coding to go on, only my explanations.
Thank you so much for the help, it means a lot.