VBA Help - Save As with cell reference

[devink]

Hi

I have the following code to perform a certain task and then to save the file to a specific location as a normal excel file (not macro enabled).
I am trying to save the file name as text from a specific cell on sheet1, cell C1.

Only need help with the saving part, the rest works well.

Please can you assist

Thanks,
Devin

Please Login or Register  to view this content.

[bakerman2]

Devin, welcome to the forum. Please add Code Tags to your first post to comply with Forum Rule #03.

Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

Doesn't this do the same ?

Please Login or Register  to view this content.

[devink]

Thanks for your reply. Have changed it to code.

Still having 2 issues:
1. If C1 is a date (currently =text(B1,"dd/mm/yy"), the file will not save as C1. If however I put it as "Test1", it will save.
2. The file that it saves to the folder does not have all the information pasted. Only column A is copying and pasting correctly.
3. How can I save the whole file as an excel workbook (not macro enabled) and not just the Upload tab as to keep track of daily information?
I.e. entire workbook to be saved but the new file to open on the upload tab as that is that tab that goes into the system in its new format.

(Note - originally recorded the macro and edited where I could. Hence the poorly written and lengthy code)

Thanks again
Devin

[bakerman2]

Please Login or Register  to view this content.

[devink]

Thanks mate.