Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6
Default Excel 2007 Problems; in wrinting a macro and convert text

Hi,
in excel 2007 if macro name contains number (e.g. "sub gel06(value)") macro
does not work, why.
And in Text to Colums decimal and thousands seperator isn't converted to
excel seperators altough needed adjustments is made, why.
Thanks advance for your help...
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,726
Default Excel 2007 Problems; in wrinting a macro and convert text

It is probably because GEL is a valid column in 2007, so GEL06 could be seen
as a cell.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"bezl" wrote in message
...
Hi,
in excel 2007 if macro name contains number (e.g. "sub gel06(value)")
macro
does not work, why.
And in Text to Colums decimal and thousands seperator isn't converted to
excel seperators altough needed adjustments is made, why.
Thanks advance for your help...



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Excel 2003 Workbook I want to convert to Excel 2007 pglufkin Excel Discussion (Misc queries) 3 December 18th 06 08:06 PM
Convert Text to Numbers in a Macro denise Excel Worksheet Functions 3 September 13th 06 03:25 PM
Macro to Extract Text From Word Table Into Excel? V. Hatherley Excel Discussion (Misc queries) 1 August 27th 06 04:12 PM
Having macro convert text to numbers punter Excel Discussion (Misc queries) 3 June 13th 06 11:58 AM
Macro to convert text to date Nortos Excel Worksheet Functions 2 May 11th 05 10:42 AM


All times are GMT +1. The time now is 01:18 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"