Help in code for Save As excel file in a folder

[anilpatni1234]

Hey guys I am stuck with a simple problem:

I have this code to save excel file in a specified folder with filename - range C3 and T46.
The code is assigned to button "PAID" in sheet INVOICE

the code captures the text in range C3 but is not capturing range T46

I want it to capture range C3 and T46.

can anyone please help me .
I have attached my workbook.
Thank you

Please Login or Register  to view this content.

[anilpatni1234]

Hey guys,
Was anyone able to glance through it?

[Pepe Le Mokko]

Administrative Note:

We don't expect you to bump threads more than once in 24 hours - Please remember that those who help here do so voluntarily and of their own goodwill. They live in many different time zones and many will be out at work right now if they are not asleep on the other side of the globe. This is not a paid 'service': members will help when they are ready and able to do so, and not 'on demand'. Please do not try to put pressure of time on anyone here: if you get the help you need today, that's fine, but you really should not count on it. Thanks for your understanding and patience.

[KOKOSEK]

I don't know proper name to enter and sheet is autoclosing.

[anilpatni1234]

Hey KOKOSEK,
Thank you for puttin that to my notice.
I have updated the file . It will open now without asking any details.
Thank you. (sorry for not checking that earlier)

[KOKOSEK]

Try like:

Please Login or Register  to view this content.

[anilpatni1234]

Hey KOKOSEK,

This does not work. AT the moment it only captures C3.
It is not able to capture T46

[anilpatni1234]

Hey guys,
I found a bug.

The above code captures filename as - cell C3 and Q42.
Even if i change filename range to other cell, but still it does not work.

Please Login or Register  to view this content.

i have chaned to filename to range cell T46 . But still it picks data of Q42.

Any help ?

[Marc L]

Hi !

Obviously we can't help further without the last updated code as we are not on a mind reader forum ‼

[anilpatni1234]

Hey Marc,

The code is same as post no 1 which is

Please Login or Register  to view this content.

As you can see in the code

Please Login or Register  to view this content.

i have entered range t46 as filename 2

however it picks cell Q42 as filename.
It does not pick T46

[Marc L]

Restart your computer then open Excel alone and try again …

[anilpatni1234]

Hey Marc L,

Thank you for the suggestion.

I restarted my PC over 10 times and now finally it is working.
Took time to solve it but finally wokred.

Thank you so much for the help

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

[KOKOSEK]

Hey KOKOSEK,

This does not work. AT the moment it only captures C3.
It is not able to capture T46

Why? In T46 you've got total on invoice and works for me.