I'm working in a pretty indepth macro. I was wondering two things:
#1.) I use a query in one sheet to get shipping data for the recentl
billed period by shipment numbers. I can figure the minimum an
maximum shipment numbers I should search for but I haven't figured ou
the way to get those values into the "Enter Parameter Value" inpu
boxes of the query. Is there a way to do this with VBA?
#2.) Once the query from part #1 has finished then the macro does
paste special of the data into the master sheet. Where I get th
"Number Stored as Text" exclamation point. Is there a way to get
VB
to trigger "Convert to Number" function of the "Number Stored as Test
warning?
After this the macro still has a lot of processing to do, so automatin
this is very important to this working properly.
I have tried recording both processes but the macro recorder does no
seem to cover these. Any help would be great appreciated :)
Thank you,
Jorda
--
Message posted from
http://www.ExcelForum.com