ExcelBanter - Copying Worksheet to Another Open Workbook

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/309956-re-copying-worksheet-another-open-workbook.html)

[email protected]

Copying Worksheet to Another Open Workbook

fStr would be a string containing something like
"thenameofthisfile.xls" - no path but with .xls
And yes the fStr is open

Dave Peterson[_3_]

Copying Worksheet to Another Open Workbook

Is the workbook protected (structure checked)?

" wrote:

fStr would be a string containing something like
"thenameofthisfile.xls" - no path but with .xls
And yes the fStr is open

--

Dave Peterson

Dave Peterson[_3_]

Copying Worksheet to Another Open Workbook

And I'd double check the workbook's name--maybe extra spaces in the variable,
but not the real name (or vice versa).

Dave Peterson wrote:

Is the workbook protected (structure checked)?

" wrote:

fStr would be a string containing something like
"thenameofthisfile.xls" - no path but with .xls
And yes the fStr is open

--

Dave Peterson

--

Dave Peterson

All times are GMT +1. The time now is 06:10 AM.