Good afternoon,
I'm looking for a piece of code that will save as XLSM document as a XLSX to a specific location on the network and use the information in Cell B4 as the file name
can anyone help me with this please?
Thank you
DJ
Good afternoon,
I'm looking for a piece of code that will save as XLSM document as a XLSX to a specific location on the network and use the information in Cell B4 as the file name
can anyone help me with this please?
Thank you
DJ
I have this code now, but what do i need to add to the code to save it as XLSX?
Please Login or Register to view this content.
Can you save it as an xlsx just using excels normal interface? I thought if you tried to save something with macros as .xlsx it gave you an error.. Try using the macro recorder and see what it gives you.
Otherwise:
But like I say, I don't think that will work.Please Login or Register to view this content.
I can use the recorder to do most of what i want, but i would like it to pull the information from cell B4 as the file name when saving
Do you know how i can reference the cell B4 for the name?Please Login or Register to view this content.
perhaps
Please Login or Register to view this content.
Josie
if at first you don't succeed try doing it the way your wife told you to
Thank you very much
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks