auto saving activeworkbook with specific name

**Rohmadi02** · 02-07-2012, 03:30 AM

Hello Experts..

I need your help to point me to the right direction.
I have an Excel macro that extract data directly from SAP system , and when the data export it to Excel it's has workbook name as ALVXXL01(1).
Usually I use ActiveWorkbook.SaveCopyAs code to grab it and save it to desired folder and file name but sometimes it's won't work . it's saved the master file instead of the activeworkbook of ALVXXL01(1).

Now , I am trying to use below new code but it's still not works yet.

Please Login or Register  to view this content.

Any help would be really appreciated! Thanks.

Regards,
Agung

**arlu1201** · 02-07-2012, 05:21 AM

In the above code, you have not assigned "sWbk" to anything. See if it works, if not let me know.

**Rohmadi02** · 02-13-2012, 05:34 AM

Hi Arlette, Thanks for the advise if I set "sWbk" as active workbook, this is not works. Pls complete the code as actually I am not expert on this , the code was obtained from forum.

Hi TMShucks,thanks for the info , I am newbi to this forum , tried to use code between them as below.

Please Login or Register  to view this content.

**arlu1201** · 02-13-2012, 05:46 AM

You need to put code tags around your code. Only then, i will be able to assist you. Check the forum rules on how you can put the code tags.

**Rohmadi02** · 02-15-2012, 12:44 AM

Hello Arlette..
I have put the code tag around my code..
see below

Please Login or Register  to view this content.

Pls assist on the correct script for Excel VBA.
Thanks.

**TMS** · 02-15-2012, 04:47 AM

@Rohmadi02: for future reference, you should edit the original post and add the code tags there. I will do it for you this time.

Regards

**Rohmadi02** · 02-16-2012, 03:03 AM

@TMShucks , Thanks for that, I appreciate it.

**Rohmadi02** · 02-21-2012, 11:12 PM

@Arlette, Can you pls assist me to correct my above code?

Thanks & regards,
Agung

**arlu1201** · 02-22-2012, 06:50 AM

Use this code -

Please Login or Register  to view this content.

**Rohmadi02** · 02-23-2012, 02:57 AM

Hi Arlette,
Thank you but it's got run time error '438': object does not support this property or method.
after press debug button, this line "If InStr(Wk, "ALVX") <> 0 Then" has yellow coloured.

any other alternatives suggestion??

Thank you .

**Rohmadi02** · 02-23-2012, 02:58 AM

Hi Arlette,
Thank you but it's got run time error '438': object does not support this property or method.
after press debug button, this line "If InStr(Wk, "ALVX") <> 0 Then" has yellow coloured.

any other alternatives suggestion??

Thank you .

**arlu1201** · 02-23-2012, 03:37 AM

Oops i am sorry, it had to be If InStr(Wk.name, "ALVX")

**Rohmadi02** · 02-28-2012, 03:25 AM

Hi Arlette,
Thank you so much ..It's works now..

Regards,
Agung

auto saving activeworkbook with specific name

LinkBack

Thread Tools

Rate This Thread

Display

auto saving activeworkbook with specific name

Re: auto saving activeworkbook with specific name

Re: auto saving activeworkbook with specific name

Re: auto saving activeworkbook with specific name

Re: auto saving activeworkbook with specific name

Re: auto saving activeworkbook with specific name

Re: auto saving activeworkbook with specific name

Re: auto saving activeworkbook with specific name

Re: auto saving activeworkbook with specific name

Re: auto saving activeworkbook with specific name

Re: auto saving activeworkbook with specific name

Re: auto saving activeworkbook with specific name

Re: auto saving activeworkbook with specific name

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions