Home > Forum Home > Excel Invoice Template > VBA Project Password Share

VBA Project Password

Excel Help for Vba Project Password in Excel Invoice Template


Forum TopicPost Reply Login

Vba Project Password

Rate this:
(3/5 from 1 vote)
ConfusedPlease could you tell me how I can find the VBA Project Password.

 Posted by on
 
Replies - Displaying 1 to 5 of 5Order Replies By: Most Recent | Chronological | Highest Rated
Surprised
Rate this:
(3/5 from 1 vote)
The VBA code has been protected to ensure the robustness of operation and for intellectual property purposes.

You do not require to modify the VBA code to obtain full functionality of the Customer Invoicing template.
 Excel Business Forums Administrator
 Posted by on
Confused
Rate this:
(3/5 from 1 vote)
If you want to change the customer information, for example you want to export you contacts from outlook and into the spredsheet. It comes with first and last name in its own boxes and the information is divided.
If you want the import to be correct regarding the file from outlook I think you have to change the way the customer registry is set up. I can add a colum with the information I want in the customer registry but I cant change the import without the VBA code? is this correct?
Jan
 Posted by on
Oops
Rate this:
(3/5 from 1 vote)
If columns are added the the Customers sheet, then the VBA driven import will not fill those columns.  For importing from Outlook, the best method is to first export the contacts as a CSV.  Then use the batch import tool on the Control sheet to import the CSV.  Here, you can move the columns up and down to match those required by the invoicing system.  Reimporting this way will also update customer information where changes are detected and customer information can also be exported back to CSV and imported to Outlook.
 Excel Business Forums Administrator
 Posted by on
Confused
Rate this:
(3/5 from 1 vote)
Ok
I have tried this with importing from a csv from outlook. and moving the colums to fit the import.
The problem is that my outlook export seperates the first and last name of the contact and there is differnt information for many of them extra phone numbers, delivery and visiting adress etc. so eaven if I move up and down the colums it will not fit failing already on the name.
so I then have to manually edit my excell to fit, and 1000+ contacts will take to long...
Is it a lot of work for you to make the import match the colums in the contact sheet?
or can I get access to the VBA so I can fix it myselfe.

The tool loks great but without matching my contact setup and wishes it will not match my needs..

jan
 Posted by on
Sad
Rate this:
(3/5 from 1 vote)
Another approach is to first import the CSV data into a new workbook.  Columns can be arranged according to the order of the Customers sheet in the invoicing system and data from several columns can be concatenated into one column such as first and last name to contact name.  The data can then be pasted into the Customers sheet and then an incremental number ID copied down the ID column.
 Excel Business Forums Administrator
 Posted by on
 Displaying page 1 of 1 

Excel templates and solutions matched for VBA Project Password:

Solutions: Scramble VBA Code VBA Protection Password Remove VBA Password