LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 175
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Import Issues PiB311 Excel Worksheet Functions 0 September 14th 09 09:28 PM
Import & Export lj Excel Discussion (Misc queries) 1 May 13th 08 02:07 AM
Import External data Formatting issues ridawg Excel Discussion (Misc queries) 0 April 23rd 08 08:45 PM
import and export vba tango Excel Programming 2 November 10th 04 08:11 AM
Import and Export Todd Huttenstine[_3_] Excel Programming 3 April 30th 04 12:47 AM


All times are GMT +1. The time now is 04:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"