ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Export/Import + Copy issues (https://www.excelbanter.com/excel-programming/343468-export-import-copy-issues.html)

John Keith[_2_]

Export/Import + Copy issues
 
I am trying to copy a spreadsheet with VBA to a project that i have been
working on. The problem is that after exporting all the modules and then
copying the spreadsheet over to a "new" workbook and importing the modules...
the code will not work (it goes in to a seemingly infinite loop that I have
to break-out of)

I can take the example workbook and add my other modules to it and it works
perfectly. What portions of the project could I be missing when using the
import/export/copy method? (one difference I initially spotted was that the
copied worksheet required going into the "properties" window and renaming
sheet1 to the same name that I had edited on the sheet-tab) Before that was
done, there were missing variables.

--
Regards,
John


All times are GMT +1. The time now is 08:13 PM.

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