Hello,
I recently added a bit of code to an invoice system Excel Forum helped me create. It works fine on my PC but not on any other PC's which use it which run 2010. I've included the full macro below. The new section starts under 'Sales Ledger Input Code and finishes before print out. Please help!
Please Login or Register to view this content.
At what point does it fail? How does it fail? Is there an error message? If so, what is it? What line of code, if any, is highlighted? Have you stepped through the code using F8? If so, what happens?
Code looks ok but impossible to test without a file.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Like TMS above => "... impossible to test without a file ..." plus additionally what below:Originally Posted by Mark Dynes
1. Do not use "Date" and "Total" as variable names:
Date => it is VB "Statement / Function"
Total => it is "Property" for "ListColumn" object
(I also have concerns about "#" characters in variable names)
2. In your code for new files, e.g.:
you don't have "\" between the path and the value in "H4". Does it mean that you have this sign in "H4" ?Please Login or Register to view this content.
3. Check the modified code below and observe in which line the error will occur and what type ?
Please Login or Register to view this content.
Last edited by mjr veverka; 07-07-2020 at 06:10 PM.
Hi Trevor,
It fails at the first line which is highlighted in VBA. Using F8 doesn't move it through the code just rehighlights the same line of code. On executing the macro an error message pops up with 'Run-time error '70': Permission denied
THanks,
I will test this out and come back to you. Will try and get a file posted too.
Not sure which line you mean.It fails at the first line which is highlighted in VBA.
I used to live in Bramhall, not a million miles away from Stockport
It fails at 'Date = Sheets("SalesInvoice").Range("H3")' and won't move on through the rest at all on the other PC's.
As porucha vevrku said earlier, don't use Date = since that will attempt to set your system date. Use a different variable name.
Rory
OK Thanks Ill change that now! See how we go!
Yes that's fixed it!!!! Thanks guys! Onto the next mini project
You're welcome. Thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks