Syntax Issue

**Vladamir** · 07-30-2012, 09:55 AM

I have the following sub for a macro which will grab a portion of one of the sheets and save it to a jpg file.

Please Login or Register  to view this content.

What I need to do is the allow the filename, in this case H:\BOM.jpg to be concatenated from a value in one of the cells ThisWorkbook.Sheets("Sheet1").Range("F10"). But when I try this like so

Please Login or Register  to view this content.

I keep getting an Expected: list separator or ) error message.

**BigBas** · 07-30-2012, 09:57 AM

Try creating a variable, then saving based on the variable name.

Something like:

Please Login or Register  to view this content.

Then use fName as your filename.

**Vladamir** · 07-30-2012, 10:03 AM

Thanks...that worked nicely. I was hoping to avoid the assignment of another variable but in this case it appears that all the quote marks confuses the issue. Thank you again.

**BigBas** · 07-30-2012, 10:04 AM

No Problem. I'm glad it solved your problem.

**Cutter** · 07-30-2012, 10:36 AM

@ Vladamir

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.