+ Reply to Thread
Results 1 to 4 of 4

problem with " when reading formula's from the database.

  1. #1
    Registered User
    Join Date
    11-07-2012
    Location
    london
    MS-Off Ver
    Excel 2003
    Posts
    6

    problem with " when reading formula's from the database.

    Dear All, I created a simple macro which records cell content into the database regardless if this is value (i.e. 5.95) or a formula (+$B$3*$C$7). However if the formula contains some string manipulation (for example: "something"&named.value) then inserting it back into the cell triggers an error. I tried using \ (i.e. when reading from the database I transformed string into \"something\"&named.value) but this would return me an error.

    please help

  2. #2
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,208

    Re: problem with " when reading formula's from the database.

    Which database? and what's your code?

  3. #3
    Registered User
    Join Date
    11-07-2012
    Location
    london
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: problem with " when reading formula's from the database.

    database is MS SQL but this is not relevant. i need to do somthing about " wrapped in the main " clause

    Please Login or Register  to view this content.

  4. #4
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,208

    Re: problem with " when reading formula's from the database.

    You need to double quote, \ is not an escape character in VBA

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1