Search:

Type: Posts; User: stimpsond1; Keyword(s):

Page 1 of 3 1 2 3

Search: Search took 0.00 seconds.

  1. I'm sorry, i dont understand, there is a macro...

    I'm sorry, i dont understand, there is a macro that does lots of stuff and this is just the peice of the code for the currency symbol.
  2. They dont need to select it, no matter where the...

    They dont need to select it, no matter where the sheet is opened up in the world i always want cells J:K to have the pund symbol and L:M to have the USD symbol. Currently the sheet changes the...
  3. VBA for currency symbols used on a single sheet in different locations

    Hi all,

    I have a spreadsheet which is used by people all over the world for my department. There are some issues with the currency symbol that is displayed depending if you are say in Hong Kong...
  4. Trying to create a cashflow formula but need it to also take due date and todays date into account

    Hi All,

    Iím trying to create a formula that will take into account the below for cash flow:

    As it stands the due date is the 24/07/14 and the week commencing date is 22/07/14 so the amount sits...
  5. Windows 7 Task Scheduler VB not calling excel macro but does when manually run

    Hi All,

    I have moved form a windows XP machine to window 7 and now have problems with the below. I have a VB script running which then call an excel macro, however, the excel does not work when...
  6. I think i have fixed this by adding the tick box...

    I think i have fixed this by adding the tick box to the developer macro settings in the trust centre - doh
  7. Hi Rory, I dont have the comment in my version...

    Hi Rory,

    I dont have the comment in my version think it may just be on here.

    The "STATEMENTS_MODULE" exists in the open workbook
    And the diredtory of C:\IDEA\ exists
    and the file name open is...
  8. I noticed it doesnt like to export the .bas file,...

    I noticed it doesnt like to export the .bas file, for some reason it doesnt create it:


    Const TEMPFILE As String = "C:\IDEA\IDEA EXCEL MACROS.bas" 'temp textfile
    ...
  9. .Bas file worked in XP but not in Windows 7 VBA Copy

    Hi,

    I had the below macro which worked fine on my windows xp machine, I have now changed to windows 7 and it doesnít appear to create the .bas file.

    I have exactly the same directories etc, any...
  10. Thanks Steve, Slighly confused so apolgies,...

    Thanks Steve,

    Slighly confused so apolgies, your macro goes on to run a pivot etc, i only want to pass a value into the ANS1 value and then run my macor and then at the end of my maco loop through...
  11. Hi, Thanks for the responces. Basically i...

    Hi,

    Thanks for the responces. Basically i have a macro that produces a statement of account for a client depending on what 5the user types in the message box (Ans1). Ans1 is then matched to the...
  12. Macro to run for each change in column B

    Hi All,

    I have created a macro that look at a sheet called global extract and puts a filter in column 2 and then prompts the user to enter a number which matches to column 2 and proceeds with the...
  13. Replies
    8
    Views
    412

    Formula issue.

    Hi All,

    I have a formula issue Iím hoping can be written without the need for VBA. No-one I have spoken to yet has been able to resolve it butÖ.. To date someone on here has always managed to...
  14. Hi Maud, thanks for the attached. Hi Zeddy, ...

    Hi Maud, thanks for the attached.

    Hi Zeddy,

    Please find the attached file as requested.

    The headings will be the same in each file, I can have the file names saved so we can always check for...
  15. Loop through excel files in a directory and copy onto master sheet

    Hi All,

    I have around 10-15 excel files in a folder which are refreshed each week. I need to loop through these files and copy the data form them into one master sheet.

    I plan to create the...
  16. VBA Currency format issues when users around the world run it

    Hi All,

    I have a sheet that users form Europe, Hong Kong and America use and it appears that the currency symbol changes if the user is not in the UK although the column fixed is for GBP.

    I can...
  17. Hi, I dont think iwas clear in my issue so...

    Hi,

    I dont think iwas clear in my issue so apolgies, but thasnks for replying.

    The network drive is in the US and we are based in London, just opening a file takes while due to the connection...
  18. Hi Zeddy, Thanks for the reply, i thought as...

    Hi Zeddy,

    Thanks for the reply, i thought as much, excel just likes to get the the end as quick as possible.

    I've tried the DoEvents command but no joy.

    I cant use the XLSB command as these...
  19. Opening a network excel file in VBA takes so long it prompts for password

    Morning All,

    I am opening 6 files in a share drive and then copying the contents onto 1 master book to continue my code. I have embeded the password into the code but as it takes so long to open...
  20. Thanks Rory, thought it was that but wanted to...

    Thanks Rory, thought it was that but wanted to Check.

    Zeddy, as would I, I just got back from the states and got 1.39 to the £ so not good...... budget exchange rates :)

    Thanks again
  21. Formula =[@[Asking price (sale currency)]]/1.58

    All,

    I have come across the baove formula in excel and whilst i think i understand it i cant seem to think why this would be any better the referring to A1 etc.

    A1 is called Asking price (sale...
  22. Replies
    2
    Views
    488

    Perfect Steve, I look at a number of...

    Perfect Steve,

    I look at a number of varioations of this but missed it... Thanks alot.

    Regards,
  23. Replies
    2
    Views
    488

    Can't delete the named range in VBA

    Hi All,

    I have a named range on a sheet called Info and then on multiple worksheets the named range SALE_NO is used in a VLOOKUP. I am trying to delete a named range called SALE_NO and then when...
  24. Rory, Once again you have come to my rescue,...

    Rory,

    Once again you have come to my rescue, we have a number or programs that run a number of reports and then spit out an unformatted version in excel which then need macros inbedded into them...
  25. Copy Macro Module from one worksheet to another and then assign it

    Hi All,

    I have managed to copy a macro module form one master workbook to another via the below code, my issue is i then want to create a sheet called statements which then has a form control box...
Results 1 to 25 of 52
Page 1 of 3 1 2 3