LinkBack URL
About LinkBacks
Why doesn't this code work??
I keep getting an "Object Required" error.
The error is reported on the Set NewFileName line.
Please Login or Register to view this content.
Also, how do I write the code to save the file to the an end user's Desktop?
Why doesn't this code work??
I keep getting an "Object Required" error.
The error is reported on the Set NewFileName line.Please Login or Register to view this content.
Also, how do I write the code to save the file to the an end user's Desktop?
Last edited by HuskerBronco; 12-20-2011 at 02:57 PM.
You don't need to set a Long Variable from what I can tell. And your code is missing some things.
Try this
Please Login or Register to view this content.
Be fore warned, I regularly post drunk. So don't take offence (too much) to what I say.
I am the real 'Napster'
The Grid. A digital frontier. I tried to picture clusters of information as they moved through the computer. What did they look like? Ships? motorcycles? Were the circuits like freeways? I kept dreaming of a world I thought I'd never see. And then, one day...
If you receive help please give thanks. Click the * in the bottom left hand corner.
snb's VBA Help Files
A Long isn't an object so you can't set it.
Try this
Please Login or Register to view this content.
Thanks, guys...for the help.
I got the macro to create & name the files as requested...and place them on MY desktop during testing.
JapanDave said:
Yeah...sorry about that. I originally had it set as STRING. In an effort to get the macro to work...I was trying everything...including changing the variable type.You don't need to set a Long Variable from what I can tell.
Kyle123 said:
And there lies my main error. I'm still fairly new at this VBA and didn't realize I was trying to SET a variable.A Long isn't an object so you can't set it.
Also, Kyle123:
Your code to set the new workbooks to the END USER'S desktop returns a syntax error at the following line:
Do I need to change something, here? ...or in the function ??ActiveWorkbook.saveas Filename:=DesktopPathDir & NewFileName,
FileFormat:=xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False
Dunno I've only got 2003, what's in the range that you are setting as the workbook name. Do you need to include the extension?
you don't need any declaration:
Please Login or Register to view this content.
Last edited by snb; 12-20-2011 at 10:44 AM.
Your original code is bad.
I posted the code for this earlier. Copy this and see how you go?
Edit: Or just follow Snb's code.Please Login or Register to view this content.
Yep...the range is a concatenation of cell value PLUS ".xlsm"
Last edited by HuskerBronco; 12-20-2011 at 09:31 PM. Reason: correct typo
Yep....I left out the code continuation underscore.
snb...
I had no idea you could code this without declarations.
My question is...what is the 52 in the following line ?? :
Wait...that's the code number for the file format...isn't it ??Please Login or Register to view this content.
Bingo ! You hit it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks