Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-20-2011, 10:12 PM
evh evh is offline macros to excel Windows XP macros to excel Office 2003
Novice
macros to excel
 
Join Date: Jul 2011
Posts: 1
evh is on a distinguished road
Default macros to excel

Hi I use vba macros in excel to do certain data formatting. I am looking to convert vba macros to excel formulas so that anyone without vba knowledge can use it.

Part of macro statements are as below -

strOut = Format(108, "0000000000") ' form id
strOut = strOut & Format(n + 1000, "0000000000") ' sequence
strOut = strOut & Format (strId,"000000000000000000000000000000") ' prim key
strOut = strOut & "A" ' add new entry


strOut = strOut & Space(65) & vbTab

I have converetd all the statements using autofill for sequence and text function for rest. For example replace Space(65) with "" and placing 65 spaces between quotations. But I am not sure how i can print tab space in excel. Any help plesae ?
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macros nore Outlook 0 06-01-2011 04:39 PM
Oulook Deletes Emails Attached with Excel Files That Have Macros Slacker Outlook 4 01-24-2011 03:17 PM
macros to excel Macros Desertwrangler Word VBA 6 06-25-2010 07:06 AM
macros to excel Macros krdzal Excel 1 04-06-2010 07:43 AM
Excel 2003 SP3 bug when running Macros EnricoVenturi Excel 0 09-06-2009 08:11 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:02 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft