Thread: How to reference worksheet name with spaces?
View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
Jan Karel Pieterse Jan Karel Pieterse is offline
external usenet poster
  
Posts: 535
Default How to reference worksheet name with spaces?
Hi JE,

And with VBA5, you can use Application.Substitute()

Correct. Since we're talking Access VBA here it is
xlApp.WorksheetFunction.Substitute().

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com

Reply With QuoteReply With Quote