Posted to microsoft.public.excel.programming

Stuart[_5_] Stuart[_5_] is offline

external usenet poster

Posts: 413

Type mismatch

Dimmer than usual this evening.......what am I missing:

Workbooks(wb).SaveAs "C:\BofQProject\QSBofQ _
\Projects\" & SaveDir & "\" & fName & ".xls"

where wb = NewQSBofQ.xls
SaveDir = TEST 910
fName = DUPES

Regards.

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.588 / Virus Database: 372 - Release Date: 13/02/2004

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Type Mismatch	[email protected]	Excel Worksheet Functions	1	May 16th 07 03:29 PM
type mismatch--how to fix	rroach	Excel Discussion (Misc queries)	2	July 14th 05 06:23 PM
Type mismatch	Steve Garman	Excel Programming	0	February 5th 04 07:39 AM
Type mismatch	Alan Beban[_4_]	Excel Programming	0	February 4th 04 08:39 PM
Type Mismatch	Phil Hageman[_3_]	Excel Programming	2	January 9th 04 06:11 PM

All times are GMT +1. The time now is 12:31 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us