ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Copying Worksheet to Another Open Workbook (https://www.excelbanter.com/excel-programming/309963-re-copying-worksheet-another-open-workbook.html)

[email protected]

Copying Worksheet to Another Open Workbook
 
I also just checked and there are now spaces in the filename or
worksheet name (either in reality of in the line of code looking for
them)


Dave Peterson[_3_]

Copying Worksheet to Another Open Workbook
 
Toss in a couple of:

debug.print "**" & fstr & "**"
or even
msgbox "**" & fstr & "**"

to see if you get what you expect.

(I'm still thinking it was a typo in your variable names)


" wrote:

I also just checked and there are now spaces in the filename or
worksheet name (either in reality of in the line of code looking for
them)


--

Dave Peterson



All times are GMT +1. The time now is 04:13 AM.

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