I'm using the following code to export all worksheets in a workbook into individual sheets, however in my main workbook I have three sheets which appear before the sheets I want to export that I don't want to export every time the macro is run. Is there any way to adapt the macro so that it skips the first specified number of sheets or exports from sheet 'X'
Many thanks
Please Login or Register to view this content.
Hi, HangMan,
you may rely on the Index of the worksheets although I would prefer to use an array or a string with the codenames of the sheets to skip:
I changed your variable FileName as it is used as a VBA KeyWord.Please Login or Register to view this content.
Ciao,
Holger
Last edited by HaHoBe; 02-17-2014 at 06:48 AM. Reason: altered code
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Hi Holger,
That works well, thank you. If you were to adopt your preferred method of using an array or a string with the codenames of the sheets to skip, how would you go about doing this. I think that has to be a more foolproof methid right?
I have very limited VBA experience, so unure how you would intergrate this?
Many thanks
Hi, Hangman,
the sample for the sheetnames may look like this:
Ciao,Please Login or Register to view this content.
Holger
If it is OK to ask in this thread, how would I do the same thing except export to individual PDF files?
Hi, dmarzean,
Forum Rule #2 asks you to start your own thread and maybe provide a link to this thread if needed.
Ciao,
Holger
Done. Thank you sir.
Hi Holger,
Um, all seems to work fine on a sample sheet, but when applied to my main sheet (which I can't upload due to sensitivity of data), I get a Runtime Error 1004, as follows:
The file could not be accessed. Try one of the following:
Make sure the specified folder exists
Make sure the folder that contains the file is not read-only
Make sure the file name does nor contain any of the following characters: <> ? [] : or *
Make sure the file/path name doesn't contain more than 218 characters
All the conditions are met, so I am totally baffled as to what is causing the error?
The error appears to be in these lines of code
Am I missing something, any thoughts?Please Login or Register to view this content.
Many thanks
Hi, Hangman,
check the TrustCenter in Excel if the access to that folder is set, make sure you have access to that folder by checking with the Windows Explorer, as I received a new AntiVirus-Program today check if any settings have been modified in/from taht software, if Windows- or Office-updates have been installed, have a look at http://support.microsoft.com/kb/213983/en-us.
Ciao,
Holger
Hi Holger,
I have no problems running the code on a simple sample file I have, exporting to the exact same folder, so it isn't the folder, the file name doesn't exceed 128 characters or contain any illegal characters, so I am truly baffled and not sure what else to test for as there is no noticable difference in the process. Could there be anything in the file itself it doesn't like?
Are there any other things you can thing of to check?
Many thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks