ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   save data in another workbook (https://www.excelbanter.com/excel-programming/346293-save-data-another-workbook.html)

Buddy Lee

save data in another workbook
 
I have one workbook with some VBA code and a lot of data and I need to save
some data from sheet1 to another user-defined workbook. I'll get filename
from GetOpenFilename method and than ?

--

icq 25372592



Stephane Rodriguez[_4_]

save data in another workbook
 

Hi,

You can get the original pic filenames, since those are not saved i
the Excel file along with the pic buffers themselves.

Your best bet is probably to store those in hidden cells, so that yo
can access them anytime in the future.

Hope this helps,

xlsgen - native Excel generator http://xlsgen.arstdesign.co

--
Stephane Rodrigue
-----------------------------------------------------------------------
Stephane Rodriguez's Profile: http://www.hightechtalks.com/m33
View this thread: http://www.hightechtalks.com/t229211



All times are GMT +1. The time now is 10:57 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com