VBA Project Password

Excel Help for Vba Project Password in Excel Invoice Template

Forum Topic

Vba Project Password

Rate this:

(2/5 from 2 votes)

	Please could you tell me how I can find the VBA Project Password.
	Posted by leerat83 on 18 Sep 2009

Replies - Displaying 1 to 5 of 5

Order Replies By: Most Recent | Chronological | Highest Rated

	VBA Code Protection 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 Excel Helper on 01 Oct 2009

Customer import

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 jaw on 23 Aug 2011

	Importing customer information 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 Excel Helper on 23 Aug 2011

import customer information

Rate this:

(3/5 from 2 votes)

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 jaw on 24 Aug 2011

	Concatenating column data 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 Excel Helper on 24 Aug 2011

Displaying page 1 of 1

Excel templates and solutions matched for VBA Project Password:

Solutions: VBA Protection Password Remove VBA Password