Use Code written in xlsm file to open .xls file and copy-paste data from xls to xlsm file

**kgiorgosss** · 05-21-2013, 04:30 AM

Hello guys, i just have a simple code in .xml file that opens a .xls files, selects a specific range, copies it and pastes it as values in the .xml file
The code opens the .xls file but then i recieve a Microsoft "Visual Basic 400" error.

Here is the code

Please Login or Register  to view this content.

any suggestions ?

**kgiorgosss** · 05-21-2013, 08:06 AM

anyone any ideas ?

**krabine** · 05-21-2013, 08:17 AM

in cell XDX2 is the location of file listed aswell? "C:\Users\You\My Documents\file.xls"

**kgiorgosss** · 05-21-2013, 08:22 AM

yes in cell XDX2 is the location of the file listed (the .xls file that has to open)

the code opens the file but it stops (no cells selected in the openned file)
and "Visual Basic 400" error appears on screen

Use Code written in xlsm file to open .xls file and copy-paste data from xls to xlsm file

LinkBack

Thread Tools

Rate This Thread

Display

Use Code written in xlsm file to open .xls file and copy-paste data from xls to xlsm file

Re: Use Code written in xlsm file to open .xls file and copy-paste data from xls to xlsm f

Re: Use Code written in xlsm file to open .xls file and copy-paste data from xls to xlsm f

Re: Use Code written in xlsm file to open .xls file and copy-paste data from xls to xlsm f

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions