Save As [to disk and to SharePoint not working]

[alaboudy]

hello guys

Dose any one can help to know how many ways that we can use

Please Login or Register  to view this content.

and how we can use it ?

also I have two examples it didn't work with me I don't know why I wish if anyone could help me to correct it

1-

Please Login or Register  to view this content.

example 2

Please Login or Register  to view this content.

in the second example I want to save the extract copied sheet from my main workbook in link that been named in wbNam


waiting the answers from you guys

[alaboudy]

any one ????

[6StringJazzer]

Your declarations for wb and wb2 are incorrect. They need to be like this:

Please Login or Register  to view this content.

In your first example, you are saving to a folder on the desktop called "BGC Production Database". If there is no folder by this name already, this will fail.

For your second example, I do not have experience saving files to a SharePoint site by using a URL. However, this page seems to show that this is possible but with a different syntax in the address.

In both cases, what does "it didn't work with me" mean?

• Does the code run?
• Does it run but do nothing?
• Does it produce error messages? If so, what do the messages say?
• Does it produce unexpected/wrong results?
• Does it hang?

[6StringJazzer]

any one ????

I suggest you wait a little longer before bumping your thread. You waited less than 1 hour. That's not very long. Some people look for threads to answer by reviewing "unanswered threads" and if you bump your own thread, you take it off that list.

[alaboudy]

I suggest you wait a little longer before bumping your thread. You waited less than 1 hour. That's not very long. Some people look for threads to answer by reviewing "unanswered threads" and if you bump your own thread, you take it off that list.

sorry man I was in hurry

[alaboudy]

Your declarations for wb and wb2 are incorrect. They need to be like this:

Please Login or Register  to view this content.

In your first example, you are saving to a folder on the desktop called "BGC Production Database". If there is no folder by this name already, this will fail.

For your second example, I do not have experience saving files to a SharePoint site by using a URL. However, this page seems to show that this is possible but with a different syntax in the address.

In both cases, what does "it didn't work with me" mean?

• Does the code run?
• Does it run but do nothing?
• Does it produce error messages? If so, what do the messages say?
• Does it produce unexpected/wrong results?
• Does it hang?

I found the the error in the first example when I change the sharepoint link to different path it work so looks like I am missing something in that path work now to fix it
thanks for your replay dude